DataSource on WAS 5

Ricardo · **Posted:** Mon Jan 19, 2004 4:07 pm

Hello,

I'm trying to configure Hibernate to use a WAS 5 datasource with Oracle.

I know that it is maybe a WebSphere question, but can anyone help me?

My datasource name is "jdbc/oradevel" and my configuration file:

Code:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 2.0//EN"

 "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>

   <session-factory >

      <property name="dialect">net.sf.hibernate.dialect.OracleDialect</property> 

      <property name="connection.datasource">jdbc/oradevel</property>

...

thanks.

Ricardo · **Posted:** Mon Jan 19, 2004 4:10 pm

and in the Websphere log file the following warning is generated...

any ideas?

thanks.

Code:

[1/19/04 17:53:57:391 GMT-03:00] 74552614 SessionFactor I net.sf.hibernate.impl.SessionFactoryImpl  building session factory
[1/19/04 17:53:57:422 GMT-03:00] 74552614 Dialect       I net.sf.hibernate.dialect.Dialect  Using dialect: net.sf.hibernate.dialect.OracleDialect
[1/19/04 17:53:57:438 GMT-03:00] 74552614 NamingHelper  I net.sf.hibernate.util.NamingHelper  JNDI InitialContext properties:{}
[1/19/04 17:53:57:547 GMT-03:00] 74552614 ConnectionFac I J2CA0122I: Resource reference jdbc/oradevel could not be located, so default values of the following are used: [Resource-ref settings]

   res-auth:                 1 (APPLICATION)
   res-isolation-level:      0 (TRANSACTION_NONE)
   res-sharing-scope:        true (SHAREABLE)
   res-resolution-control:   999 (undefined)
[Other attributes]

isCMP1_x:                 false (not CMP1.x)
isJMS:                 false (not JMS)

[1/19/04 17:53:57:844 GMT-03:00] 74552614 ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource Oracle Datasource.
[1/19/04 17:53:57:875 GMT-03:00] 74552614 DatasourceCon I net.sf.hibernate.connection.DatasourceConnectionProvider  Using datasource: jdbc/oradevel
[1/19/04 17:53:57:875 GMT-03:00] 74552614 SessionFactor I net.sf.hibernate.impl.SessionFactoryImpl  Use outer join fetching: true
[1/19/04 17:53:58:469 GMT-03:00] 74552614 WSRdbDataSour u Database version is
                                 Personal Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
[1/19/04 17:53:58:469 GMT-03:00] 74552614 WSRdbDataSour u JDBC Driver version is
                                 9.2.0.1.0

jim_cakalic · **Joined:** Fri Jan 23, 2004 3:35 pm **Posts:** 2

Not really an answer, but have a look here:
http://publib7b.boulder.ibm.com/wasinfo ... itips.html

KK · **Joined:** Wed Sep 17, 2003 9:02 pm **Posts:** 13

You need to define the datasource in WAS (Resources -> JDBC Providers). Have you defined the datasource and still getting the error?

Ricardo · **Posted:** Tue Jan 27, 2004 7:30 pm

KK wrote:

You need to define the datasource in WAS (Resources -> JDBC Providers). Have you defined the datasource and still getting the error?

thank you guys,

I have created a DataSource on the WAS Console Administrador, but I forgot that bind this datasource in the deployment descriptor (Resources -> JDBC Providers) ...