MQSeries.net :: View topic - ClassCastException after upgrading to Oracle 11.0.0.4

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ClassCastException after upgrading to Oracle 11.0.0.4

ClassCastException after upgrading to Oracle 11.0.0.4

« View previous topic :: View next topic »

Author

Message

deepak.gowder

Posted: Tue Mar 10, 2015 6:08 pm Post subject: ClassCastException after upgrading to Oracle 11.0.0.4

Novice

Joined: 19 Sep 2012
Posts: 20

Hi there!

Running Broker version 8.0.0.4.
We use OracleCallableStatement in some of our Java to call Oracle Stored procedures. They used to work and still works after they upgraded from 11.0.0.3 to 11.0.0.4 in managed environments, ie. Linux servers (we had to update our db property files). But those new properties throw error since the upgrade/ properties change in our local Windows 7 Enterprise OS. The other Stored Procedure calls work but only those that use 'OracleCallableStatement' doesn't. Checked the db property files and they seem to be correct.

Here's the snippet:

Code:

OracleCallableStatement callStmt = null;
callStmt = (OracleCallableStatement) connection
.prepareCall(TEST_STORED_PROC_NAME);

It throws right after at this statement. The connection properties look correct.

Error:

Code:

java.lang.ClassCastException: com.sun.proxy.$Proxy31 incompatible with oracle.jdbc.OracleCallableStatement

Any insight would be of much help.

P.S. CallableStatement (Java) works. Both use ojdbc6.jar.

Thanks.

fjb_saper

Posted: Wed Mar 11, 2015 4:36 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Here is the scoop. DON'T USE PROPRIETARY DRIVER STATEMENTS if you can avoid it. You change the version you may well have to recompile!

Stay with the generic CallableStatement...

_________________
MQ & Broker admin

deepak.gowder

Posted: Wed Mar 11, 2015 12:11 pm Post subject:

Novice

Joined: 19 Sep 2012
Posts: 20

Found the issue. There was extra ojdbc6 file in the bar and the original in the ConfigurableServices and both were referring from two different locations. Two instances of the same file caused the conflict.

Thank you!!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ClassCastException after upgrading to Oracle 11.0.0.4

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP