File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes jdbc previous/last/first/next methods Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc previous/last/first/next methods" Watch "jdbc previous/last/first/next methods" New topic
Author

jdbc previous/last/first/next methods

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
please tell me how to implement first / next / previous / last methods to be implemented with jdbc , how should i do it directly like i do it in visual basic
Harish Kashyap
Ranch Hand

Joined: Jun 14, 2000
Posts: 118
Why do u want to implement them when they are already declared in the java.sql.ResultSet interface and are implemented. You simply call the methods using the references of ResultSet and get the result.
sunny
Greenhorn

Joined: Feb 01, 2001
Posts: 23
But using those functions gives run time error saying that these functions are not supported only the next() function executes.
Some told me that it is because the older versions driver classes does not support them so u have to update the driver classes
is it right?
sunny
Milind Kulkarni
Ranch Hand

Joined: Jun 01, 2000
Posts: 146
Hi Sunny,
Can you send us the driver details and the details of the database you are trying connect to?
Regards,
Milind
sunny
Greenhorn

Joined: Feb 01, 2001
Posts: 23
hai milind
I donot know which type of driver it is just we give the path to load the files is sun.odbc.jdbc.JdbcOdbcDriver as a parameter to forName method of Class. and about the databases ms access 7 and oracle 8i for both previous,first,last functions are not working and I am working on jdk2.
sunny
Greenhorn

Joined: Feb 01, 2001
Posts: 23
hai milind
I donot know which type of driver it is just we give the path to load the files is sun.odbc.jdbc.JdbcOdbcDriver as a parameter to forName method of Class. and about the databases ms access 7 and oracle 8i for both previous,first,last functions are not working and I am working on jdk2.
Milind Kulkarni
Ranch Hand

Joined: Jun 01, 2000
Posts: 146
Hi Sunny,
You can get the driver information using getDriverName() and getDriverVersion() of DatabaseMetaData object. A driver that you are using may not suitable for Oracle and Access. Check out the list of drivers here �
http://industry.java.sun.com/products/jdbc/drivers
Regards,
Milind
sunny
Greenhorn

Joined: Feb 01, 2001
Posts: 23
thank u very much milind
sunny
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc previous/last/first/next methods