[focketmail]

I am using Oracle 10g with JDBC/ODBC driver 9.2.x

when I click on the table in database explorer, it shows me all the columns but when I am generate Hibernate Mapping file, it give me “Generate Artifacts” error

Am I missing something in here??

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 com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration$1.readDatabaseSchema(MEJDBCMetaDataConfiguration.java:102)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:87)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfiguration.java:129)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$5.execute(GenerateArtifactsJob.java:405)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:68)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:400)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:266)
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:170)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:212)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:275)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:4691)
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)
… 11 more

[Riyad Kalla]

Can you paste the result of MyEclipse > About > Configuration Summary for us (not the one from Help > About), that will give us a jumping off point.

Also I noticed in the stack trace:

Caused by: java.sql.SQLException: Invalid column name

Do you have a strangely named column in that table by chance?

[bradkagawa]

HI,

I am getting the same error on attempting to export a existing table to hibernate. Please advise.

How do I configure the catalog ?

RD

<?xml version=”1.0″ encoding=”UTF-8″?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC “-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN” “http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd&#8221; >

<hibernate-reverse-engineering>
<table name=”AEBB_CATEGORY” schema=”THCUSER” class=”AEBBCategory”>
<primary-key>
<generator class=”hilo”></generator>
<column name=”CATEGORY_ID” jdbc-type=”VARCHAR” property=”CATEGORY_ID” type=”String” />
</primary-key>
<column name=”IW_STATE” jdbc-type=”VARCHAR” property=”IW_STATE” type=”String” />
<column name=”CATEGORY_TITLE” jdbc-type=”VARCHAR” property=”CATEGORY_TITLE” type=”String” />
<column name=”PATH” jdbc-type=”VARCHAR” property=”PATH” type=”String” />
</table>
<table name=”PERSON_DATA” schema=”THCUSER” class=”PersonData”>
<primary-key>
<generator class=”hilo”></generator>
<column name=”ID_PERSON_DATA” jdbc-type=”NUMERIC” property=”IDPERSONDATA” type=”Integer” />
</primary-key>
<column name=”DATA” jdbc-type=”VARCHAR” property=”DATA” type=”String” />
<column name=”ID_PERSON_DATA_TYPE” jdbc-type=”NUMERIC” property=”IDPERSONDATATYPE” type=”Integer” />
</table>
</hibernate-reverse-engineering>

org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:THCUSER
Configured catalog:null
Available schemas:
ANONYMOUS
CTXSYS
DBSNMP
DIP
FLOWS_020100
FLOWS_FILES
HR
MDSYS
OUTLN
SYS
SYSTEM
THCUSER
TSMSYS
XDB
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 com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration$1.readDatabaseSchema(MEJDBCMetaDataConfiguration.java:102)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:87)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfiguration.java:129)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$5.execute(GenerateArtifactsJob.java:405)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:68)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:400)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:266)
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:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5153)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:79)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:47)
… 11 more

[Brian Fernandes]

Brad,

Can you please answer all questions asked here?Posting Guidelines

Also, if you’re using Oracle, you’re probably seeing this error because you’re using classes12.jar as your driver. Upgrade to ojdbc14.jar and this problem should go away.

Best,
Brian.

[Author]

Posts