We are using Sun GlassFish Enterprise Server v2.1 (9.1.1) (build b60e-fcs) and Oracle 11g database. There is no problem running queries using PreparedStatements but if I try to use a CallableStatement I get no results returned and Glassfish gives the error messages:
[#|2009-02-10T16:25:44.734-0500|INFO|sun-appserver2.1|javax.enterprise.resource.resourceadapter|_ThreadID=35;_ThreadName=httpSSLWorkerThread-8080-2;DUAL;|RAR5074 : Table based validation detected invalid connection. Querying the table DUAL failed.
[#|2009-02-10T16:30:00.296-0500|WARNING|sun-appserver2.1|javax.enterprise.resource.resourceadapter|_ThreadID=16;_ThreadName=httpSSLWorkerThread-8080-1;_RequestID=f3f56dbf-6ebd-434b-8f72-21271662b2ff;|Error while destroying resource :Protocol violation|#]
[#|2009-02-10T16:30:00.296-0500|WARNING|sun-appserver2.1|javax.enterprise.resource.resourceadapter|_ThreadID=16;_ThreadName=httpSSLWorkerThread-8080-1;_RequestID=f3f56dbf-6ebd-434b-8f72-21271662b2ff;|RAR5035:Unexpected exception while destroying resource.
The CallableStatement has been tested elsewhere and produces the desired results. Does anyone know why it would fail in Glassfish and give these errors?
[Message sent by forum member 'talman' (talman)]
http://forums.java.net/jive/thread.jspa?messageID=331136