Re: debugging prepared statements

On Fri, 7 Feb 2003 08:32:51 -0500 (EST) Richard Welty <rwelty@averillpark.net> wrote:
> and the debug output. note that the toString() method on the prepared
> statement just produces the string of "?null" values. what is interesting
> is that there are 9 of them, and it is the ninth set which blows up.

> statement: ?null?null?null?null?null?null?null?null?null

what is interesting is that the insert, which is succeeding (or at least
was until i broke it 5 minutes ago), has the following .toString() output:

statement: ?null?null?null?null?null?null?null?null?null?null?null?null)

which is the expected number of ? characters (12). the processing of the
prepared statements for the update and the insert does indeed seem to be
behaving differently.

i don't see any material difference in the way that i construct the Insert
prepared statement and the Update prepared statement except for the things
required by SQL syntax.

i left the environment information out of the previous posting:

RedHat 7.3
postgresql 7.2.1-5 from the rpm
pgjdbc2.jar from the website late october of last year
jdk 1.4.1_01

thanks in advance for any help/advice,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
              Unix, Linux, IP Network Engineering, Security