File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Trouble Using HSQLDB using myEclipse Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Trouble Using HSQLDB using myEclipse" Watch "Trouble Using HSQLDB using myEclipse" New topic
Author

Trouble Using HSQLDB using myEclipse

Angan Sen
Greenhorn

Joined: Jun 18, 2010
Posts: 10
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.




[Thumbnail for Untitled.png]

Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19760
    
  20

Moving to JDBC.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Angan Sen
Greenhorn

Joined: Jun 18, 2010
Posts: 10
Rob Prime wrote:Moving to JDBC.

Sorry I did not understand you? please explain a bit.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30919
    
158

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Angan Sen
Greenhorn

Joined: Jun 18, 2010
Posts: 10
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Trouble Using HSQLDB using myEclipse