Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc previous/last/first/next methods

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sunny,
Can you send us the driver details and the details of the database you are trying connect to?
Regards,
Milind
 
sunny
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank u very much milind
sunny
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic