Postgres Pro
Downloads
Home   >   mailing lists

Re: Callable Statements - Mailing list pgsql-jdbc

From Nic Ferrier
Subject Re: Callable Statements
Date
Msg-id 878yujijek.fsf@pooh-sticks-bridge.tapsellferrier.co.uk
Whole thread Raw
In response to Re: Callable Statements  (Pedro Salazar <pedro-b-salazar@ptinovacao.pt>)
List pgsql-jdbc
Tree view 
Pedro Salazar <pedro-b-salazar@ptinovacao.pt> writes:

> Hi Nic,
>
> for what object you should map the cursor?
>
> I have a sample that I register the parameter out to Types.OTHER. But,
> when I execute the CallableStatement, I got this error trace:
>
> No class found for refcursor
>         at
> org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)
>         at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)
>         at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:329)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
>

Are you using a version from CVS?


Nic

pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Index not used,
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Problems with Large Objects using Postgres 7.2.1