using tomcat connection pool jndi name in spring hibernate datasource

[subrahmanyam]

hi,
I am successfully getting connection with
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>

<property name="url">
<value>jdbc:oracle:thin:@58.2.35.32:1521:SCHEMA</value>
</property>

<property name="username">
<value>myuser</value>
</property>

<property name="password">
<value>mypassword</value>
</property>

</bean>

but I want to use the tomcat server.xml datasource connection pool.
any ideas to use the datasourc . My server.xml code is as follows


<Resource name="jdbc/mydatasource"
auth="Container"
type="oracle.jdbc.pool.OracleDataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
url="jdbc:oracle:thin:@58.2.35.32:1521:schema"
user="myuser"
password="mypassword"
maxActive="20"
maxIdle="10"
maxWait="-1"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true" />

[Jörg Heinicke]

There is a JndiObjectFactoryBean (http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/jndi/JndiObjectFactoryBean.html). Exactly your case is also mentioned in the reference at the end of section 12.2.2 (http://static.springframework.org/spring/docs/2.0.x/reference/orm.html#orm-session-factory-setup).

Joerg

[subrahmanyam]

Thanks,

My problem has been solved.