Re: JDBC support for 8.1 OUT parameters
От | Adam Zimowski |
---|---|
Тема | Re: JDBC support for 8.1 OUT parameters |
Дата | |
Msg-id | 7c6c1dd90603050846j6d1987ffnbbddbcd01f0fd11f@mail.gmail.com обсуждение исходный текст |
Ответ на | JDBC support for 8.1 OUT parameters ("Adam Zimowski" <zimowski74@gmail.com>) |
Список | pgsql-jdbc |
Just a quick note: In my code I'm using Types.OTHER. As a troubleshooting step I also tried Types.REF. The PostgreSQL version I'm on is 8.1.0. CREATE OR REPLACE FUNCTION main.p_get_profile_simple(IN _profile_id int8, OUT _main refcursor, OUT _lookingfor refcursor, OUT _purpose refcursor) AS .... CallableStatement stmt = null; stmt = oCon.prepareCall("{ call main.p_get_profile_simple(?,?,?,?) }"); stmt.setLong(1, aMemberId); stmt.registerOutParameter(2, Types.OTHER); stmt.registerOutParameter(3, Types.OTHER); stmt.registerOutParameter(4, Types.OTHER); Regards, Adam On 3/5/06, Adam Zimowski <zimowski74@gmail.com> wrote: > Hi, > > Do you know where I can find Postgres JDBC driver that supports out > parameters? When I call my procedure, I'm getting: > > org.postgresql.util.PSQLException: A CallableStatement function was > executed and the return was of type java.sql.Types=1111 however type > java.sql.Types=0 was registered. > > I'm pretty sure the driver version I have > (postgresql-8.1-405.jdbc3.jar) supports OUT only on first parameter. > I've looked on the web but did not find anything. I saw a few patches, > but I wasn't sure if they were it. > > CREATE OR REPLACE FUNCTION main.p_get_profile_simple(IN _profile_id > int8, OUT _main refcursor, OUT _lookingfor refcursor, OUT _purpose > refcursor) AS > .... > > CallableStatement stmt = null; > stmt = oCon.prepareCall("{ call main.p_get_profile_simple(?,?,?,?) }"); > stmt.setLong(1, aMemberId); > stmt.registerOutParameter(2, Types.REF); > stmt.registerOutParameter(3, Types.REF); > stmt.registerOutParameter(4, Types.REF); > > Regards, > Adam >
В списке pgsql-jdbc по дате отправления: