Can not generate Seam entity

[amir22651]

Hi all,

I have followed the CRUD tutorial (Chapter 13. Generate a CRUD Database Application) and when I reached to the point that I should be able to generate the seam entities from reverse engineering, the following error raises. I appreciate any help.

Can't generate seam entities

  org.hibernate.exception.GenericJDBCException: Getting database metadata

  Getting database metadata

    org.hibernate.exception.GenericJDBCException: Getting database metadata

    Getting database metadata

    java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9ca0eb04[file =/usr/local/jbdevstudio/studio/jdbc:hsqldb:hsql:/localhost:1701.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-01-13 04:47:50 heartbeat - read: -5183 ms.

    Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9ca0eb04[file =/usr/local/jbdevstudio/studio/jdbc:hsqldb:hsql:/localhost:1701.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-01-13 04:47:50 heartbeat - read: -5183 ms.

    org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9ca0eb04[file =/usr/local/jbdevstudio/studio/jdbc:hsqldb:hsql:/localhost:1701.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-01-13 04:47:50 heartbeat - read: -5183 ms.

    Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9ca0eb04[file =/usr/local/jbdevstudio/studio/jdbc:hsqldb:hsql:/localhost:1701.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-01-13 04:47:50 heartbeat - read: -5183 ms.

[tremes]

Hi! What is your database connection url? It looks like you have more processes running and trying to access database. I'd try to restart database and server as well.

[amir22651]

Dear Tomas,

connection URL is as follow:

<connection-url>jdbc:hsqldb:jdbc:hsqldb:hsql://localhost:1701</connection-url>

and no other processes are involving with the database.

[tremes]

Well it's likely wrong. See e.g http://hsqldb.org/doc/guide/dbproperties-chapt.html. IMO it should be something like:

<connection-url>jdbc:hsqldb:hsql://localhost:1701/<"your_db_name"></connection-url>

[amir22651]

I did it. same error still exist. weird!

[tremes]

Are you able to connect to your database using some client like sqlworkbench, sqldeveloper or similar? Are there your entities you would like to create by reverse engineering? If yes, then it should also work from JBoss Tools.