Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem DBCP sessionFactory creation

843859Dec 6 2006 — edited Dec 21 2006
Hello,

I have trouble to make run an web app, running with tomcat 4.1.29, hibernate connecting to oracle9i.
Everything is working well when I use classes12.jar (driver for oracle 8i) and when I connect to a oracle 9i database.

But i get the following error when I work with classes12.jar (driver for oracle9i) or ojdbc14.jar

Here is the java error in tomcat console :
Caused by: java.lang.NullPointerException
	at org.apache.commons.dbcp.DelegatingConnection.close(DelegatingConnection.java:151)
	at org.apache.commons.dbcp.PoolableConnection.reallyClose(PoolableConnection.java:95)
	at org.apache.commons.dbcp.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:301)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:883)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1823)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1143)
	at com.snecma.ecom.ecm.orm.HibernateUtil.<clinit>(HibernateUtil.java:26)
Here is tomcat config : server.xml
		<Resource name="jdbc/myoracle" auth="Container"
		              type="javax.sql.DataSource"/> 
		<ResourceParams name="jdbc/myoracle">
		  <parameter>
		    <name>factory</name>
		    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
		  </parameter>
		  <parameter>
		    <name>driverClassName</name>
		    <value>oracle.jdbc.driver.OracleDriver</value>
		  </parameter>
		  <parameter>
		    <name>url</name>
		    <value>jdbc:oracle:thin:db_user_name@192.0.0.1:1521:DB_INSTANCE_NAME</value>
		  </parameter>
		  <parameter>
		    <name>username</name>
		    <value>db_user_name</value>
		  </parameter>
		  <parameter>
		    <name>password</name>
		    <value>db_user_pwd</value>
		  </parameter>
		  <parameter>
		    <name>maxActive</name>
		    <value>20</value>
		  </parameter>
		  <parameter>
		    <name>maxIdle</name>
		    <value>10</value>
		  </parameter>
		  <parameter>
		    <name>maxWait</name>
		    <value>-1</value>
		  </parameter>
Here is my hibernate config file :
hibernate.cfg.xml
<hibernate-configuration>
    <session-factory name="seessionFacName>
        <property name="connection.datasource">java:comp/env/jdbc/myoracle</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
		<property name="show_sql">false</property>
		<!-- Uncomment for runtime -->
		<!-- Comment for build -->
	 	<mapping resource="app.hbm.xml"/>
	 	
    </session-factory>
</hibernate-configuration>
Do you have any clue to solve this problem ?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2007
Added on Dec 6 2006
2 comments
307 views