Re: JDBC and stored procedures - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: JDBC and stored procedures
Date
Msg-id 01071110202900.01127@inspiron
Whole thread Raw
In response to JDBC and stored procedures  (Tony Grant <tony@animaproductions.com>)
Responses Re: JDBC and stored procedures  (Tony Grant <tony@animaproductions.com>)
List pgsql-jdbc
Tony,

The GetProcedures function in the driver does not work.
You should be able to a simple select of the stored proc however

Dave

On July 11, 2001 09:06 am, Tony Grant wrote:
> Hello,
>
> I am trying to use a stored procedure via JDBC. The objective is to be
> able to get data from more than one table. My procedure is a simple get
> country name from table countries where contry code = $1 copied from
> Bruces book.
>
> Ultradev is giving me "Error calling GetProcedures: An unidentified
> error has occured"
>
> Just thought I would ask here first if I am up against a brick wall?
>
> Cheers
>
> Tony Grant
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia UltraDev with PostgreSQL
> http://www.animaproductions.com/ultra.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange behaviour of trigger functions when initiated via jdbc
Next
From: Nikk Anderson
Date:
Subject: RE: jdbc and unix signals