[jboss-user] [JBoss Tools (users)] - Re: Hibernate Configurations problem

[asookazian]

Ok, so now these are the errors I'm getting with the booking project:

eclipse.buildId=M20090107-0800
  | java.version=1.5.0_17
  | java.vendor=Sun Microsystems Inc.
  | BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
  | Command-line arguments:  -os win32 -ws win32 -arch x86
  | 
  | 
  | Error
  | Wed Mar 11 13:32:20 PDT 2009
  | org.hibernate.exception.JDBCConnectionException: Getting database metadata
  | 
  | org.hibernate.exception.JDBCConnectionException: Getting database metadata
  | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
  | at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:64)
  | at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java:163)
  | at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
  | at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
  | at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
  | at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$2.execute(LazyDatabaseSchemaWorkbenchAdapter.java:114)
  | at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
  | at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:105)
  | at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:61)
  | at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:105)
  | at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
  | at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
  | Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile at b14f5d0b[file =C:\java\jbdevstudio-2.0.0.CR2\jboss-eap\jboss-as\server\default\data\hypersonic.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\java\jbdevstudio-2.0.0.CR2\jboss-eap\jboss-as\server\default\data\hypersonic.lck
  | at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  | at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
  | at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
  | at org.hsqldb.jdbcDriver.connect(Unknown Source)
  | at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
  | at java.sql.DriverManager.getConnection(DriverManager.java:525)
  | at java.sql.DriverManager.getConnection(DriverManager.java:140)
  | at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  | at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java:122)
  | at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:61)
  | ... 11 more
  | 

Previously, I had started the HSQL manager from the web console after I started JBoss AS from the IDE.  Subsequently, I restarted JBDS, JBoss is not running.  I still am getting that lock error.  I have no clue what is locking it as I have only one JVM running (java.exe) as per my windows task mgr.

NOTE: The hibernate-console.properties did not exist when I imported the booking project as a java project.  It created a blank hibernate.properties for me so then I had to go copy the contents and tweak settings from my other project.  This properties file should not be blank, at minimum it should prompt the user to fill out a form in a wizard or copy it from somewhere.  I was getting "Could not locate TransactionManager" error but now that's fixed.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4217168#4217168

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4217168