gCubeSystem
/
database-resource-manager
15
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity

Commit Graph

  • 417d3baec9 Updated descriptor.xml master v1.4.1 r4.24.0 Giancarlo Panichi 2020-06-11 14:46:11 +0200
  • bc398c00c7 ref 19423: DataMiner - Update DataMiner Service in Dev for support https Giancarlo Panichi 2020-06-10 17:00:45 +0200
  • ac76af4e26 ref 19423: DataMiner - Update DataMiner Service in Dev for support https Giancarlo Panichi 2020-06-10 16:48:41 +0200
  • f528422405 ref 19423: DataMiner - Update DataMiner Service in Dev for support https Giancarlo Panichi 2020-06-10 16:04:04 +0200
  • b71b6b8bf8 ref 18289: the latest wps doesn't work Giancarlo Panichi 2020-04-23 10:17:22 +0200
  • af6da69f5c Updated to Git and Jenkins Giancarlo Panichi 2019-11-28 18:48:59 +0100
  • dcf1b9a7fd Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 18:39:09 +0100
  • eb21bcc694 Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 18:35:05 +0100
  • 8b374384f2 Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 18:04:25 +0100
  • 87069d4b59 Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 17:34:10 +0100
  • 4d8e2b5db9 Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 17:27:01 +0100
  • e50b73cece Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 17:24:41 +0100
  • 5a065e86dc Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 16:00:27 +0000
  • 10c85e7bbf git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@183299 82a268e6-3cf1-43bd-a215-b396298e98cf Giancarlo Panichi 2019-11-27 15:59:12 +0000
  • 43a5c6fb4f Updated to Git and Jenkins Giancarlo Panichi 2019-11-27 15:58:52 +0000
  • ecd5ae7812 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@131255 82a268e6-3cf1-43bd-a215-b396298e98cf Gianpaolo Coro 2016-09-08 16:49:02 +0000
  • 92ee71b9a2 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@115371 82a268e6-3cf1-43bd-a215-b396298e98cf Fabio Sinibaldi 2015-06-12 16:03:31 +0000
  • 55eb8a0fb7 fixed dependency range Fabio Sinibaldi 2015-06-12 16:01:36 +0000
  • 9bed06ad26 symm.key file removed in package src/main/resources Loredana Liccardo 2014-12-15 11:41:12 +0000
  • f54b9259ab changelog file modified for release 3.5.1 Loredana Liccardo 2014-12-05 15:20:21 +0000
  • 3786920a6c - total number rows returned as output for the result of the submit Query operation:class DatabaseManagement modified Loredana Liccardo 2014-12-05 15:01:07 +0000
  • 167f0c1715 - writeSubmitResultIntoFile method modified removing special characters using regular expressions in order to write data in a file correctly. Loredana Liccardo 2014-12-04 16:30:22 +0000
  • 885a219fe1 Samplings and SubmitQuery changed in order to return as a result a map with column values truncated to 255 characters and a file with the whole columns values in order to manage so to manage big data properly and the conversion of a geometry data type in a multipolygon representation applying the function st_astext() for a database postgres. Sampler and DatabaseManagement classes changed. The file is stored on the statistical manager side and recovered through an ulr. pom file changed in 1.3.0 Loredana Liccardo 2014-11-28 11:54:54 +0000
  • 72b8e87e81 - method submitQuery modified in class DatabaseManagement in order to return a file and a map as output. The map is truncated to 1000 rows if the result has more than 1000 rows. method writeTableIntoFile reintroduced that performs the file writing and the map generation. - Version in pom file changed in 1.3.0 - method submitQuery modified in class DatabaseManagement adding the UUID string to the submitQuery result file QueryResult file. Loredana Liccardo 2014-11-19 14:38:18 +0000
  • 4e18e1cd99 - bug fixed in class Analyzing the query for keyword delete and update. space removed. Loredana Liccardo 2014-11-10 15:50:26 +0000
  • 0410564abd - bug fixed in class parseRegularExpressions. Change applied to parseRegularExpressions method replacing the \n character with a space. Loredana Liccardo 2014-11-10 14:22:34 +0000
  • 630d4beadc bug fixed for adb Postgres and related the explain function in order to compute the estimated rows of a table. Added a treshold with value 100000. If the rows computed with the explain function is < 100000 the counter function is used otherwise the explain result. DatabaseOperations class modified. Loredana Liccardo 2014-11-04 13:25:13 +0000
  • 8a06b5373b bug fixed for the submitQuery and sampling operation and related to column value truncated to 255 characters. If the final quote has been truncated the parsecvsstring method in the servlet does not work fine. Bug fixed adding the final quote. convertToJavaType method in DatabaseManagement class modified. Loredana Liccardo 2014-10-29 16:10:02 +0000
  • 17dfef9f1e - bug fixed in Sampler class in computeSmartSampleWithThreshold method. table name formatted as schema."table" in order to recover the rows Loredana Liccardo 2014-10-28 16:07:36 +0000
  • 81c8975e6a changelog file modified for release 3.5.0 Loredana Liccardo 2014-10-28 10:48:27 +0000
  • 52a940e840 changelog file modified for release 3.5.0 Loredana Liccardo 2014-10-28 10:48:03 +0000
  • 530a00d536 - bug fixed in class ConnectionManager for the submitquery operation modified in order to manage the data geometry recovering the related value as a sequence of hexadecimal characters and not as a parsed multipolygon value. executeQueryJDBC method modified. - bug fixed in class DatabaseManagement for the submitquery operation in order to truncate column values of the result to 255 character in convertToJavaType method Loredana Liccardo 2014-10-28 10:00:50 +0000
  • b7eba1b58f - for show create table statement column names returned with uppercase names. PostgresTableStructure class modified in order to remove toLowerCase() function applied on the column name. Loredana Liccardo 2014-10-27 16:29:04 +0000
  • 850c0072b9 - bug fixed and related to samplings operation to manage column uppercase names with a postgres database. Sampler class modified adding "" for a column for database postgres. Loredana Liccardo 2014-10-27 16:13:43 +0000
  • cba62f48f0 - method closeconnection in class DatabaseManager modified in order to close the SessionFactory. Loredana Liccardo 2014-10-24 16:44:30 +0000
  • 71cafbc5df some files updated in previous operations committed Loredana Liccardo 2014-10-16 09:09:52 +0000
  • 2f313cbbea - bug fixed and founded with the TabularData Database resource that has 2 access points with the same endpoint, username and password values. getAccessPoints method in DBResource class modified and equals method defined in AccessPoint class. DBResource, Normalizer, Decider e Guesser classes modified in order manage the exception generated in equals method. Exceptio managed also in algorithms (except ListNames) in database-rm-algorithms components. Loredana Liccardo 2014-10-16 09:06:28 +0000
  • 2986079369 e.printStackTrace added for debug purpose statement for an exception in executeQuery method Loredana Liccardo 2014-10-15 11:08:41 +0000
  • 9c42affe76 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99785 82a268e6-3cf1-43bd-a215-b396298e98cf Loredana Liccardo 2014-09-12 13:42:13 +0000
  • 6728db3c04 modification applied to the smartSampleOnTable method of class Sampler. If a table has o row return the exception with message "The table has 0 rows" Loredana Liccardo 2014-09-12 12:07:29 +0000
  • 77082fa4ad File DestinationDBHibernate.cfg.xml in "cfg" folder of the project renamed in DestinationDBHibernateDBManager.cfg.xml and correction in method initDBSession of the ConectionMannaager class in order to specify this file name. Loredana Liccardo 2014-09-10 07:57:17 +0000
  • b72e647ea8 bug fixed for the smart smapling (with table col2oct2010-> scientific_names). Corrections in computeSmartSampleWithThreshold method. Loredana Liccardo 2014-09-05 15:36:52 +0000
  • 5af78b2871 print result's size added in the executeQueryJDBC method in ConnectionManager class. pom file version modified from 1.0.0 to 1.1.0(for deploy) Loredana Liccardo 2014-09-05 10:02:23 +0000
  • 5be390fde8 parameters updated in the SubmitQuery method of DatabaseManagement class.(parameter on path file removed because unusable) Loredana Liccardo 2014-09-03 08:11:42 +0000
  • 1e191ee9f3 hibernate bug fixed and related to a join tables that have some columns with identical name. Bug resolved using JDBC. ConnectionManager and DatabaseManagement classes modified adding the method "executeQueryJDBC" in ConnectionManager, used only for the submitquery operation Loredana Liccardo 2014-09-02 13:14:58 +0000
  • ecee3f5fdf timeout for hibernate database connection changed to value 5 seconds.(corrections in ConnectionManager class and printfs added and commented in DatabaseFactory and DatabaseManagement classes) Loredana Liccardo 2014-09-01 14:45:00 +0000
  • 10488ac084 some printf commented in computeSmartSample and computeSmartSampleWithThreshold for Sampler class Loredana Liccardo 2014-09-01 11:00:32 +0000
  • 5d77f12fc9 bug fixed in calculation of table's details for a database postgres through the GetTableDetails algorithm. The calculateElements method in DatabaseOperations class has been modified adding "" for a table name. Loredana Liccardo 2014-08-29 12:37:42 +0000
  • 6942920792 bug fixed in sampling operations and resolved truncating each table'a attribute to 255 characters Loredana Liccardo 2014-08-29 11:51:09 +0000
  • 6ce1e4d44b bug fixed for sampling in class Sampler for a database mysql about an attribute of a table that could be a keyword.Quotes `` added for all attributes before submitting a query. Loredana Liccardo 2014-08-28 15:36:38 +0000
  • fe5b1c211b bug fixed in smart e random sampling for a database mysql Loredana Liccardo 2014-08-28 13:57:57 +0000
  • a2ea87687d - exception management for SQLGrammarException adding a cause message - method removeQueryExecution implemented and commented in class ConnectionManager Loredana Liccardo 2014-08-01 15:21:17 +0000
  • f790f715b7 bug fixed in Sampler and DatabaseOPerations classes to manage tables case sensitive for database Postgres Loredana Liccardo 2014-07-31 09:02:47 +0000
  • ab97ee8304 bug fixed in class DatabaseManagement: method writeSampleTableIntoFile replaced with method buildMapResult. Loredana Liccardo 2014-07-29 10:09:49 +0000
  • 78e9c6e288 Methods writeSampleTableIntoFile, writeQueryResultIntoFile, isHexadecimal removed because being commented were not used. Loredana Liccardo 2014-07-29 09:30:18 +0000
  • c202c94220 methods getFileQueryResult and getFileSampleTableResult commented. Methods writeSampleTableIntoFile and writeQueryResultIntoFile removed because being commented were not used. Loredana Liccardo 2014-07-29 09:26:38 +0000
  • 21d1bb5a27 class DatabaseManagement modified in order to not make available the result in a file csv for submitquery and samplings operations. Loredana Liccardo 2014-07-29 08:30:42 +0000
  • 6769c97a2d - the connection timeout of about 30 seconds has been managed with a GenericJDBCException. - exceptions managed in a different way in method executeQuery of Class ConnectionManager Loredana Liccardo 2014-07-25 13:49:09 +0000
  • 5f795e85d0 added a timeout about 25-20 seconds.To add the timeout the following classes are been modified: - class DatabaseFactory modified adding the initDBConnection method that overrides the properties contained in the hibernate.cfg.xml file. - method initDBSession in class ConnectionManager modified in order to use the DatabaseFactory (in package utils) Loredana Liccardo 2014-07-25 08:13:25 +0000
  • 229f351f7d bugs fixed in showcreatetable and samplings operations. In these operation it is useful to insert the table name in a query as "schema.table" for postgres and "db.table" for mysql. Loredana Liccardo 2014-07-23 15:11:58 +0000
  • aa3fbea54b bug fixed (updated the output result displayed from the statistical) in DatabaseManagement class related to the bug fixed yesterday. Loredana Liccardo 2014-07-22 12:58:20 +0000
  • 83df040993 bug fixed to retrieve columns names in a correct order (defined in the database schema) for the sampling operations, for the getTableDetails. Updates in Sampler, DatabasesManager and PostgresTableStructure classes. Loredana Liccardo 2014-07-21 15:19:55 +0000
  • 7762f7a162 bug corrected in "showCreateTable" method of MySQLTableStructure class (result managed in a correct way using aliasToEntityOrderedMapResultTransformer class). Bug fixed in "DatabaseManagement" class in "writeTableIntoFile" method to manage for SubmitQuery e sampling operations tables with one column. Loredana Liccardo 2014-07-21 10:57:49 +0000
  • ba20c2730e artifactid in pom file modified (for etics component) Loredana Liccardo 2014-06-10 17:16:03 +0000
  • f5068528fc files profile and changelog modified for etics configuration Loredana Liccardo 2014-06-10 13:21:07 +0000
  • c3da5a8a55 groupid changed in pom file for the project Loredana Liccardo 2014-06-10 08:55:44 +0000
  • 00f1af0de8 file pom modified to copy the file profile.xml from folder distro to target Loredana Liccardo 2014-06-09 15:02:35 +0000
  • 932f2390bb Folder "distro" added Loredana Liccardo 2014-06-09 13:22:06 +0000
  • 80435cf7e7 package org.gcube.dataanalysis.test removed Loredana Liccardo 2014-06-05 09:20:45 +0000
  • ce0e91da4a package org.gcube.dataanalysis.test renamed in org.gcube.dataaccess.test in src/test/java Loredana Liccardo 2014-06-05 09:16:28 +0000
  • fe61b11c54 some bug fixed in DatabasesResourcesManager class to recover a correct result from the submit query (in order to comply with AliasToEntityOrderedMapResultTransformer) Loredana Liccardo 2014-06-05 09:03:12 +0000
  • a655d2dabb deleted dataanalysis package Loredana Liccardo 2014-06-04 14:41:00 +0000
  • 0838508a28 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96622 82a268e6-3cf1-43bd-a215-b396298e98cf Loredana Liccardo 2014-06-04 14:32:59 +0000
  • 20227f444c git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96617 82a268e6-3cf1-43bd-a215-b396298e98cf Loredana Liccardo 2014-06-04 14:19:59 +0000
  • b4ebf6e789 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96616 82a268e6-3cf1-43bd-a215-b396298e98cf Loredana Liccardo 2014-06-04 14:13:44 +0000
  • e5c13f4050 move the library from data-analysis to data-access Loredana Liccardo 2014-06-04 13:56:35 +0000
  • cad254b98b Initial import. Loredana Liccardo 2014-06-04 13:53:17 +0000