[nageswarkv]

Hi there,

when I am generating Mapping file for Oracle 8.1 Database. I tried to upgrade from Oracle12.jar to odbc14.jar but still problem persists

MyEclipse 4.1 and Eclipse 3.1.2 s/w

*** Date: Wed May 31 14:59:48 CDT 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.4.2_04

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.1 GA
Build id: 20060309-4.1.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse Platform

Version: 3.1.2
Build id: M20060118-1600

Eclipse RCP

Version: 3.1.2
Build id: M20060118-1600

Eclipse Java Development Tools

Version: 3.1.2
Build id: M20060118-1600

Eclipse Plug-in Development Environment

Version: 3.1.2
Build id: M20060118-1600

Eclipse Project SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\eclipse-SDK-3.1.2-win32\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
1b60_2c
-vm
c:\Software\J2SDK1.4.2_04\bin\javaw.exe

MESSAGE An internal error occurred during: “Generating Artifacts”.

org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:UOP
Configured catalog:null
Available schemas:
AGRPROD
CAUD169
CTTD006
CTTD008
CTXD021
CTXD175
DATP999
DBGS999
DBSNMP
DCBA999
DDSW999
DDWS999
DGBL999
DINF000
DMTA999
DSW
DUCS999
DUOP998
DUOP999
DWAM999
ICOM619
IDBA014
IDBA023
IDMA005
IDMA007
IDMA010
IDMA018
IDMA022
IDMA024
IDMA030
IDMA036
IDMA037
IDMA038
IDMA039
IDMA040
IDMA042
IDMA043
IDMA046
IGEN122
IGEN164
IGEN255
IGEN262
IRAD011
IRAD016
IRAD017
IRAD038
IRAD039
IRAD048
MTS
MTS001
MTS002
MTS_DEV
OPS$CTTC999
OPS$DDSW999
OPS$ORACLE
OPS$PRODAUTO
OPS$PRODRUN
OPS$UCC7
OPS$UPDS999
ORACLE
OUTLN
PERFSTAT
QST
SQLCQR
SYS
SYSTEM
TTTS044
TTTS125
TTTS150
UCS
UOP
UOPDEV
UPDS000
UPDS031
UPDS999
UPRR
XCON866
XCOS289
XCOS292
XCOS310
XCOS648
XCOS694
XCOS872
XCOS941
XCOT078
XCOV123
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

[nageswarkv]

As described in this forum in other posts, i have loaded ojdbc14.jar for Oracle8.1 but still problem persists

[Haris Peco]

nageswarkv ,

This is driver problem.Try use driver from your oracle 8i (in jdbc directory)Oracle claim that
latest jdbc 10 drivers support oracle 8.1.7 and you can try if you have 8.1.7, but it’s sure that you use oracle 9.2 driver

You can download jdbc on http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Best

[nageswarkv]

Hi there,

Please ignore my other post and answer here

I tried as u guys explained like using ojdbc14.jar instead of class12.jar but still problem persists.

like Invalid column type.

did anybody solved this problem. or ur help is greately appreciated

[Haris Peco]

nageswarkv ,

Please use this link http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html and download jdbc driver for your version database (it is fine if you use ojdbc14.jar from version 9.2)

Please, try make simple table and mapping – for your production database we can have different permission problems

Best

[Author]

Posts