You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Amila Jayasekara (JIRA)" <ji...@apache.org> on 2013/10/17 22:46:43 UTC
[jira] [Resolved] (AIRAVATA-930) Airavata Security Implementation
failing because of existing database
[ https://issues.apache.org/jira/browse/AIRAVATA-930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amila Jayasekara resolved AIRAVATA-930.
---------------------------------------
Resolution: Fixed
Fixed in 1533257.
Thanks
Thejaka Amila
> Airavata Security Implementation failing because of existing database
> ---------------------------------------------------------------------
>
> Key: AIRAVATA-930
> URL: https://issues.apache.org/jira/browse/AIRAVATA-930
> Project: Airavata
> Issue Type: Bug
> Components: Security
> Affects Versions: 0.10
> Reporter: Raminderjeet Singh
> Assignee: Amila Jayasekara
>
> Test fails with following error.
> Running org.apache.airavata.security.userstore.SessionDBUserStoreTest
> [main] ERROR org.apache.airavata.common.utils.DBUtil - An error occurred while closing database connections
> java.sql.SQLException: Cannot close a connection while a transaction is still active.
> at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> at org.apache.derby.client.am.Connection.closeResourcesX(Unknown Source)
> at org.apache.derby.client.am.Connection.closeX(Unknown Source)
> at org.apache.derby.client.net.NetConnection.closeX(Unknown Source)
> at org.apache.derby.client.am.Connection.close(Unknown Source)
> at org.apache.derby.client.net.NetConnection.close(Unknown Source)
> at org.apache.derby.client.net.NetConnection40.close(Unknown Source)
> at org.apache.airavata.common.utils.DBUtil.executeSQL(DBUtil.java:174)
> at org.apache.airavata.common.utils.DatabaseTestCases.executeSQL(DatabaseTestCases.java:106)
> at org.apache.airavata.security.userstore.SessionDBUserStoreTest.setUpDatabase(SessionDBUserStoreTest.java:51)
> Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a transaction is still active.
> at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source)
> ... 31 more
> Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.131 sec <<< FAILURE!
> Results :
> Tests in error:
> org.apache.airavata.security.userstore.JDBCUserStoreTest: Table/View 'AIRAVATA_USER' already exists in Schema 'ADMIN'.
> org.apache.airavata.security.userstore.SessionDBUserStoreTest: Table/View 'PERSONS' already exists in Schema 'ADMIN'.
--
This message was sent by Atlassian JIRA
(v6.1#6144)