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
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