Hi,

Has anyone tried Hibernate with Oracle 10g, or know of any compatibility issues?

Hi, seeing that no one has post a reply to your question, I guess I have no other choice but to see if you have already used it and with what degree of succes (if any) My company is planing to move to 10g soon and I'd love to know if Hibernate has known problems with it. Did you finally tried it?
Best regards

J.

Hi,

We are still in "prototype"-phase... but everything seems to be working fine. I had to download the 10g JDBC drivers and reference them in my middlegen task for ant. Other than that... works fine!

Thanks,

Hi there, thanks for your promt reply
What Dialect are you using, 9i or the Oracle "generic" one? I was looking at the changes to the SQL in 10g and there seem to be no significant changes that would let me to think it could not work with the 9i Dialect.
Also, it is reported that 9i's JDBC drivers had some problems dealing with Timestamps and large text/binaries. Do you know if those problems were fixed in the 10g driver? I know you are in a prototype stage and it's probably too soon for you to have encountered those issues, but I know of no one else to ask about 10g
Thanks in advance

J.

Hi.

We are using the 9i dialect. I have been working with Date fields and varchar fields up to 3500 characters with no issues so far. I will keep you posted if something changes with that.

Regards,
Aaron

Thanks

J.

testCollectionsInSelect Error

Could not execute query

net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1547)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1521)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1513)
at org.hibernate.test.FooBarTest.testCollectionsInSelect(FooBarTest.java:2134)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.hibernate.test.TestCase.runTest(TestCase.java:82)
Caused by: java.sql.SQLException: ORA-01722: invalid number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:542)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:914)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:451)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:985)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
... 18 more

Can you post it to JIRA please