I'm testing Oracle JDBC drivers with Oracle12C.
My code looks like this:
String hostServer = "localhost";
String dbName = "rms12asm";
String login = "testuser";
String pw = "testpw";
String strConnect = "jdbc:oracle:thin:@//" + hostServer + ":1521/" + dbName // + "?characterEncoding=utf8" ;
CTest1.log("strConnect = " + strConnect);
conn = DriverManager.getConnection(strConnect, login, pw);
System.out.println("conn.getClass().getCanonicalName()=" + conn.getClass().getCanonicalName());
oracle.jdbc.driver.OracleConnection conOra = (oracle.jdbc.driver.OracleConnection) conn;
System.out.println("conn.isLogicalConnection()=" + conOra.isLogicalConnection());
System.out .println("((oracle.jdbc.driver.OracleConnection)conn).isValid(10)=" + ((oracle.jdbc.driver.OracleConnection) conn).isValid(10));
System.out.println("conn.isValid(10)=" + conn.isValid(10));
I get an error trying to call Connection.isValid().
[CTest1.main] error: java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.isValid(I)Z
java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.isValid(I)Z
at com.rco.utility.CTest1.main(CTest1.java:116)
I have tried several Oracle Jar files in the classpath, including: ojdbc7.jar, ojdbc6.jar, etc.
The "isValid()" method has not caused us problems with other jdbc drivers, such as I-net sero.jar.
Can someone help explain what is going on here?
-SB