Creating a very basic JDBC driver

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?

regards,
Mac

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:
https://sourceforge.net/projects/jdbcproxy/ A JDBC Proxy
https://sourceforge.net/projects/jtds/ Sybase JDBC driver
https://sourceforge.net/projects/jdbc2jdbc/ JDBC to JDBC bridge
https://sourceforge.net/projects/ha-jdbc/ High Availability JDBC Driver

The last one adds clustering and failover at the JDBC level and maybe of interest to you.