This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 77
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 Candidate: Distributed and Parallel Systems, Simulation and Modeling
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
Similar Threads
Need help
Using Java How to find a List of tablespaces in a database(Oracle,DB2,MSSQL)
some confusions about jdbc...
oracle and jdbc-odbc bridge
Im a bit confused