Re: TYPE_FORWARD_ONLY
thak you,
The problem was in 'else....' I don't put :
ResultSet.
> TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_READ_ONLY
than you for all
>From: "Doug Lawry" <lawry@nildram.co.uk>
>Reply-To: "Doug Lawry" <lawry@nildram.co.uk>
>To: informix-list@iiug.org
>Subject: Re: TYPE_FORWARD_ONLY
>Date: Thu, 22 Apr 2004 12:24:58 +0100
>
>1) You need "EXECUTE PROCEDURE" instead of "CALL".
>2) Remove brackets "{" and "}" from the quoted statement.
>3) Use "?" as a place marker for variables.
>4) Specify variables with "pstmt.setString(number,value)".
>
>A full example follows.
>
>Regards,
>Doug Lawry
>www.douglawry.webhop.org
>
>-----------------------------------------------------------------
>
>// Informix JDBC stored procedure demo
>
>// Doug Lawry, 22/04/2004
>
>import java.sql.*;
>
>public class JdbcTest
>{
> static final String jdbc_url =
> "jdbc:informix-sqli://" +
> "YourHost/YourDatabase:" +
> "INFORMIXSERVER=YourServer;" +
> "user=YourLogin;" +
> "password=YourPassword";
>
> static final String sql_code =
> "EXECUTE PROCEDURE YourProcedureName(?)";
>
> static final String sql_data =
> "YourProcedureParameterValue";
>
> public static void main(String[] argv)
> {
> try
> {
> Class.forName("com.informix.jdbc.IfxDriver");
> }
> catch(ClassNotFoundException e)
> {
> System.out.println("Unknown Class: " + e.getMessage());
> return;
> }
> try
> {
> Connection conn = DriverManager.getConnection(jdbc_url);
> PreparedStatement pstmt = conn.prepareStatement(sql_code);
> pstmt.setString(1, sql_data);
> ResultSet r = pstmt.executeQuery();
> while (r.next())
> System.out.println(r.getString(1));
> }
> catch(SQLException e)
> {
> System.out.println("SQL Exception: " + e.getMessage());
> return;
> }
> }
>}
>
>-----------------------------------------------------------------
>
>"Araujo" <araujo_guntin@hotmail.com> wrote:
>
>Hi everybody...
>
>I have the following stored procedure:
>
>create procedure sp_select_tticu()
> returning integer, char(50) ;> define p_coditicu integer ;
> define p_nombticu char(50);
>
> foreach
> select coditicu, nombticu
> into p_coditicu, p_nombticu
> from tticu
> return p_coditicu, p_nombticu with resume ;>
> end foreach;
>end procedure
>
>..and I use it from JDBC, with following code:
>
> public Object[][] select(String coditicu) {
> valoresSeleccionados = coditicu;
> PreparedStatement pstmt;
>
> Object[][] selectCodiNomb = null;
>
> try {
> if (coditicu != null) {
> pstmt = Connect.conn.prepareStatement(
> "{call sp_coditicu(" + coditicu + ")};", ResultSet.
> TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_READ_ONLY
> );
> }
> else {
> pstmt = Connect.conn.prepareStatement(
> "{call sp_select_tticu()};");
> }
> ResultSet r = pstmt.executeQuery();
>
> r.last();
> int numberOfRecords = r.getRow();
> selectCodiNomb = new String[numberOfRecords][2];
> r.beforeFirst();
>
> int i = 0;
> while (r.next()) {
> selectCodiNomb[i][0] = r.getString(1);
> selectCodiNomb[i][1] = r.getString(2);
> i++;
> }
> r.close();
> pstmt.close();
> return selectCodiNomb;
> }
> catch (SQLException e) {
> System.out.println("FAILED: Prepare select(String coditicu) failed:
>"
> + e.getErrorCode());
> }
> return selectCodiNomb;
> }
>
>and I have the error:
>
> FAILED: Prepare select(String coditicu) failed: -79767
>
>because ResultSet Type is TYPE_FORWARD_ONLY, according to database
>messages.
>
>What can I do????
>
>
_________________________________________________________________
MSN Amor: busca tu ' naranja http://latam.msn.com/amor/
sending to informix-list