Upgrade to pg and driver version 8.x code compatibilities - Mailing list pgsql-jdbc

From Tom Arthurs
Subject Upgrade to pg and driver version 8.x code compatibilities
Date
Msg-id 4279EE11.10607@jobflash.com
Whole thread Raw
Responses Re: Upgrade to pg and driver version 8.x code compatibilities
List pgsql-jdbc
We've upraged out development and qa servers to postgresql 8.  When using our java application, we get errors at
variouspoints in the code 
similar to the following:

Unable to create new submission. org.apache.commons.dbcp.DelegatingPreparedStatement@180b22ejava.sql.SQLException:
ERROR: column "job_experience" is of type smallint but expression is of type character varying

If I downgrade the driver to the 7.4.x version the error goes away and we can run the application.

I realize this is probably pointing to bad coding practices, which will be fixed, I believe, as our developers work on
thecode, but we want to 
avoid an all out push to get the code all fixed (similar problems exist in a *lot* of places in the code).  We'd like
toprocede with 
upgrading to 8.x server -- Two questions arise

1.  What changed between the driver versions that generate this error?

2.  What is the downside of continuing to use the 7.x version of the driver -- or are there better alternatives (patch,
newversion, etc).  I 
am using build 311 of the driver.

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Infinity and beyond
Next
From: "Donald Fraser"
Date:
Subject: Re: Infinity and beyond