question regarding upgrade from pg74.215.jdbc3.jar to postgresql-8.1-407.jdbc3.jar. function does not exist appeared ??? Please help :-/ - Mailing list 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 ?