You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Patrick Carl (JIRA)" <ji...@apache.org> on 2006/06/16 21:53:30 UTC

[jira] Created: (TORQUE-29) Fix "Database already in use" exception when running hsqldb test profile

Fix "Database already in use" exception when running hsqldb test profile
------------------------------------------------------------------------

         Key: TORQUE-29
         URL: http://issues.apache.org/jira/browse/TORQUE-29
     Project: Torque
        Type: Bug

  Components: Test Project  
    Reporter: Patrick Carl
    Priority: Minor


When running the test-project with the hsqldb profile, the following exception occurs: 
java.sql.SQLException: The database is already in use by another process

The reason is, that the profile uses a file based database which is not shut down after each tests. Therefore its lock file is not removed. This bug enhances the hsqldb profile project.properties file and adds the parameter "shutdown=true" to each connection URL. So the database is shut down when the last connection to it is closed. So the exception does not occur any more.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


[jira] Updated: (TORQUE-29) Fix "Database already in use" exception when running hsqldb test profile

Posted by "Patrick Carl (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/TORQUE-29?page=all ]

Patrick Carl updated TORQUE-29:
-------------------------------

    Attachment: patch.hsqldb.project.properties

Enhanced hsqldb profile for test project

> Fix "Database already in use" exception when running hsqldb test profile
> ------------------------------------------------------------------------
>
>          Key: TORQUE-29
>          URL: http://issues.apache.org/jira/browse/TORQUE-29
>      Project: Torque
>         Type: Bug

>   Components: Test Project
>     Reporter: Patrick Carl
>     Priority: Minor
>  Attachments: patch.hsqldb.project.properties
>
> When running the test-project with the hsqldb profile, the following exception occurs: 
> java.sql.SQLException: The database is already in use by another process
> The reason is, that the profile uses a file based database which is not shut down after each tests. Therefore its lock file is not removed. This bug enhances the hsqldb profile project.properties file and adds the parameter "shutdown=true" to each connection URL. So the database is shut down when the last connection to it is closed. So the exception does not occur any more.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


[jira] Updated: (TORQUE-29) Fix "Database already in use" exception when running hsqldb test profile

Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/TORQUE-29?page=all ]

Thomas Fischer updated TORQUE-29:
---------------------------------

    Fix Version: 3.2.1
        Version: 3.2

> Fix "Database already in use" exception when running hsqldb test profile
> ------------------------------------------------------------------------
>
>          Key: TORQUE-29
>          URL: http://issues.apache.org/jira/browse/TORQUE-29
>      Project: Torque
>         Type: Bug

>   Components: Test Project
>     Versions: 3.2
>     Reporter: Patrick Carl
>     Priority: Minor
>      Fix For: 3.2.1
>  Attachments: patch.hsqldb.project.properties
>
> When running the test-project with the hsqldb profile, the following exception occurs: 
> java.sql.SQLException: The database is already in use by another process
> The reason is, that the profile uses a file based database which is not shut down after each tests. Therefore its lock file is not removed. This bug enhances the hsqldb profile project.properties file and adds the parameter "shutdown=true" to each connection URL. So the database is shut down when the last connection to it is closed. So the exception does not occur any more.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


[jira] Resolved: (TORQUE-29) Fix "Database already in use" exception when running hsqldb test profile

Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/TORQUE-29?page=all ]
     
Thomas Fischer resolved TORQUE-29:
----------------------------------

    Resolution: Fixed
     Assign To: Thomas Fischer

> Fix "Database already in use" exception when running hsqldb test profile
> ------------------------------------------------------------------------
>
>          Key: TORQUE-29
>          URL: http://issues.apache.org/jira/browse/TORQUE-29
>      Project: Torque
>         Type: Bug

>   Components: Test Project
>     Versions: 3.2
>     Reporter: Patrick Carl
>     Assignee: Thomas Fischer
>     Priority: Minor
>      Fix For: 3.2.1
>  Attachments: patch.hsqldb.project.properties
>
> When running the test-project with the hsqldb profile, the following exception occurs: 
> java.sql.SQLException: The database is already in use by another process
> The reason is, that the profile uses a file based database which is not shut down after each tests. Therefore its lock file is not removed. This bug enhances the hsqldb profile project.properties file and adds the parameter "shutdown=true" to each connection URL. So the database is shut down when the last connection to it is closed. So the exception does not occur any more.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


[jira] Closed: (TORQUE-29) Fix "Database already in use" exception when running hsqldb test profile

Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/TORQUE-29?page=all ]

Thomas Vandahl closed TORQUE-29.
--------------------------------


> Fix "Database already in use" exception when running hsqldb test profile
> ------------------------------------------------------------------------
>
>                 Key: TORQUE-29
>                 URL: http://issues.apache.org/jira/browse/TORQUE-29
>             Project: Torque
>          Issue Type: Bug
>          Components: Test Project
>    Affects Versions: 3.2
>            Reporter: Patrick Carl
>         Assigned To: Thomas Fischer
>            Priority: Minor
>             Fix For: 3.3
>
>         Attachments: patch.hsqldb.project.properties
>
>
> When running the test-project with the hsqldb profile, the following exception occurs: 
> java.sql.SQLException: The database is already in use by another process
> The reason is, that the profile uses a file based database which is not shut down after each tests. Therefore its lock file is not removed. This bug enhances the hsqldb profile project.properties file and adds the parameter "shutdown=true" to each connection URL. So the database is shut down when the last connection to it is closed. So the exception does not occur any more.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org