ResulSet.absolute() unsupported?

Thread View: comp.lang.java.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Roland Zumkeller Wed, 02 Aug 2000 00:00

#34

Author: Roland Zumkeller
Date: Wed, 02 Aug 2000 00:00

19 lines
1333 bytes

Hi,
I'm having problems to do very simple things with a ResulSet: Moving the
cursor and asking it where it is.

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
    Connection conn = DriverManager.getConnection("jdbc:odbc:myDb",
"sa", "");
    Statement s = conn.createStatement();
    ResultSet r = s.executeQuery("SELECT * FROM myTable");
    r.absolute (1);

When executing this, I'm getting an "UnsupportedOperationException" on
the absoulte()-method. The same happens when I call getRow(). What am I
doing wrong? The Database is a MS SQL Server 7.0 and I'm pretty sure it
supports these things, because I've done them with Visual Basic before.

Thanks,

Roland

Re: ResulSet.absolute() unsupported?

#31

Author: Franck Deliot
Date: Thu, 03 Aug 2000 00:00

29 lines
1873 bytes

Hi,

    I have the same problem with last(), first(), previous(), absolute(),
getRow(). Only next() is working. I use MS SQL 7.0 or Access 97 and I had no
problem with VB 6.0.
    So if someone can help Roland and I...

Franck.
Roland Zumkeller <Roland.Zumkeller@web.de> a �crit dans le message :
398880B2.D98B1AE7@web.de...
> Hi,
> I'm having problems to do very simple things with a ResulSet: Moving the
> cursor and asking it where it is.
>
>     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>     Connection conn = DriverManager.getConnection("jdbc:odbc:myDb",
> "sa", "");
>     Statement s = conn.createStatement();
>     ResultSet r = s.executeQuery("SELECT * FROM myTable");
>     r.absolute (1);
>
> When executing this, I'm getting an "UnsupportedOperationException" on
> the absoulte()-method. The same happens when I call getRow(). What am I
> doing wrong? The Database is a MS SQL Server 7.0 and I'm pretty sure it
> supports these things, because I've done them with Visual Basic before.
>
> Thanks,
>
> Roland

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads