Re: Callable Statements

From: Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk>
To: Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt>
Cc: postgres <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Callable Statements
Date: 2003-04-09 19:02:27
Message-ID: 878yujijek.fsf@pooh-sticks-bridge.tapsellferrier.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2003-04-09 19:20:13 Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Previous Message Barry Lind 2003-04-09 19:00:21 Re: [JDBC] Index not used,