Problem with Oracle connection

ghiboz · **Joined:** Wed Jun 14, 2006 10:31 am **Posts:** 6

Hi all...
I've a problem connecting with a oracle 8 database...
can you write the basic connections strings to connect to database??

thanks

Stef-âne · **Joined:** Tue Jun 06, 2006 7:33 pm **Posts:** 11

Actual I use Spring-hibernate to configure my data source. But without Spring I think the parameters aren't different (see above...)

Quote:

Spring Hibernate configuration

Code:

<bean id="oracleDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:databaseName"/>
      <property name="username" value="myusername"/>
      <property name="password" value="mypassword"/>
</bean>

Quote:

Only Hibernate without a Data Source Server

Code:

      <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:mydataBaseName</property>
      <property name="connection.username">myusername</property>
      <property name="connection.password">mypassword</property>
      <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
   

Quote:

Data Source from Weblogic Server

Code:

<!--   
   <property name="connection.datasource">MY_DATA_SOURCE_SERVER</property>
   <property name="jndi.url">t3://127.0.0.1:7901</property>
   <property name="jndi.class">weblogic.jndi.WLInitialContextFactory</property>
   <property name="connection.username">usernameServer</property>
   <property name="connection.password">passwordServer</property>
   <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>

[/code]

Don't forget to add the Oracle Driver Library on the classpath, like classes12.jar

ghiboz · **Joined:** Wed Jun 14, 2006 10:31 am **Posts:** 6

solved, here my code:

Code:

            myKeys["hibernate.connection.driver_class"] = "NHibernate.Driver.OracleClientDriver";
            myKeys["hibernate.connection.provider"] = "NHibernate.Connection.DriverConnectionProvider";
            myKeys["hibernate.connection.connection_string"] = "Data Source=ORCL_SERVER01;User Id=system;Password=manager;Integrated Security=no;";
            myKeys["hibernate.default_schema"] = "OUTLN";
            myKeys["hibernate.dialect"] = "NHibernate.Dialect.OracleDialect";