jdbc hibernate Websphere exception

[Pranav Sharma]

for my app im using
an oracle10g DB
Websphere 5.1.0 WAS Test enviornment 5.0
with hibernate as a persisting service.

Everything works fine here.

However when we deploy this application on WAS 5.1,and try to insert or update i get the following exception:

java.lang.NullPointerException 
at oracle.jdbc.dbaccess.DBData.clearItem(DBData.java:431) 
at oracle.jdbc.dbaccess.DBDataSetImpl.clearItem(DBDataSetImpl.java:3528) 
at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:3401) 
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.resetStatement(WSJdbcConnection.java:1719) 
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1415) 
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1381) 
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:230) 
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:57) 
at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:105) 
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:461) 
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) 
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) 
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308) 
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2261) 
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187) 
  

I read somewhere this maybe a jdbc driver problem. Can someone help me with this. has been a big source of pain

[Maximilian Xavier Stocker]

Ugh! JDBC drivers that throw Null Pointer exceptions should be dragged by meathooks around the village square. That is a horrible thing that they should never do.

What I would suggest though is since you seem to be saying that you do not get this error in your testing environment is use the same driver in deployment that you use in development/testing. Failing that (as in you can't change the deployment driver) you will need to use the same driver as in deployment in your testing/development environment and see what causes the problem.

I would guess from the stacktrace that somewhere there is a call to clear parameters where not all the parameters have been set. I'm not sure how to work around that in Hibernate. But if you can isolate the issue in your development environment it will go a long ways to helping you solve the problem.

[Pranav Sharma]

well you think thats bad, here is the kicker, both enviornments are same.
This problem definetly pushed me a little closer to the edge.

And how do I solve it, I changed the oracle provided jdbc driver and it worked just fine. It took me 2 days for this cause, oracle's download website was down.

why o why