Home | Library | Jacquard | JDBC User Syntax

the Web Engineering Factory and Toolworks

JDBC User Syntax Repository

JDBC is a mechanism whose objective is to make applications portable between different database engines. However, it does a half arsed job. One particular area where it doesn't help you is in dealing with variant SQL syntax, and one particular area where SQL syntax varies a lot is in creating and manipulating user accounts, which is vital to any moderately secure application. As of Jacquard 1.10, Jacquard now includes a mechanism, uk.co.weft.dbutil.JDBCUserKluge, to provide database independent means for manipulating user accounts. That mechanism depends on the existance of this directory as a final repository of last resort for unknown user syntax variants.

The syntax variants are described in XML files whose basename is the JDBC subprotocol name for the database concerned. Thus if your database URL is

jdbc:postgresql://localhost/database

the subprotcol is postgresql, and the syntax variant file is postgresql.xml. If the sub protocol name includes colons, substitute underscores for these, thus:

jdbc:microsoft:sqlserver//localhost/database would have a syntax variant file microsoft_sqlserver.xml

You don't really need to know this unless we don't already have a syntax variant file for your database engine. JDBCUserKluge will compute the name and fetch the file automatically. If we don't already have a syntax variant file for your database engine, you can construct one using the DTD. If you do, please contribute it back to us, so that it can be available for other users of your database engine.

 Name                    Last modified      Description
 Parent Directory                           
 jdbcuserkluge.dtd       14-Dec-2004 11:25  
 jtds_sqlserver.xml      14-Dec-2004 12:32  
 microsoft_sqlserver.xml 14-Dec-2004 12:32  
 postgresql.xml          01-Jul-2004 16:36