| From: | Barry Lind <barry(at)xythos(dot)com> |
|---|---|
| To: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
| Cc: | Postgres SQL Mailing List <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Function calls via JDBC |
| Date: | 2001-10-16 20:27:44 |
| Message-ID: | 3BCC9840.4030300@xythos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
functions in PostgreSQL are called via a select statement.
Issue "select your_custom_function()" in a Statement or
PreparedStatement. Then get the result like any other select statement
via the ResultSet.
thanks,
--Barry
Oleg Lebedev wrote:
> Hi,
> I created a PL/pgSQL function, but can not call it from my Java program.
>
> I tried using CallableStatement, but it gave me an exception:
> Callable Statements are not supported at this time.
> So, how should I execute a stored procedure via JDBC?
> Thanks,
>
> Oleg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2001-10-16 20:41:37 | Re: Function calls via JDBC |
| Previous Message | Marko Kreen | 2001-10-16 18:29:03 | Ant configuration |