From: | tarabas(at)tarabas(dot)de |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Problems with Timestamp and Function Calls in JDBC/Prepared Statement |
Date: | 2006-04-21 16:52:00 |
Message-ID: | 1145638320.890274.191530@z34g2000cwc.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi!
I am having a bit trouble with function-calls containing timestamps.
the function looks like this:
CREATE OR REPLACE FUNCTION do_something(int8, int8, int8, int8,
timestamptz, timestamptz, timestamptz, timestamptz, int8, timestamptz,
"varchar", int8, int8, "numeric", int8, int8)
RETURNS int8 AS
When I now try to call the function through the JDBC 8.1-405 JDBC 3
with a prepared Statement I do this:
ps.setLong(1, param1);
ps.setLong(2, param2);
ps.setLong(3, param3);
ps.setLong(4, param4);
ps.setTimestamp(5, param5);
ps.setTimestamp(6, param6);
ps.setTimestamp(7, param7);
ps.setTimestamp(8, param8);
ps.setLong(9, param9);
ps.setTimestamp(10, param10);
ps.setString(11, param11);
ps.setLong(12, param12);
ps.setLong(13, param13);
ps.setDouble(14, param14);
ps.setLong(15, param15);
ps.setLong(16, param16);
So the set-statements are correctly typed. Now I get this Errormessage
(although the function exists and the types were correctly set):
function do_something(bigint, bigint, bigint, bigint, "unknown",
"unknown", timestamp with time zone, "unknown", bigint, timestamp with
time zone, character varying, bigint, bigint, double precision, bigint,
bigint) does not exist
The odd thing is that when I do a setTimestamp() and the param is null,
the type timestamp seems to be used correctly (it is set to 1184). But
when the Timestamp is filled, the type is set to 0 in the prepared
statement.
When I look at the prepared statement in the debugger I get the
following paramTypes from the preparedParameters: [20, 20, 20, 20, 0,
0, 1184, 0, 20, 1184, 1043, 20, 20, 701, 20, 20]
and the following paramValues:
[0, 18, 1, 1, 2006-02-20 22:56:10.000000 +0100, 2006-02-20
22:56:10.000000 +0100, java(dot)lang(dot)Object(at)16f25a7, 2020-01-01
01:00:00.281000 +0100, 3, java(dot)lang(dot)Object(at)16f25a7, xxx, 14, 1, -1.0,
552, 1]
Anyone have any idea how to fix this? I also tried to set Timestamps
with setObject(index, value, Types.TIMESTAMP); without any luck.
I would appreciate any hint, workaround or bugfix for this behaviour
Best regards
Manuel
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2006-04-21 19:58:46 | Re: Problems with Timestamp and Function Calls in JDBC/Prepared |
Previous Message | Niels Beekman | 2006-04-21 14:24:59 | XA rollback problem |