Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-29

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.2
    • 3.3
    • Test Project
    • None

    Description

      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.

      Attachments

        1. patch.hsqldb.project.properties
          0.7 kB
          Patrick Carl

        Activity

          People

            tfischer Thomas Fox
            carlptr Patrick Carl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: