[Brian Wallace]

Hi,

Using MyEclipse 6.5.0. (Installation summary at bottom of post)…

I’m getting the ‘Could not get list of tables from database. Probably a JDBC driver problem’ when I try and use the hibernate reverse engineering tool on an Oracle database.

It’s Oracle 8.1.7

The other database tools work fine, I can view the tables and perform queries just fine. It’s the hibernate reverse engineering that’s throwing the error.

I’ve tried a couple of different drivers, including the ojdbc14.jar listed in the FAQ, no luck.

In reading the error message from <workspace>\.metadata\.log it looks like a SQL exception: ORA-00933: SQL command not properly ended

Here is the error from <workspace>\.metadata\.log:

!ENTRY org.eclipse.core.jobs 4 2 2008-07-15 12:19:57.639
!MESSAGE An internal error occurred during: “Generating Artifacts”.
!STACK 0
org.hibernate.exception.SQLGrammarException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:ORADBA
Configured catalog:null
Available schemas:
ABINDRA
…Schemas left out to make post readable…
WYIN
Available catalogs:

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:257)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration$1.readDatabaseSchema(MEJDBCMetaDataConfiguration.java:104)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:89)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfiguration.java:137)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$7.execute(GenerateArtifactsJob.java:877)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:91)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:858)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:405)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:922)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1122)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:973)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1244)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3469)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3514)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTableResultSet(OracleMetaDataDialect.java:672)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:221)
… 11 more

MyEclipse Info…

*** Date: Tuesday, July 15, 2008 12:09:01 PM PDT

** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 6.5.0 GA
Build id: 6.5.0-GA-20080609

** Eclipse details:
MyEclipse Enterprise Workbench

Version: 6.5.0 GA
Build id: 6.5.0-GA-20080609

Eclipse Platform

Version: 3.3.3.r33x_r20080129-_19UEl7Ezk_gXF1kouft
Build id: M20080221-1800

Eclipse RCP

Version: 3.3.3.r33x_r20080129-8y8eE9UEUWI6qujeED0xT7bc
Build id: M20080221-1800

Eclipse Java Development Tools

Version: 3.3.2.r33x_r20080129-7o7jE7_EDhYDiyVEnjb1pFd7ZGD7
Build id: M20080221-1800

Eclipse Plug-in Development Environment

Version: 3.3.3.r33x_r20080129-7N7M5DQVIA_6oJsEFkEL
Build id: M20080221-1800

Eclipse Project SDK

Version: 3.3.3.r33x_r20080129-7M7J7LB-u3aphGW6o3_VmiVfGXWO
Build id: M20080221-1800

Eclipse Graphical Editing Framework

Version: 3.3.2.v20080129
Build id: 20080221-1602

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\IDE\MyEclipse 6.5\eclipse\eclipse.exe
-name
Eclipse
–launcher.library
C:\IDE\MyEclipse 6.5\eclipse\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.3.R33x_v20080118\eclipse_1023.dll
-startup
C:\IDE\MyEclipse 6.5\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33x_v20080118.jar
-exitdata
b30_f8
-clean
-vm
C:\IDE\MyEclipse 6.5\jre\bin\javaw.exe

Thanks for your time and any help.

[Loyal Water]

Can you create a new project and try reverse engineering the MyEclipse Derby database. Does that work ?

[Brian Wallace]

@support-nipun wrote:

Can you create a new project and try reverse engineering the MyEclipse Derby database. Does that work ?

Hi,

Yes, I created a test project and reverse engineered the Derby database. It worked like a charm.

Thanks,

– Brian

[Riyad Kalla]

Brian,
This was a bug that snuck into 6.5, we will get it fixed with the 6.5.1 release this Friday for you; sorry for the trouble.

[Brian Wallace]

Hi,

I did a fresh install of 6.5.1 and I’m still getting the same error message. I’ve tried the Oracle 10.1.0.5 & 10.2.0.4 JDBC drivers. Also, reverse engineering a Derby database works well. Anyone out there have a combination of JDBC driver and MyEclipse installation that allows Hibernate Reverse engineering to work on an Oracle database? Thanks.

Oh, here is the error from the log:

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:257)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration$1.readDatabaseSchema(MEJDBCMetaDataConfiguration.java:104)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:89)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfiguration.java:137)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$7.execute(GenerateArtifactsJob.java:877)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:91)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:858)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:405)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTableResultSet(OracleMetaDataDialect.java:672)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:221)
… 11 more

[Riyad Kalla]

Guys we are looking into this now, it was a regression that snuck in when we integrated the newest version of Hibernate Tools. Sorry for the hickups.

The temporary workaround is to step back to MyEclipse 6.0.1 (you can do dual-installs on the same machine without a problem) for the rev-eng tooling with Hibernate on Oracle for now. We realize this is really sub-optimal, we just don’t want anyone blocked on this.

[Cardsys]

@support-rkalla wrote:

Guys we are looking into this now, it was a regression that snuck in when we integrated the newest version of Hibernate Tools. Sorry for the hickups.

The temporary workaround is to step back to MyEclipse 6.0.1 (you can do dual-installs on the same machine without a problem) for the rev-eng tooling with Hibernate on Oracle for now. We realize this is really sub-optimal, we just donHi, ahh yes 6.0.1! were do i download the old 6.0.1?

Lothar

[Cardsys]

Hi, ahh yes 6.0.1! were do i download the old 6.0.1?

Lothar

[Riyad Kalla]

Lothar I’ve sent you the link in a PM.

[Brian Wallace]

Hi Riyad,

May I request that link to download 6.0.1 as well. I’d like to give it a shot.

Thanks,

Brian

[Riyad Kalla]

Brian, absolutely, I sent it along.

[hibbert]

We are about a business week out from the last reply here. Any word on a more optimal fix?

[hibbert]

Could you also send me the link to the previous version? This has become a bit of an issue.

[Loyal Water]

hibbert,
I have sent you the link in a pm.

[Cardsys]

Hi,
are there any news about the new version with the bugfix (Hibernate Reverse Engineering)?

regards
Lothar

[Author]

Posts