Skip site navigation (1) Skip section navigation (2)

CallableStatements: index starts at 2

From: Thomas Frieling <frieling(at)8hertz(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: CallableStatements: index starts at 2
Date: 2005-12-14 10:56:54
Message-ID: 439FFA76.1070706@8hertz.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
It seems that in Version "8.2dev-500 JDBC 3" CallableStatements are 
implemented differently from older Versions.
The index to set fields now starts at 2.

This _did_ work:
CallableStatement cS = con.prepareCall("{ call test(?)}";
cS.setString( 1, "abc" );

This _now_ works:
CallableStatement cS = con.prepareCall("{ call test(?)}";
cS.setString( 2, "abc" );

Thanks,
Thomas


Responses

pgsql-jdbc by date

Next:From: Rob KirkbrideDate: 2005-12-14 11:00:48
Subject: Group Query
Previous:From: kbforgeDate: 2005-12-13 20:12:08
Subject: New release: - kbforge 1.20 Free desktop search application with PGSQL database option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group