[sqlitejdbc] BUGFIX for thread rs.getInt("table.column")

[FARKAS Máté]

FARKAS Máté írta:
> Why is it not too good? I must use
>
>     rs = connection.createStatement().executeQuery("SELECT * FROM
>     sqlitetest");
>     while (rs.next()) {
>         System.out.println(*rs.getInt("sqlitetest.id")*);
>     }
>
> Because it doesn't understand *rs.getInt("id")*;
In RS.java at line 103 I have found

    for (int i=0; i < cols.length; i++) {
        if (col.equalsIgnoreCase(cols[i])
            || (*cols[i].toUpperCase().endsWith(col.toUpperCase()) &&**
    **            cols[i].charAt(cols[i].length() - col.length()) ==
    '.')*) {
            if (c == -1)
                c = i;
            else
                throw new SQLException("ambiguous column: '"+col+"'");
        }
    }

But if

    cols[i] == "sqlitetest.id"
    col == "id"

then

    cols[i].charAt(cols[i].length() - col.length()) == "i" // Not "."

So please use

    cols[i].charAt(cols[i].length() - col.length() *- 1*) == "."


Regards,
Máté.


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