hsql problems with Hibernate Tools 3.1.0 beta 5
christophrooms Jul 4, 2006 6:04 AMI got hibernate tools working connecting to a mysql database.
Now i try to get it working with HSQL database, but just don't get there.
i'm using this url :
jdbc:hsqldb:file:C:/sandwich/sandwich
This URL works when connecting from a java class file.
When using this url, i will get this error in eclipse consoleLog ...
!MESSAGE java.sql.SQLException: File input/output error: file:///C:/sandwich/sandwich.properties java.io.FileNotFoundExc eption: file:\C:\sandwich\sandwich.properties (The filename, directory name, or volume label syntax is incorrect) !STACK 0 java.sql.SQLException: File input/output error: file:///C:/sandwich/sandwich.properties java.io.FileNotFoundException: f ile:\C:\sandwich\sandwich.properties (The filename, directory name, or volume label syntax is incorrect) at org.hsqldb.Trace.getError(Trace.java:238) at org.hsqldb.Trace.error(Trace.java:325) at org.hsqldb.HsqlDatabaseProperties.save(HsqlDatabaseProperties.java:218) at org.hsqldb.Log.create(Log.java:639) at org.hsqldb.Log.open(Log.java:244) at org.hsqldb.Database$Logger.openLog(Database.java:2623) at org.hsqldb.Database.open(Database.java:226) at org.hsqldb.Database.<init>(Database.java:188) at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:2886) at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:2465) at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:167) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:1 10) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getConnection(JDBCMetaDataDialect.java:294) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getMetaData(JDBCMetaDataDialect.java:58) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:70) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:404) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:68) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbe nchAdapter.java:76) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSch emaWorkbenchAdapter.java:67) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWork benchAdapter.java:36) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWork benchAdapter.java:28) at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.jav a:69) at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)