[sqlitejdbc] ResultSet.getLong()

[[EMAIL PROTECTED]]

Hallo,

I have a problem using the v038 and v037native sqlite wrapper from a
java program. The ResultSet.getLong("fieldname") returns sometimes
unexisting very big.

Here is my test code:

ResultSet execSQLwithResult( String sql ) throws SQLException
    {
        Statement stmt = this.dbCon.createStatement();
        ResultSet retVal = stmt.executeQuery( sql );
        return retVal;
    }

ResultSet rs = DBMgr.getDBMgr().execSQLwithResult(Select * from tbl);
            while ( rs.next() )
            {
                long l = rs.getLong( "fieldName" );
                long i = rs.getInt( " fieldName " );

and the result is: i = 160 and l = 1955378350784672 (i, 160 is the
correct value from the db).

As already written, the error appears only sometimes, and it seems to
me that it appears only when I have nested queries like:

ResultSet rs = DBMgr.getDBMgr().execSQLwithResult( "Select * from
tbl" );
while (rs.next())
{
        ResultSet rs2 = DBMgr.getDBMgr().execSQLwithResult( "Select * from
othertbl" );

}

Any idea?

Thanks in advance
Frank

--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---