Sybase ODBC - Problem with last() Method

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with last() Method

Thorsten Dietz

2005-06-17, 3:23 am

I m using ASA 9.0.2 Win32.
I want to switch from jconnect to JODBC-Bridge, but I get an
error at following code. By using Jconnect there is no
problem and JODBC supports this type.

stmt =
conn. createStatement(Resu
ltSet. TYPE_SCROLL_INSENSIT
IVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql.toString());
int row = 0;
if (rs.last()) {
row = rs.getRow();
rs.beforeFirst();
}

After rs.last() the cursor is always -1.

Knows anybody a solution or can help me.

Thanks,
Thorsten

Sponsored Links