File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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: 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?

regards,
Mac


PhD Candidate: Distributed and Parallel Systems, Simulation and Modeling
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
 
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