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!

Protocol violation Error with 17401 error code

856451Apr 19 2011 — edited Apr 21 2011

Hi,
When we are trying to call stored procedure with below syntax we are getting "com.ibm.websphere.ce.cm.StaleConnectionException: Protocol violation" error with error code 17401 in local IRAD application and also in deployed application of WAS.

call schemaName.truncate_table('table_name', 'DROP STORAGE')

If I comment this procedure call in the Java code and execute, then next SQL staments following this call will be executed successfully. Below are some of the trails that I have already done and getting same error

1. Dowloaded latest ojdbc.jar as per Oracle Database 10g 10.2.0.4.0 version
2. Kept the minimum number of connections value as ZERO in WAS admin.

Let me know if you know any solution for this

Thanks
Basavaraj

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2011

Added on Apr 19 2011

#java-database-connectivity-jdbc

6 comments

14,150 views