java.lang.AbstractMethodError

[nikil shar]

hi all,
am getting this below error when trying to use the setBinaryStream method.

SEVERE: StandardWrapperValve[EDPServlet]: PWC1406: Servlet.service() for servlet EDPServlet threw exception
java.lang.AbstractMethodError: oracle.jdbc.driver.OraclePreparedStatement.setBinaryStream(ILjava/io/InputStream;)V

String sql = "UPDATE BILL set PDF = ?, ISPREGENERATED .....;

byte[] bill = //read bytes from file

is = new ByteArrayInputStream(bill);

//store bill in BLOB in oracle db
ps.setBinaryStream(1, is);  <-- error thrown at this line

my environment :

CLASSPATH=.;C:\oracle\ora92\jdbc\lib\ojdbc14.jar;

database version : 11.1.0.7

Driver name: Oracle JDBC driver
Driver version: 9.2.0.1.0

App server : glassfish v3 Prelude
java version : 1.6



thanks in advance.

[Travis Hein]

CLASSPATH=.;C:\oracle\ora92\jdbc\lib\ojdbc14.jar;

the setBinaryStream() was 'invented' in JDBC 4 specification, which comes with java 1.6

the oracle ojdbc14.jar is targeting java 1.4, that implements JDBC 2.1 spec.

So you need to (get and) use ojdbc16.jar in the classpath instead.

see also:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html

http://onjava.com/onjava/2006/08/02/jjdbc-4-enhancements-in-java-se-6.html

[nikil shar]

hey that worked. i downloaded 'ojdbc5.jar' and included it in my classpath and it worked.

thanks a lot for your help.