Re: 8.1-407 JDBC driver issues

This belongs on the jdbc driver list....
On 27-Oct-06, at 6:29 AM, lasitha weerasinghe wrote:

> Hi,
>
> I'm using postgresql 8.1-407 jdbc driver with postgresql 7.4.13  
> database and it seems like there is an issue when the driver is  
> used in jdbc transactions. I'm using this version of the jdbc  
> driver,  cause I haven't came across any fixes for the 8.1.4  
> security issuse for the 7.4.13 database driver. I only noticed that  
> the fix has been done for the v.8 drivers only.
>
> But the problem i'm facing now is when i'm using statements in a  
> transaction (setting the connection.setAutoCommit(false)) some of  
> the records doesn't go to the database. This is not a frequent  
> issue and also I have noticed couple of times that if I try to add  
> the same record again the db will throw duplicate record exception  
> even though the record is not there in the database.
>
> this is the code i'm using for JDBC transactions.
>
> connection.setAutoCommit( false );
> connection.setTransactionIsolation 
> (Connection.TRANSACTION_SERIALIZABLE);
> try {
>     // ... execute statements
>     connection.commit();
> } catch (Exception e) {
>     logger.logError(e);
>     connection.rollback();
> }
>
> is anyone of you came across this problem and managed to find a  
> solution?
The 8.1 driver should work fine on a 7.4 server, now I still don't  
know the problem ? I've never seen it not put the record in the  
database ? Have you looked at the server logs ?
I need more information to fix this .
Dave
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar - get it now! http:// 
> toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>