aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Creating a very basic JDBC driver" Watch "Creating a very basic JDBC driver" New topic
Author

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?

regards,
Mac


PhD Artificial Intelligence, OCJP1.6
David O'Meara
Rancher

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:
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating a very basic JDBC driver