HB Tools and Error on Table receiving

horyna · **Joined:** Tue Nov 28, 2006 5:22 am **Posts:** 3

Hello,

Hibernate version:3.2.0

Hibernate Tools version:3.2.beta8

Oracle 10 XE

If i do : create HB config file,..console configuration, ... than i trying to view Database Tables in Hibernate Console Perspective i become this error ( ... if i set schema i see no error but no tables to :). I let the Catalog null always ) :

java.sql.SQLException: Invalid Column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:33)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:59)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:433)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:67)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:97)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:56)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:88)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:57)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:94)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:207)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)

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:
some schemas...

Available catalogs:
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.handleSQLException(JDBCMetaDataDialect.java:40)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:62)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:433)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:67)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:97)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:56)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:88)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:57)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:94)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:207)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
Caused by: java.sql.SQLException: Neplatný název sloupce
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$1.convertRow(JDBCMetaDataDialect.java:33)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:59)
... 9 more

max · **Posted:** Tue Nov 28, 2006 9:33 am

hmm can't see how this can give an invalid column name except if oracle xe doesn't follow the spec.

note, i run against XE in my tests and here i haven't bumped into this scenario.

Ananasi · **Posted:** Tue Nov 28, 2006 9:35 am

Turn on debug logging, at least we will be able to see what table/column it is choking on. BTW, you probably want to set the schema or it will search all schemas (can be a lot!). Also, schema is case sensitive I believe.

horyna · **Joined:** Tue Nov 28, 2006 5:22 am **Posts:** 3

Sorry for stupid question :). But how to turn on debug logs?

Ananasi · **Posted:** Tue Nov 28, 2006 10:55 am

Create a log4j.properties file (in the classpath), e.g.

Code:

log4j.rootLogger=INFO, C1

#C1 console appender
log4j.appender.C1=org.apache.log4j.ConsoleAppender
log4j.appender.C1.layout=org.apache.log4j.PatternLayout
log4j.appender.C1.layout.ConversionPattern=[%d] %c{1} %-5p - %m%n

#Class overrides
log4j.logger.org.hibernate=DEBUG

Just don't leave that on when you generate anything but the mapping or you'll get approximately 10 trillion lines in your console when the session factory spins up. ;)

maitscha · **Joined:** Sat May 20, 2006 3:49 am **Posts:** 78

I use this connection properties for an Oracle 10 XE database:

Code:

        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.password">dseas</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
        <property name="hibernate.connection.username">dseas</property>
        <property name="hibernate.default_schema">DSEAS</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>

Check if you have some BIN$... recycle tables in your db. These tables can cause errors, delete them before doing reverse engineering.

Ananasi · **Posted:** Tue Nov 28, 2006 11:07 am

BIN$ are automatically excluded in the reverse engineering.

maitscha · **Joined:** Sat May 20, 2006 3:49 am **Posts:** 78

since what version of Hibernate-Tools?

Ananasi · **Posted:** Tue Nov 28, 2006 11:11 am

Line 107 in the DefaultReverseEngineeringStrategy.java from the most recent CVS, AFAIK it was in there for at least the last version (b8).

horyna · **Joined:** Tue Nov 28, 2006 5:22 am **Posts:** 3

I am usings same settings! With my name, pasword ... :)). What jdbc driver are you using?

...log4j : I have not problem with hibernate, he work very well. This log4j settings is not to Hibernate Tools ... or -> i see no difference in log :)

Ananasi · **Posted:** Tue Nov 28, 2006 11:33 am

I'd say your log4j.properties file is not properly in the classpath. When I use that log4j.properties file, I get an enormous amount of information when reverse engineering (15000+ lines for reveng 400 tables). Unfortunately, I use Ant to do my reverse engineering, so for the console I don't really know where to put it. Perhaps someone else has some insight as to where to place that file.

max · **Posted:** Tue Nov 28, 2006 3:43 pm

Ananasi wrote:

Line 107 in the DefaultReverseEngineeringStrategy.java from the most recent CVS, AFAIK it was in there for at least the last version (b8).

yeah, been there as a hack to avoid the storm of questions about BIN$ :)