0 Replies Latest reply on Jul 4, 2006 6:04 AM by Christoph Rooms

    hsql problems with Hibernate Tools 3.1.0 beta 5

    Christoph Rooms Newbie

      I 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)