facebook

[Closed]Couldn’t get list of tables from database

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #246720 Reply

    unsee
    Member

    I got a message when I used Hibernate tools to generate codes in Eclipse 3.1.2. The error message like this:

    org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem.
    Configured schema:null
    Configured catalog:null
    Available schemas:
    ANONYMOUS
    CHATER
    CMTWAP
    CTXSYS
    DBSNMP
    DEMO
    DSJ
    EBAYITEM
    HLDDP
    HR
    MDSYS
    MOJIECUN
    ODM
    ODM_MTR
    OE
    OLAPSYS
    ORDPLUGINS
    ORDSYS
    OUTLN
    PM
    QS
    QS_ADM
    QS_CB
    QS_CBADM
    QS_CS
    QS_ES
    QS_OS
    QS_WS
    SCOTT
    SH
    SHISHEN
    SYS
    SYSTEM
    WAPMONITOR
    WAPORDER
    WKPROXY
    WKSYS
    WMSYS
    XDB
    YCZBK
    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:382)
    at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:62)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:79)
    at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:70)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:39)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:31)
    at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:70)
    at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192)
    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: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)
    … 10 more

    I used the lastest Oracle JDBC Driver ojdbc14.jar, But could not resolver this question, How can I do?

    #246723 Reply

    Haris Peco
    Member

    unsee,

    Do you use MyEclipse or Hibernate tools ?

    #246724 Reply

    unsee
    Member

    Thanks snpe! I had resolved this question. I replaced my Hibernate Tools with lastest version 3.1.0 beta 4, previous version is 3.1.0 beta 2. Now it works fine.

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: [Closed]Couldn’t get list of tables from database

You must be logged in to post in the forum log in