gCubeSystem
/
database-resource-manager
16
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
77 Commits 1 Branch 2 Tags 213 KiB
Commit Graph

77 Commits

Author SHA1 Message Date
Loredana Liccardo fe5b1c211b bug fixed in smart e random sampling for a database mysql 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99333 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-08-28 13:57:57 +00:00
Loredana Liccardo a2ea87687d - exception management for SQLGrammarException adding a cause message 
- method removeQueryExecution implemented and commented in class ConnectionManager

git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99191 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-08-01 15:21:17 +00:00
Loredana Liccardo f790f715b7 bug fixed in Sampler and DatabaseOPerations classes to manage tables case sensitive for database Postgres 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99145 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-31 09:02:47 +00:00
Loredana Liccardo ab97ee8304 bug fixed in class DatabaseManagement: method writeSampleTableIntoFile replaced with method buildMapResult. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99060 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-29 10:09:49 +00:00
Loredana Liccardo 78e9c6e288 Methods writeSampleTableIntoFile, writeQueryResultIntoFile, isHexadecimal removed because being commented were not used. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99059 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-29 09:30:18 +00:00
Loredana Liccardo c202c94220 methods getFileQueryResult and getFileSampleTableResult commented. 
Methods writeSampleTableIntoFile and writeQueryResultIntoFile removed because being commented were not used.

git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99055 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-29 09:26:38 +00:00
Loredana Liccardo 21d1bb5a27 class DatabaseManagement modified in order to not make available the result in a file csv for submitquery and samplings operations. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@99051 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-29 08:30:42 +00:00
Loredana Liccardo 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

git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98992 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-25 13:49:09 +00:00
Loredana Liccardo 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) 

git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98967 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-25 08:13:25 +00:00
Loredana Liccardo 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. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98907 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-23 15:11:58 +00:00
Loredana Liccardo aa3fbea54b bug fixed (updated the output result displayed from the statistical) in DatabaseManagement class related to the bug fixed yesterday. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98872 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-22 12:58:20 +00:00
Loredana Liccardo 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. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98845 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-21 15:19:55 +00:00
Loredana Liccardo 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.

git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@98835 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-07-21 10:57:49 +00:00
Loredana Liccardo ba20c2730e artifactid in pom file modified (for etics component) 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@97257 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-10 17:16:03 +00:00
Loredana Liccardo f5068528fc files profile and changelog modified for etics configuration 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@97214 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-10 13:21:07 +00:00
Loredana Liccardo c3da5a8a55 groupid changed in pom file for the project 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@97167 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-10 08:55:44 +00:00
Loredana Liccardo 00f1af0de8 file pom modified to copy the file profile.xml from folder distro to target 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@97145 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-09 15:02:35 +00:00
Loredana Liccardo 932f2390bb Folder "distro" added 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@97132 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-09 13:22:06 +00:00
Loredana Liccardo 80435cf7e7 package org.gcube.dataanalysis.test removed 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96727 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-05 09:20:45 +00:00
Loredana Liccardo ce0e91da4a package org.gcube.dataanalysis.test renamed in org.gcube.dataaccess.test in src/test/java 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96726 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-05 09:16:28 +00:00
Loredana Liccardo fe61b11c54 some bug fixed in DatabasesResourcesManager class to recover a correct result from the submit query (in order to comply with AliasToEntityOrderedMapResultTransformer) 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96724 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-05 09:03:12 +00:00
Loredana Liccardo a655d2dabb deleted dataanalysis package 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96627 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-04 14:41:00 +00:00
Loredana Liccardo 0838508a28 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96622 82a268e6-3cf1-43bd-a215-b396298e98cf 2014-06-04 14:32:59 +00:00
Loredana Liccardo 20227f444c git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96617 82a268e6-3cf1-43bd-a215-b396298e98cf 2014-06-04 14:19:59 +00:00
Loredana Liccardo b4ebf6e789 git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96616 82a268e6-3cf1-43bd-a215-b396298e98cf 2014-06-04 14:13:44 +00:00
Loredana Liccardo e5c13f4050 move the library from data-analysis to data-access 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96611 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-04 13:56:35 +00:00
Loredana Liccardo cad254b98b Initial import. 
git-svn-id: https://svn.d4science.research-infrastructures.eu/gcube/trunk/data-access/DatabasesResourcesManager@96609 82a268e6-3cf1-43bd-a215-b396298e98cf
 2014-06-04 13:53:17 +00:00