Has anyone successfully used hibernate with oracle lite 10g (previous version whould be good as well)? Is it supported in hibernate? If so, what jdbc driver should I be using?


Thanks in advance,

G.

afaik oracle lite is just oracle with all the fancy features removed....so it should work with a normal oracle jdbc driver. (but i havent tested)

it uses a different jdbc driver which should be olite40.jar, it also uses different connection urls ... anyway when I set as jdbc driver in hibernate configuration oracle.lite.poljdbc.POLJDBCDriver and I start the demo "build eg" it says that it can't find the driver with a ClassNotFound;

adding olite40.jar to the classpath in the build.bat file, results in a HibernateException class not found for the driver

If I setup hibernate to use sun.jdbc.odbc.JdbcOdbcDriver instead, it finds the jdbc driver starts the demo but fails on one of the first lines with an ODBC error (IIC S1007)

Pleasse feed back to me.

Thanks

you need to read the docs on how you specify the jdbc driver for running eg.

Download Hibernate and extract the archive
place your JDBC driver jar file in the lib directory
edit etc/hibernate.properties, specifying values for your database (Hibernate will create a schema for the demo automatically)
from a command prompt in the install dir
if you have Ant installed (and copied antlr.jar and junit.jar to ANT_HOME/lib), type ant eg
if not, type build eg under Windows
the example should run successfully

that's what I read. And what I did... but I encountered the problems I wrote before.

Anyway part of the question is still unanswered: has anyone sucessfully used hibernate with oracle lite (10g) ?

I gave up on even trying Oracle Lite years ago. It may work out but you are likely going to come across something does not work or is not present that you need. Sorry this does not help your problem but I would not use it.

Indeed it helps me, since now I know I'd have to switch over oracle full version without losing more time with lite (which is far more easier for an univerisatry student like).

Thank you all and best regards