Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Trouble Using HSQLDB using myEclipse

 
Angan Sen
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have create a data base using Myeclipse database explorer, however I am not able to connect to that database. I am getting the following error,


" 2010-06-27T21:39:58.250+0530 SEVERE could not reopen database
org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@8e64f300[file =null, exists=false, locked=false, valid=false, ] method: setPath reason: java.io.IOException: The filename, directory name, or volume label syntax is incorrect
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at cellTest.TestDB.main(TestDB.java:39)

java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@8e64f300[file =null, exists=false, locked=false, valid=false, ] method: setPath reason: java.io.IOException: The filename, directory name, or volume label syntax is incorrect
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
SQL Exception
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at cellTest.TestDB.main(TestDB.java:39)
Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@8e64f300[file =null, exists=false, locked=false, valid=false, ] method: setPath reason: java.io.IOException: The filename, directory name, or volume label syntax is incorrect
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
... 6 more
"

I have also added the the screenshot of the myeclipse window.


Please help me to resolve this issue. I need it very soon.

Untitled.png
[Thumbnail for Untitled.png]
Myeclipse window capture for detailed Idea
 
Rob Spoor
Sheriff
Pie
Posts: 20532
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC.
 
Angan Sen
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rob Prime wrote:Moving to JDBC.

Sorry I did not understand you? please explain a bit.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Angan,
Welcome to JavaRanch!

Rob was pointing out we have a variety of forums here at JavaRanch. Your question fits better in the JDBC/Database one than wherever it started out (IDEs?) so he moved it for you. He also told you about it so next time you have a database question, you go right to the JDBC forum.

On to your question: where do you set up the hsql database? Are there any special characters in the path/configuration info?
 
Angan Sen
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jeanne,

Thanks for explaining, it was my mistake, thanks to Rob too.

I kept the hsql db under src/db undet my myeclipse project folder. and there was no special character.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic