Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Calling PGSQL Stored function thru JDBC
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Nick Selva <mavles_pgsql(at)yahoo(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Calling PGSQL Stored function thru JDBC
- Date: Fri, 30 Jul 2004 01:31:23 -0500 (EST)
- Message-id: <Pine.BSO.4.56.0407300128350.4881@leary.csoft.net> <text/plain>
On Thu, 29 Jul 2004, Nick Selva wrote:
> [my CallableStatement doesn't work.]
You have misnumbered your parameters. You want to do cs.setString(2, "P")
because that matches with the second "?", and cs.registerOutParameter(1,
Types.VARCHAR) because that is the out parameter. You also may need to
say "{ ? = call get_state(?) }", note the equal sign.
Kris Jurka
- Follow-Ups:
- Re: Calling PGSQL Stored function thru JDBC
- From: Nick Selva
- Re: Calling PGSQL Stored function thru JDBC
- References:
- Calling PGSQL Stored function thru JDBC
- From: Nick Selva
- Calling PGSQL Stored function thru JDBC
- Prev by Date: Calling PGSQL Stored function thru JDBC
- Next by Date: PostgreSQL JDBC + Hibernate lose valuable debug info if an exception is thrown
- Previous by thread: Calling PGSQL Stored function thru JDBC
- Next by thread: Re: Calling PGSQL Stored function thru JDBC
- Indexes: