From: | fake(at)dusk(dot)homelinux(dot)org |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: jdbc/callable statment error |
Date: | 2005-03-30 09:55:13 |
Message-ID: | 20050330095513.GA17040@dusk.homelinux.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
And now that I think of it, I'm useing postgres 7.4
Not sure how relevant that is,
Gary
On Wed, Mar 30, 2005 at 01:16:47AM -0800, 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-03-30 11:10:13 | Re: jdbc/callable statment error |
Previous Message | fake | 2005-03-30 09:16:47 | jdbc/callable statment error |