Re: Unsupported method error on methods of ResultSet class

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 03/11/04


Date: Thu, 11 Mar 2004 09:00:24 -0800


Benjamin wrote:

> Hi, I have the same problem and I was wondering if there was a way to solve it without changing the source code.
> I am a newcomer as well in this area, and it seams that the problems comes from the type of cursor defined. I am using Weblogic 8.1,
> and in the properties it seems that we can define a 'selectMethod' to 'direct' or 'cursor'. I have tried both of them but i obtain the same problem ( java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported method: ResultSet.isAfterLast). I am probably misunderstanding something, I am also looking for some documentation on the subject.
>
> Thx for any help
> --
> Benjamin

Hi. The two issues are unrelated. For use in Weblogic, you should definitely set
the selectMethod to cursor. The other issue is simply that the driver has not
implemented the isAfterLast() method, and is telling you that. You will have to either
alter your application code not to depend on that call, or you can use another
driver for MS SQLServer. In 8.1 we ship a very similar-but-better driver for MS
SQLServer. Try that one (weblogic.jdbc.sqlserver.SQLServerDriver)
Joe Weinstein at BEA



Relevant Pages

  • Re: Cursor problems Wd 2003
    ... Graham, I haven't actually updated the driver yet, but it is a recent driver ... Whether the cursor is at the ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.docmanagement)
  • Re: How to show/hide cursor on attach/deattach usb mouse
    ... If the cursor is not visible, your display driver is not drawing it. ... Can you have any idea where i put registration notifications for ...
    (microsoft.public.windowsce.platbuilder)
  • Re: How to show/hide cursor on attach/deattach usb mouse
    ... Along with that Display Driver is modified with RequestDeviceNotifications, ... and switching on/off the cursor. ... handling USB mouse device notifications. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: How to show/hide cursor on attach/deattach usb mouse
    ... I have modified the display driver properly and all works... ... Can you have any idea where i put registration notifications for usb mouse ... There's no 'enable/disable cursor here' function. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: SelectMethod=cursor and SelectMethod=direct
    ... All the database updates/inserts are done by sql using a prepared statement and then setting the field parameters. ... My only concern is the memory usage as a direct cursor reads the complete resultset into memory. ... If the free MS driver reads everything in immediately, it's just something you would have to deal with, alloting your client enough memory to handle it. ...
    (microsoft.public.sqlserver.jdbcdriver)