Forums Register Login

oracle.jdbc.driver.OracleCallableStatement is not public in OJDBC5.jar

+Pie Number of slices to send: Send
Hi All,

In my application I am using ojdbc14.jar, but application is running on Java 1.5 (Batch) and Java 1.6 (web). I tried to migrate to ojdbc5.jar which is recommended for java 1.5 and Oracle 11g.

Here is the code which I am using

import oracle.jdbc.driver.OracleCallableStatement

cstmt = (OracleCallableStatement)conn.prepareCall("begin zzzzzzzzz(?,?,?,?,?,?); end;");
String[] pmsgs = (String[])(cstmt.getARRAY(6).getArray());

When I used ojdbc5.jar
import oracle.jdbc.driver.OracleCallableStatement was not visible as it is not public in the ojdbc5.jar. Instead when I tried
import oracle.jdbc.OracleCallableStatement and
String[] pmsgs = (String[])(cstmt.getArray(6));

it worked.

I have 2 questions.

1. Instead of import oracle.jdbc.driver.OracleCallableStatement can i use import oracle.jdbc.OracleCallableStatement in my code.
2. Or if the above statement is wrong which class can be used instead of import oracle.jdbc.driver.OracleCallableStatement in ojdbc5.jar

Thanks
+Pie Number of slices to send: Send
Sharat,
As far as I am aware, oracle.jdbc.driver package is deprecated, hence you should not use it in your code.
I'm only going from memory and I haven't verified it, but I believe you can safely use method getArray of interface java.sql.CallableStatement instead of method getARRAY of interface oracle.jdbc.OracleCallableStatement.

Good Luck,
Avi.
+Pie Number of slices to send: Send
To expand on this: Oracle has defined interfaces substituting the driver's classes in package oracle.jdbc. Interface oracle.jdbc.OracleCallableStatement still does have the method getARRAY. If you want to minimize changes to the code, you probably could use this interface instead of the implementation from the oracle.jdbc.driver package.
There’s no place like 127.0.0.1. But I'll always remember this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 6892 times.
Similar Threads
jdbc driver not found while using applet
Connecting Java Application with a Database
Unable to execute jar file....got following stack trace.
On connection: Array Index Out Of Bounds Exception: 4
Unable to execute jar file....got following stack trace.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 06:51:37.