From: | Scott Lamb <slamb(at)slamb(dot)org> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: setUseServerPrepare & typecasts |
Date: | 2002-11-13 22:52:28 |
Message-ID: | 3DD2D7AC.6000703@slamb.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Barry Lind wrote:
> Scott,
>
> If you use ps.setInt(1,42) does it work? I want to isolate the problem.
> In just looking at the code, it seems that the setInt() and setObject()
> methods do the same thing.
Ahh, I'm sorry. setObject(1, new Object(42), Types.INTEGER) doesn't do
it after all. I translated inappropriately when I was writing the email.
setObject(1, null, Types.INTEGER) is the problem. Test function and Java
program attached to reproduce.
Scott
Attachment | Content-Type | Size |
---|---|---|
PreparedCastTest.java | text/plain | 1.1 KB |
preparedCastTest.sql | text/plain | 149 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Ansley | 2002-11-13 23:28:46 | JDBC3 and DataSource |
Previous Message | Varun Kacholia | 2002-11-13 17:54:17 | Re: Help with JDBC connection... |