From: | David Gagnon <dgagnon(at)siunik(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | question regarding upgrade from pg74.215.jdbc3.jar to postgresql-8.1-407.jdbc3.jar. function does not exist appeared ??? Please help :-/ |
Date: | 2006-08-22 22:15:47 |
Message-ID: | 44EB8213.2090303@siunik.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
Hi,
I just upgraded my jdbc driver and fixing stuff to make it work with
the new driver. I cannot find the answer to the following one. I
tried with the old driver and everything works. With the new one that
doesn't work.
Here is the function declaration:
CREATE OR REPLACE FUNCTION usp_Comptabilite_AgeDeCompteClient(VARCHAR,
VARCHAR, DATE, BOOLEAN, BOOLEAN, INT, VARCHAR) RETURNS refcursor AS $$
Here is the error that I grabbed from the postgresql log file:
select * from usp_Comptabilite_AgeDeCompteClient(M, NULL,
2006-08-22 -0400, 1, 1, 0, NULL)
2006-08-22 18:04:27 LOG: statement: PREPARE <unnamed> AS
select * from usp_Comptabilite_AgeDeCompteClient($1, $2, $3, $4,
$5, $6, $7)
2006-08-22 18:04:27 ERROR: function
usp_comptabilite_agedecompteclient(character varying, character varying,
"unknown", boolean, boolean, character varying, "unknown") does not exist
2006-08-22 18:04:27 HINT: No function matches the given name and
argument types. You may need to add explicit type casts.
2006-08-22 18:04:27 STATEMENT: select * from
usp_Comptabilite_AgeDeCompteClient($1, $2, $3, $4, $5, $6, $7)
If I execute the statement on pgAdminIII it works: select * from
usp_Comptabilite_AgeDeCompteClient('M', NULL, '2006-08-22',
true, true, '0', NULL) ;
Any idea what is the difference between drivers that can explain this.
And of course how I can fix the problem!
Thanks for your help! It's really appreciated!
Best Regards
/David
P.S.: I traced with the debugger and I do call setDate for arg $3. I
don't understand why it's still unknow ?
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-22 23:22:27 | Re: pl/R problem |
Previous Message | Tom Lane | 2006-08-22 22:13:11 | Re: share library version problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Vilar Flores | 2006-08-22 23:00:18 | Re: bytea memory improvement |
Previous Message | Grégory Chazalon | 2006-08-22 13:17:55 | Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails to execute (SimpleQuery splitting invalid) |