Re: [Info-Ingres] jdbc caches prepared statements?

Hi Kristoff,

I'll check for a fix to that bug number.

Marty

-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
kristoff.picard@xxxxxxxxxx
Sent: 30 July 2008 13:28
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] jdbc caches prepared statements?

Hi Marty,
the JDBC driver needs to follow the DBMS here.
For the DBMS, in theory I would agree, but it turned out that changing
this behaviour, which was tried years ago, introduced other problems -
so that change was removed.

But back to the JDBC application: When using
PreparedStatement.close(), LATER versions of the driver should remove
this statement from the internal cache (so you have to re-prepare
before executing it again). It also frees the internal statement name,
so if that name is used again to prepare a statement, the old
statement in the DBMS is replaced by the new one(similar to embedded
sql). You need to have the fix for bug 117108 for this. (I haven't
tested this, but this is my understanding)

Kristoff
_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

.

Relevant Pages

  • Re: JDBC Driver: Connection reset by peer: socket write error
    ... Either your network broke the socket between the driver ... >>and the DBMS, or the DBMS had a failure which required it to ... I reboot the server that hosts both JDBC & the SQL ... the failure you showed was with a connection ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Microsoft Access Database with Java.
    ... If you want to use a database, you'll need DBMS ... >>functionality of Microsoft Access in a JDBC driver any time soon. ... the "design" view of the table to find out what the real column names ...
    (comp.lang.java.databases)
  • Re: jdbc caches prepared statements?
    ... the JDBC driver needs to follow the DBMS here. ... For the DBMS, in theory I would agree, but it turned out that changing ... this statement from the internal cache (so you have to re-prepare ... It also frees the internal statement name, ...
    (comp.databases.ingres)
  • Re: Microsoft Access Database with Java.
    ... > Fabian Rossbacher wrote: ... If you want to use a database, you'll need DBMS ... > functionality of Microsoft Access in a JDBC driver any time soon. ...
    (comp.lang.java.databases)
  • Re: Does JDBC support compressed data communication
    ... That's outside the standard JDBC interface. ... It depends entirely on the individual JDBC ... driver and DBMS backend. ... * The Ultimate DBMS is here! ...
    (comp.lang.java.databases)