Problems running Hibernate Code Generation
I'm attempting to generate some code based on our existing database and am having problems. It appears that I have everything setup properly, but am hitting a road block! ;-)
Anyhow, I'm following the example at
http://www.jboss.com/products/seam/SeamHBTools.html
Our database is ORACLE, so I've modified the settings where applicable. When I attempt to configure the tables and try the "Refresh" the schemas, nothing happens. Further investigation into my ~/workspace/.metadata/.log shows the following stack trace:
!ENTRY org.hibernate.eclipse.console 4 4 2006-03-06 16:07:39.56 !MESSAGE Problem while reading database schema !STACK 0 org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem. Configured schema:ROUTER_USER Configured catalog:DB01 Available schemas: AEP_USER ALGY_USER APP_STAT APP_USER AUS_USER AUTO_TELOR BGE_USER BILLUSER CAL_USER CAR_USER CATHI CDR_USER CGE_USER CIN_USER CLEC_USER CLK_USER CMANAGER COL_USER COMED CPL_USER CUSTDB_USER DBSNMP DEL_USER DET_USER DISPATCHER DOM_USER DPL_USER DQE_USER DUKE_USER ERC_USER EUG_USER FIR_USER FLI_USER FOO_USER FPC_USER FPL_USER GAR_USER GMP_USER GRY_USER GSA_USER HCE_USER HRP_USER HUD_USER INDE_USER IVR_USER JAX_USER JDBC JEAN KCP_USER KUB_USER LAK_USER LAN_USER LES_USER LISA LKY_USER LOAD_USER MAX_USER MEC_USER MEM_USER NATALIE NEU_USER NIE_USER NLR_USER NPP_USER NST_USER OBJ_USER OPD_USER OUTLN PAC_USER PE2_USER PEC_USER PED_USER PEP_USER PWC_USER RED_USER REL_USER REPADMIN REP_USER ROUTER_APPU ROUTER_USER SCEG_USER SCOTT SCP_USER SCS_USER SDB_USER SDE SDEDATA SFW_USER SMU_USER SOH_USER SQL_USER SRP_USER SWC_USER SYS SYSTEM TES_USER TEX_USER TFC_USER TRACESVR TSB_APP TSB_USER UCS_APPU UCS_USER UCU_USER UEL_USER UOP_USER VOI_USER WSR_USER WWW_USER Available catalogs: at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.handleSQLException(JDBCMetaDataDialect.java:86) at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:50) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:400) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:65) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:79) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:70) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:39) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:31) at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:70) at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76) Caused by: java.sql.SQLException: Invalid column name at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:274) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:4541) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:666) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1374) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:79) at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:47) ... 10 more !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2006-03-06 16:07:39.56 !MESSAGE java.sql.SQLException: Invalid column name !STACK 0 java.sql.SQLException: Invalid column name at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:274) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:4541) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:666) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1374) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:79) at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:47) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:400) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:65) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:79) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:70) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:39) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:31) at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:70) at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76) !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2006-03-06 16:07:39.57 !MESSAGE java.sql.SQLException: Invalid column name !STACK 0 java.sql.SQLException: Invalid column name at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:274) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:4541) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:666) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1374) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:79) at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:47) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:400) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:65) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:79) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:70) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:39) at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:31) at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:70) at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)
Obviously, it is connecting from my perspective due to the fact that it is pulling all of the database schemas. I've also included the same Oracle JAR that I use for testing and installed in JBoss AS.
Any ideas?
Thanks,
Joshua Preston
