SQLException while using next()-method in scrolling a ResultSet

From: David Thijs (david.thijs75_at_pandora.be)
Date: 12/10/03

  • Next message: Mladen Adamovic: "Re: Which one is better,PostgreSQL or MySQL ?" 
    Date: 10 Dec 2003 00:12:19 -0800

    Hi,

    I'm having a strange problem, each time I want to go through a
    ResultSet by using :

        query = "select * from TBL_test_ulrik";
        try{
          rs = s.executeQuery(query);
          int i=0;
          while (rs.next()){
            System.out.println(rs.getString(1));
            
          }
        }
        catch (SQLException se){
          se.printStackTrace();
        }

    I get the following error-message

    java.sql.SQLException: [interclient][interbase]arithmetic exception,
    numeric overflow, or string truncation
    [interclient][interbase]Cannot transliterate character between
    character sets

            at interbase.interclient.ResultSet.remote_FETCH_ROWS(Unknown Source)

            at interbase.interclient.ResultSet.getNextCursorPosition(Unknown
    Source)

            at interbase.interclient.ResultSet.next(Unknown Source)

            at tree_db.DBConnection_Tris.roepWaardenOp(DBConnection_Tris.java:93)

            at tree_db.ReadTextFile_Tris.zoekinDB(ReadTextFile_Tris.java:155)

            at tree_db.ReadTextFile_Tris.maakKeuze(ReadTextFile_Tris.java:33)

            at tree_db.ReadTextFile_Tris.<init>(ReadTextFile_Tris.java:14)

            at tree_db.ReadTextFile_Tris.main(ReadTextFile_Tris.java:159)

    What is strange is that the same structure for executing another query
    on another table doesn't give me this error-message.
    Is there someone who can help me ??

    Greetings,

    David

  • Next message: Mladen Adamovic: "Re: Which one is better,PostgreSQL or MySQL ?"