Unable to create PreparedStatement with DB2

[mfcollins3]

I am using JBoss-2.4.3_Tomcat-3.2.3 with DB2 7.1 running on a different server. I have configured the pool setting in jboss.jcml and the pool is being created at startup.

When I make a call to my session EJB, it obtains the data source using JNDI, obtains a connection to the data source, and then calls connection.prepareStatement() to create a PreparedStatement object.

I am getting a SQLException that only says "Unable to create PreparedStatement!" Does anyone know anything that I can try to resolve this?

Thanks

[rajarshi]

Hello,
I am facing the same problem with ConnectJDBC2.2 type 4 driver from datadirect with MSSQLServer7.0.
But I am getting it while creating the PreparedStatement for the second time.
Please let me know if you found answer for this.

Regards
[e-mail]

[fhooey]

I am having the same problem with an Oracle connection pool. Any help with this issue would be greatly appreciated.