jdbc/callable statment error
| От | fake@dusk.homelinux.org |
|---|---|
| Тема | jdbc/callable statment error |
| Дата | |
| Msg-id | 20050330091647.GA16930@dusk.homelinux.org обсуждение |
| Ответы |
Re: jdbc/callable statment error
Re: jdbc/callable statment error |
| Список | pgsql-jdbc |
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
workthrough jdbc...
Couple of things: I'm getting my connection through a connection pool on my app server and that appears to be in
workingorder...
Any suggestions?
Gary Lucas
В списке pgsql-jdbc по дате отправления: