You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Michael Starkie <sk...@gmail.com> on 2005/03/23 23:34:50 UTC

JOCL and Oracle9 - NullPointerException

I'm having trouble getting a connection from the oracle 9 jdbc driver
using a jocl file.  I keep getting a NullPointerException at the point
where the driver requests a physical connection.

Connection c = DriverManager.getConnection("jdbc:apache:commons:dbcp:/MASTER");

this code works fine if I substitute a mysql driver in the MASTER.jocl file.

------

java.lang.NullPointerException
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:206)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
	at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)


-------

<object class="org.apache.commons.dbcp.PoolableConnectionFactory"
xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl">
	<object class="org.apache.commons.dbcp.DriverConnectionFactory">
		<object class="oracle.jdbc.driver.OracleDriver"/>
		<string value="jdbc:oracle:thin:[blank]/[blank]@[blank].com:1521:[BLANK]"/>
		<object class="java.util.Properties" null="true"/>
	</object>
	<object class="org.apache.commons.pool.impl.GenericObjectPool"/>
	<object class="org.apache.commons.pool.impl.GenericKeyedObjectPoolFactory"
null="true"/>
	<string value="" null="true"/>
	<boolean value="false"/>
	<boolean value="true"/>
</object>

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org

Re: JOCL and Oracle9 - NullPointerException

Posted by Michael Starkie <sk...@gmail.com>.
The problem is that with oracle 9 the properties object can not be
null as it can be with MySql.  The following setting fixes the problem
in the jocl file below:

 <object class="java.util.Properties" null="false"/>    


On Wed, 23 Mar 2005 17:34:50 -0500, Michael Starkie <sk...@gmail.com> wrote:
> I'm having trouble getting a connection from the oracle 9 jdbc driver
> using a jocl file.  I keep getting a NullPointerException at the point
> where the driver requests a physical connection.
> 
> Connection c = DriverManager.getConnection("jdbc:apache:commons:dbcp:/MASTER");
> 
> this code works fine if I substitute a mysql driver in the MASTER.jocl file.
> 
> ------
> 
> java.lang.NullPointerException
>         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:206)
>         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
>         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
>         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
>         at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:193)
> 
> -------
> 
> <object class="org.apache.commons.dbcp.PoolableConnectionFactory"
> xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl">
>         <object class="org.apache.commons.dbcp.DriverConnectionFactory">
>                 <object class="oracle.jdbc.driver.OracleDriver"/>
>                 <string value="jdbc:oracle:thin:[blank]/[blank]@[blank].com:1521:[BLANK]"/>
>                 <object class="java.util.Properties" null="true"/>
>         </object>
>         <object class="org.apache.commons.pool.impl.GenericObjectPool"/>
>         <object class="org.apache.commons.pool.impl.GenericKeyedObjectPoolFactory"
> null="true"/>
>         <string value="" null="true"/>
>         <boolean value="false"/>
>         <boolean value="true"/>
> </object>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org