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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3928290#3928290 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3928290 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
