Skip site navigation (1) Skip section navigation (2)

Re: jdbc/callable statment error

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: fake(at)dusk(dot)homelinux(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jdbc/callable statment error
Date: 2005-03-30 11:10:13
Message-ID: 424A8915.8010306@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
What do the logs say when you excecute this from psql ?

Dave

fake(at)dusk(dot)homelinux(dot)org wrote:

>When executing the following statments from netbeans 4.1 sun app server 8.1
>
>CallableStatement proc = con.prepareCall("{ ? = call test_function ( ? ) }");
>proc.registerOutParameter(1, Types.BOOLEAN);
>proc.setString(2, "testthis");
>proc.execute();
>
>This shows up in my server log.
>
>LOG:  statement: select * from  test_function ( 'thisTest' )  as result;
>ERROR:  function test_function("unknown") does not exist
>HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
>
>
>And I get an exception from my app server that states "No function" etc, etc...
>
>Now,  if I cut and paste that into my psql terminal it appears to work... So I'm really curious as to why it doesn't work through jdbc...
>
>Couple of things:  I'm getting my connection through a connection pool on my app server and that appears to be in working order...
>
>Any suggestions?
>
>
>Gary Lucas
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>  
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


In response to

pgsql-jdbc by date

Next:From: Charl GerberDate: 2005-03-30 14:44:28
Subject: Re: jdbc/callable statment error
Previous:From: fakeDate: 2005-03-30 09:55:13
Subject: Re: jdbc/callable statment error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group