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