[herve.labboz]

Hi,
I use this configuration : MyEclipse 4.1.1 and Eclipse 3.1.1
I still have error when I try to create hibernate mapping.
I think it’s just a configuration problem because few weeks ago it was ok !

Can you help me ?

Thinks,
Hervé.

[Riyad Kalla]

Hervé,
Can you open your log file (<workspace dir>\.metadata\.log) and look for exceptions that pertain to this mapping failure and then paste the result here for me? (not the entire file, just the part pertianing to this problem).

I have a feeling that your DB permissions may be wrong.

[herve.labboz]

I am connecting with different user (DB user) and the error is different.

Each time, I have this error :
!ENTRY org.eclipse.core.runtime 4 2 2006-09-28 14:59:09.93
!MESSAGE An internal error occurred during: “Generating Artifacts”.
!STACK 0
org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:DBMR
Configured catalog:null
Available schemas:
CNX_ORACLE
DBFC
DBIG
DBMR
DBQE
DBSECUR
DBSNMP
FICQE
GESFC
GESIG
GESMR
GESQE
LECFC
LECIG
LECMR
LECQE
OPS$ORACLE
OUTLN
SYS
SYSTEM
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: Nom de colonne non valide
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)
… 11 more

And depending user, I have this errors :

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-28 14:58:00.781
!MESSAGE Cannot get indices
!STACK 0
java.sql.SQLException: ORA-01031: privilèges insuffisants

Or :

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-27 12:05:49.187
!MESSAGE Error retreiving table types for com.genuitec.eclipse.sqlexplorer.model.SchemaNode
!STACK 0
java.sql.SQLException: Exception d’E/S: Connection reset by peer: socket write error

Or :

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-27 12:05:57.234
!MESSAGE Error activating preview
!STACK 0
java.sql.SQLException: Exception d’E/S: Connection reset by peer: socket write error

Hervé.

[fisheer]

a JDBC driver problem!

i encounter several days ago,
I solve this question by changing my driver.

class12.jar->odbc14.jar(my db is oracle9i)

success!

[Riyad Kalla]

Ahh good news, I’m glad it’s working.

[herve.labboz]

Sorry, but I already use odbc14.jar (and it was working several weeks ago…).
I tried with class12.jar, odbc14.jar, odbc14_g.jar.
I think it’s a problem between my driver and my database, but I can’t find what !

[Riyad Kalla]

Herve,
It’s hard to say, although I did notice this problem:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-28 14:58:00.781
!MESSAGE Cannot get indices
!STACK 0
java.sql.SQLException: ORA-01031: privilèges insuffisants

For the time being, try and temporary use a user that has full R/W permissions on the DB, to rule out any permission problems.

[herve.labboz]

Yes, I tried with the user that has dba access.

The error was :
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-27 12:05:57.234
!MESSAGE Error activating preview
!STACK 0
java.sql.SQLException: Exception d’E/S: Connection reset by peer: socket write error

[Haris Peco]

Herve,

Please, try with ojdbc14 from oracle 9 or oracle 10 (it will work with db >= 8.1.7).You can download drivers from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
I suppose that you use jdbc driver from oracle 8.1.7 (there is bug in driver which throw exception ‘Nom de colonne non valide ‘)
jdbc driver 10 have bug with non-english locale (some combination are invalid), but it is resolved in latest 10.2.0.2)

if you will have had problems further, please send us exactly database and jdbc version.

Best
Peco

[Author]

Posts