NHibernate with Oracle

indranic · **Joined:** Thu Mar 30, 2006 5:01 pm **Posts:** 1

Can anyone help me with Connection string and settings that are required for Oracle 9i

Thanks in advance..

indrani.

jt_1000 · **Posted:** Thu Mar 30, 2006 6:19 pm

put in your hibernate.properties:

#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.dialect=org.hibernate.dialect.OracleDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.username=jt
hibernate.connection.password=xxx
hibernate.connection.url=jdbc:oracle:thin:@
hibernate.show_sql=true

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

I don't think a jdbc driver is going to help NHibernate. :D

Sorry I couldn't give a helpful answer, but it's been 6 months + since I used Oracle and I don't have the code in front of me.

http://www.connectionstrings.com/

markjchapman · **Posted:** Fri Mar 31, 2006 4:13 am

Here's what I use onto Oracle 9:

<nhibernate>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
<add key="hibernate.dialect" value="NHibernate.Dialect.Oracle9Dialect" />
<add key="hibernate.connection.driver_class" value="NHibernate.Driver.OracleDataClientDriver" />
<add key="hibernate.connection.connection_string" value="Data source=(TNSNAMEHERE);User Id=(USERID);Password=(PASSWORD);" />
</nhibernate>

This is using the Oracle ODP client, change OracleDataClientDriver to OracleClientDriver to use the MS variety.

Hope this helps

Mark