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
