Thread: AbstractMethodError exception on an executeUpdate call
Hi Everyone,
I am using pg73rc1jdbc2.jar. i get this:
Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2Statement.executeUpdate(Ljava/lang/String;I)I
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:252)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:252)
the code that causes this is:
st.executeUpdate(SQL, Statement.RETURN_GENERATED_KEYS);
Not quite sure why this is happening. after searching throught the archives the only answer i could find was that i am not using the right version of the driver. but i am using a version 2 jdbc driver so it cant be that right?
Any ideas why this is happening? does anybody else get the same problem?
Thanks in advance.
Ziad
p.s. set up:
tomcat 4.1
postgreSQL 7
windows 2000 professional
jdbc 7.3rc1 version 2
Ziad, The method you are trying to call (executeUpdate(String, int)) is a new method in jdbc3. It does not exist in jdbc2. If you use the pg73rc1jdbc3.jar file the method will exist. However generated keys are not supported in the postgres jdbc driver, so even if you where to have the correct version of the jdbc driver, you still wouldn't be able to call this method. thanks, --Barry Apu Ziad Mannan wrote: > Hi Everyone, > > I am using pg73rc1jdbc2.jar. i get this: > Caused by: java.lang.AbstractMethodError: > org.postgresql.jdbc2.Jdbc2Statement.executeUpdate(Ljava/lang/String;I)I > at > org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:252) > > the code that causes this is: > st.executeUpdate(SQL, Statement.RETURN_GENERATED_KEYS); > > Not quite sure why this is happening. after searching throught the > archives the only answer i could find was that i am not using the right > version of the driver. but i am using a version 2 jdbc driver so it cant > be that right? > > Any ideas why this is happening? does anybody else get the same problem? > > Thanks in advance. > > Ziad > > p.s. set up: > tomcat 4.1 > postgreSQL 7 > windows 2000 professional > jdbc 7.3rc1 version 2