This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Level 4

 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I want to find out how long JDBC Level 4 drivers have been around. As I understand, only L4 supports cursors.
thanks,
Alex
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Alex Kravets:
Hi,
I want to find out how long JDBC Level 4 drivers have been around. As I understand, only L4 supports cursors.
thanks,
Alex
The difference between levels of drivers can be found here. It really has nothing to do with capabilities, as all jdbc 2.0 compliant drivers should support cursors and all other specifications laid out here.
 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks,
here is one more question. If I have a database that does not support cursors or understand what they are, can I use a JDBC driver of let's say Type 3, and implement cursors through this driver on the database?
thanks again,
Alex
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is the general rule:
If you can find a driver claims to support cursors( scrollable resultsets ) for a particular database, then it should support cursors ( being Type 1,2,3 or 4 driver is irrelevant ). If a database does not have cursors, then it will be impossible for any driver to use/support them.
What database are you trying to work with? Maybe if you tell us your specific situation, we could come up with some concrete advice/suggestions/recommendations.
 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are using Unify database, it is really old database. Using it on a UNIX machine is no problem since it references each record by location and just increments the location number, kind of like pointers. However, using database through Applets on the web does cause a problem. If let's say I have a table in database with identical records (no primary key), database does not differentiate between identical records, and displays wrong information. We thought about using cursors in order to get all information in a ResultSet and utilize cursors there. Also, if the search on the database returns let's say 100,000 records, we thought about paging the database using...yes cursors. But people at Unify say they do not support cursors, and do not know if they will. I read some info about different drivers and they claim that they can support cursors regardless of the database. Not sure if it's true though.
- Alex
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I did a search this and found that the iWay driver claims to be jdbc 2 compliant and can be used with Unify database. Your best bet is to get in touch with Unify and ask them what they recommend... or copy your database over to a database with the features that you need ( i.e. mySQL - is free ) if possible.
Jamie
 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for you help Jemie
 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
oops...Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic