aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Creating a very basic JDBC driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Creating a very basic JDBC driver" Watch "Creating a very basic JDBC driver" New topic

Creating a very basic JDBC driver

Siamak Saarmann
Ranch Hand

Joined: Aug 21, 2004
Posts: 78
Hello Everyone,

A few of the students in my lab are creating a distributed database server (user does not understand the database is distributed, he uses a jdbc driver to connect to one of the nodes and it acts as if it is a single node database).

Now I am asked to develop a JDBC driver for that project.

I downloaded and looked at MySQL's last jdbc driver (which is quite big in source size) and their first v2.0 driver which is quite simple.

1- If I implement my JDBC driver based on jdbc 1.X specifications, will it be possible to use it under JSE5 and 6? Or I should implement the latest specs (jdbc 4.X)?

2- Is anyone aware of a smaller more simple open source jdbc driver which I can take a look at it?

3- I was able to download "JDBC 1.0.2 API" from sun however there is no java interface files etc available. Are they included in JSE?


PhD Artificial Intelligence, OCJP1.6
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

There are a number of Sourceforge projects that add various features to JDBC Drivers, and I imagine some of them would have code demonstrating parts of your requirements.

Searching for 'JDBC' I saw: A JDBC Proxy Sybase JDBC driver JDBC to JDBC bridge High Availability JDBC Driver

The last one adds clustering and failover at the JDBC level and maybe of interest to you.
subject: Creating a very basic JDBC driver
It's not a secret anymore!