aspose file tools*
The moose likes JDBC and the fly likes JDBC Level 4 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Level 4" Watch "JDBC Level 4" New topic
Author

JDBC Level 4

Alex Kravets
Ranch Hand

Joined: Jan 24, 2001
Posts: 476
Hi,
I want to find out how long JDBC Level 4 drivers have been around. As I understand, only L4 supports cursors.
thanks,
Alex


All right brain, you don't like me and I don't like you, but let's just do this one thing so I can get back to killing you with beer.<br /> <br />- Homer Simpson
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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

Joined: Jan 24, 2001
Posts: 476
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

Joined: Jul 09, 2001
Posts: 1879

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

Joined: Jan 24, 2001
Posts: 476
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

Joined: Jul 09, 2001
Posts: 1879

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

Joined: Jan 24, 2001
Posts: 476
thanks for you help Jemie
Alex Kravets
Ranch Hand

Joined: Jan 24, 2001
Posts: 476
oops...Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Level 4
 
Similar Threads
Statement vs PreparedStatement
JDBC Isolation level?
JDBC Type $ Driver
Dynamic SQL with JDBC
Where can I find JDBC for DB2 9.