question regarding upgrade from pg74.215.jdbc3.jar to postgresql-8.1-407.jdbc3.jar. function does not exist appeared ??? Please help :-/
От | David Gagnon |
---|---|
Тема | question regarding upgrade from pg74.215.jdbc3.jar to postgresql-8.1-407.jdbc3.jar. function does not exist appeared ??? Please help :-/ |
Дата | |
Msg-id | 44EB8213.2090303@siunik.com обсуждение исходный текст |
Ответы |
Re: question regarding upgrade from pg74.215.jdbc3.jar to
|
Список | 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 ?
В списке pgsql-jdbc по дате отправления: