Hello,

I am trying to use hibernate tools with oracle 10g.

What is default_catalog and default_schema? In hibernate tools 3.0 default_schema had to be defined, so htools would not read the entire database. In 3.1, if I put my database name in default schema, in console the tables do not show up. If i define a default schema, then nothing shows up in tables.

Could you define how to put default schema and catalog? Lets say my oracle username (and schema) is `hibernator` - what do I have to write in default catalog?

Best regards,
Cam Bazz

Hi,

I am also trying to use hibernate tools 3.1 with oracle but version 8.
If i don't put the schema name i have an error message.
If i put it, i don't have any tables like you.

I only have an error
"Problem while reading database schema : Invalid column name"

Any way to get a detailed error message?
It works fine with hibernate 3.0

the log error messages is in the Error Log View.

Also remember that the schema/catalog name is case sensitive in oracle and thus most likely it should be HIBERNATOR for your schema.

Hello Max,

I noticed for hibernate tools to work correctly with oracle,

the oracle driver class : oracle.jdbc.driver.OracleDriver

has to be: oracle.jdbc.OracleDriver

otherwise it does not work.

Best Regards,

has to be something else on your side.

Our unit tests runs with oracle.jdbc.driver.OracleDriver and that works perfectly.

i still have this invalid column name error
(in fact "Nom de colonne non valide", french version.)

Even if i drop ALL my tables and use this simple statement:

create table test (
test VARCHAR2(3) not null
);

the log:



damned!

i get the same error with oracel 8.1.7.
the execute strack is:
can't load database schema.
and throw a exception:
java.sql.SQLException: invaild name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:4383)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:667)
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)
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)

for some reason their jdbc driver does not return a "REMARKS" column (which it should).

Try and use a more uptodate driver.

okaaayy, i've looked in the hibernate tools code, i think i understand what's going on :

reading database schema :
(org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:382))


then reveng reading tables schema doesnt find one of these columns :
(org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:382))


this is a driver problem i guess, oracle 8.1.7, drivers are classes12.jar.[/code]

yes - its a driver issue, and oracle 10 drivers can be used with oracle 8 afaik.

oh looks like we post at the same time, happy to see tha my analyse was right...

thanks!
digging the web for a driver...
i love oracle and their great products *smile*

afai'm testing, oracle 10 drivers are working...

thanks max, too bad i can't give you some credits :)

I'm using the latest oracle drivers (10g) and Eclipse 3.2 and the latest Hibernate Tools plugins for Eclipse.

I cannot see my tables!!!

I have tried uppercase/lowercase username/default schema, oracle.jdbc.driver.OracleDriver and oracle.jdbc.OracleDriver, Oracle9Dialect and OracleDialect.

No errors that i can see.

Not sure what to do next???

I'm pretty sure the connection is fine - it takes ages to come back with nothing!!!!

Here's my hibernate file:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.password">tiger</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@278.33.50.69:1521:orcl01</property>
<property name="hibernate.connection.username">SCOTT</property>
<property name="hibernate.default_schema">SCOTT</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
</session-factory>
</hibernate-configuration>

My classpath for the console configuration only has the jdbc driver. I have no current hibernate artifacts (in fact i haven't put Hibernate in my project yet).

Cheers

R

have you tried using the pure ant version and enable debug logging ?

fyi, it works flawless for me so i have a hard time guessing for more possible problems ;)

Hi,

just an update. I've got it working now. The problem was the jdbc url - it seems you cannot provide host as an ip address; you must use the hostname of the server.

Thanks

Rakesh