Meaningless Drivel is fun!
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
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.
I agree. Here's the link:
subject: Creating a very basic JDBC driver
It's not a secret anymore!