ClassCastException DelegatingPreparedStatement - Mailing list pgsql-jdbc

From Kevin Murphy
Subject ClassCastException DelegatingPreparedStatement
Date
Msg-id 459AA957.9080007@genome.chop.edu
Whole thread Raw
Responses Re: ClassCastException DelegatingPreparedStatement
List pgsql-jdbc
I'm just getting around to testing out the advice I got from this list a
couple weeks ago about prepare thresholds (thanks, Mark & Dave).

Using code modeled after the PG JDBC "Server Prepared Statements" code
example, I'm getting this runtime error:

java.lang.ClassCastException:
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement

on the line marked with an asterisk:

            try {
                Class.forName("org.postgresql.Driver");
            } catch(Exception e) {
                printError("org.postgresql.Driver class not found in
getMedlineListFromParsedText(): ", e.getMessage());
            }
            prestmt = conn.prepareStatement(query);
  *        org.postgresql.PGStatement pgstmt =
(org.postgresql.PGStatement)prestmt;
            pgstmt.setPrepareThreshold(0);

I'm using DBCP pooled connections within tomcat.  Versions: PG 8.1,
postgresql-8.1-407.jdbc3.jar, tomcat 5.5.20, Java 1.5

My Java newbie status is hobbling me.  Thanks for any pointers.

Thanks,
Kevin


pgsql-jdbc by date:

Previous
From: "Jeanna Geier"
Date:
Subject: Help with RULES - Please!
Next
From: Tom Lane
Date:
Subject: Re: Help with RULES - Please!