Re: jdbc/callable statment error
От | Dave Cramer |
---|---|
Тема | Re: jdbc/callable statment error |
Дата | |
Msg-id | 424A8915.8010306@fastcrypt.com обсуждение исходный текст |
Ответ на | jdbc/callable statment error (fake@dusk.homelinux.org) |
Список | pgsql-jdbc |
What do the logs say when you excecute this from psql ? Dave fake@dusk.homelinux.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 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 > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend > > > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561
В списке pgsql-jdbc по дате отправления: