ResultSet.absolute with MySQL

View: New views
3 Messages — Rating Filter:   Alert me  

ResultSet.absolute with MySQL

by Sergio Corato :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I pass the same variable, taken with ResultSet.getRow() to MySQL and
Hsqldb, but with MySQL this don't work, giving False, while with HsqlDB
it works.
Why?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Re: ResultSet.absolute with MySQL

by Frank Schoenheit, Sun Microsystems Germany :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Sergio,

> I pass the same variable, taken with ResultSet.getRow() to MySQL and
> Hsqldb, but with MySQL this don't work, giving False, while with HsqlDB
> it works.
> Why?

Since you meanwhile asked this question in dev@api, with more details, I
answered it over there. Bottom line: chances are the driver supports
FORWARD_ONLY cursors only, while your code requires a freely scrollable
cursor. For details, see my other mail, please.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Re: ResultSet.absolute with MySQL

by Sergio Corato :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Frank Schoenheit, Sun Microsystems Germany ha scritto:

> Hi Sergio,
>
>  
>> I pass the same variable, taken with ResultSet.getRow() to MySQL and
>> Hsqldb, but with MySQL this don't work, giving False, while with HsqlDB
>> it works.
>> Why?
>>    
>
> Since you meanwhile asked this question in dev@api, with more details, I
> answered it over there. Bottom line: chances are the driver supports
> FORWARD_ONLY cursors only, while your code requires a freely scrollable
> cursor. For details, see my other mail, please.
>
> Ciao
> Frank
>
>  
Thanks
Ciao
Sergio

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...