[Closed] generating artifacts error during hibernate mapping

MyEclipse Archived

Database Tools (DB Explorer, Hibernate, etc.)

This topic has 10 replies, 4 voices, and was last updated 18 years, 10 months ago by Haris Peco.

Viewing 11 posts - 1 through 11 (of 11 total)

Author

Posts
August 11, 2006 at 3:58 am #256561 Reply

fisheer
Member

eclipse: 3.1
myeclipse: 4.1.1GA_E3.1.exe
database: oracle9i

when I create hibernate mapping,there is a internal error during “generating artifacts “.
_________________________________________________________________________
the error logs:(Chinese user,so there are some disorder codes)
!ENTRY org.eclipse.core.runtime 4 2 2006-08-11 15:53:44.782
!MESSAGE 鍦ㄢ?淕enerating Artifacts鈥濇湡闂村彂鐢熶簡鍐呴儴閿欒銆?
!STACK 0
org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:HR
Configured catalog:null
Available schemas:
ANONYMOUS
CTXSYS
DBSNMP
HR
MDSYS
ODM
ODM_MTR
OE
OLAPSYS
ORDPLUGINS
ORDSYS
OUTLN
PM
POWERINFO
QS
QS_ADM
QS_CB
QS_CBADM
QS_CS
QS_ES
QS_OS
QS_WS
RMAN
SCOTT
SH
SYS
SYSTEM
WKPROXY
WKSYS
WMSYS
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: 鍒楀悕鏃犳晥
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:5278)
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
______________________________________________________________________________

but my classmates can use this faction in the same soft configurations.

I can see db browser data!

August 11, 2006 at 5:05 am #256564

Haris Peco
Member

Fisheer ,

Please, can you translate this :
Caused by: java.sql.SQLException: 鍒楀悕鏃犳晥

Sorry, I don’t know Chinese

Thanks
Peco

August 15, 2006 at 6:23 am #256785

ifmEssen
Participant

We are experiencing the same error:

org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:DATAHUB
Configured catalog:null
Available schemas:
ANONYMOUS
CC
DATAHUB
DATAHUB_LESEN
DATAHUB_TEST
DBSNMP
DEFUERHE
DWH
DWHADMIN
DWHADMIN_FINANCE
DWH_ADMIN
DWH_LESEN
DWH_TT
ESHOP_2_0
FINANCE
INTADM
KETTLE
MAILIMPORT
MDSYS
MONDRIAN
ORDPLUGINS
ORDSYS
OUTLN
QUARTZ
REPORTNET
RMAN
STAGING
SYS
SYSTEM
USA_RO
VERSAND
WMSYS
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:134)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$6.execute(GenerateArtifactsJob.java:514)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:70)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:509)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:293)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
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:4549)
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

August 15, 2006 at 7:08 am #256790

Haris Peco
Member

ifmEssen ,

Your problem si jdbc driver (I suppose that you use classes12.zip from 8.1.7).This jdbc driver version have bug
for getTables.

Please upgrade jdbc driver to some version 9 or 10 driver (it works with >= 8.1.7 database)

This is link for download jdbc driver http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Best
Peco

August 15, 2006 at 7:14 am #256791

ifmEssen
Participant

It works for us now! Thanks for your help 🙂

September 7, 2006 at 3:49 pm #258244

v_mansoori
Member

Hi
I have the same issue. I updated the driver, recreated the profile but still I get the same exception over and over.
Can it be some issue with the installed oracle server?

September 7, 2006 at 5:40 pm #258248

Haris Peco
Member

v_mansoori,

If you got ‘invalid column name’ it is driver problem – double check your jdbc jar – you can’t use 8.1 driver because this problem, and if you use some locale you can have problem with jdbc 10g too.Try oracle jdbc driver version9

Best
Peco

September 8, 2006 at 9:07 am #258265
v_mansoori
Member
I don’t get invalid column name. It can not find the catalog. I changed the driver to 9.2.0.8 and it didn’t solve the issue. I tried a couple of other versions without luck. This is the exception message:
```
org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem. 
Configured schema:VMAN30PTSCORE
Configured catalog:null
...
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)
```
September 8, 2006 at 9:19 am #258267

Haris Peco
Member

v_mansoori,

Please send us complete log – true jdbc error is aftre this

Best

September 8, 2006 at 10:26 am #258269

v_mansoori
Member

You’re correct. It says “Invalid Column Name”. I didn’t pay attention to the rest of the exception.
My DB version is 8.1.7.4.0 and the driver I’m currently use is ojdbc version 9.2.0.8.0.

Should I move to another version of driver?

September 8, 2006 at 12:12 pm #258275

Haris Peco
Member

v_mansoori ,

I know that jdbc version 8 (database version is not important) have problem with remarks column in tables/columns dictionary, but version 9.2 is correct.However, try with jdbc version 10 if you dont’ use locales or some other jdbc version 9

Best
Author

Posts

Viewing 11 posts - 1 through 11 (of 11 total)