dtF/SQL JDBC Driver for Macintosh


This work is provided as open source to the MRJ developers community to provide both a JDBC implementation for use in developing products and to provide an example of writting JDBC drivers and JNI shared libraries.

I hope you have as much fun using it as I did writting it!

Development environment and source:

dtF/SQL JDBC Driver folder ( download)
Self extracting Stuffit file which creates a folder containing:
  • Metrowerks Pro 4 project, "dtF/SQL JDBC.mcp" with the targets for building the JDBC driver, the native shared library, and two demo applications.
  • JDBC driver, "dtF SQL JDBC.jar"
  • Native shared library, "dtF/SQL JDBC"
  • JBinary demo application "Connection Test". This application tests the various JDBC connection methods, as well as, demonstrates the subprotocal syntax for creating databases.
  • JBinary demo application "Coersion Test". Excersizes the specified JDBC data type coersions and demonstrates working with BLOB objects.
  • You will need: The most recent (v1.7.5) dtF/SQL distribution which includes the PPC shared library "dtFPPCSV1.shlb" and the application "dtFAdminPPC".
    This distribution is available free by registering at the sLab web site www.slab.de


Individual files:

ConnectionTest.java
This demo tests/illustrates the various JDBC connection methods, as well as, demonstrates the subprotocal syntax for creating databases.

CoercionTest.java
This demo excersizes the specified JDBC data type coersions and demonstrates working with BLOB objects.



dtF/SQL JDBC Driver Notes:

As this is the first release there are bound to be bugs and misconceptions on my part, please use the URL associated with the copyright below to send me e-mail.

The JDBC Driver, "dtF SQL JDBC.jar", should be merged into the JBindary application as should the application jar file. This was not done during development so that a change to the JDBC driver did not require the application to be rebuilt.

The resource file "Debugging.rsrc" was used during the early stages of development to detect and report dtF/SQL error conditions. It is no longer required but is included for completness, see the "Workspace.cpp" for the, commented-out, dtF/SQL error routine which uses these resources.


The PPC shared library "dtFPPCSV1.shlb" or an alias to it need to be in one of three places in order to be found by the Java Virtual Machine


Unexplained: Any "UPDATE" or "INSERT" SQL statement which involves a BLOB returns -1 for the row count. Do not use this as a test for success on these statements.


To be done: Rewrite the error handling between the JDBC drive and shared library so that the shared library throws the SQLException and SQLWarnings. Currently, the error state is save then polled upon the completion of the driver method invocation.

More tests, more examples, GUI browser, etc.
©1999 Will Gilbert, E-mail: Gilbert@Informagen.com