|
JavaXT
|
|
Driver Class
package javaxt.sql;
//******************************************************************************
//** Driver
//******************************************************************************
/**
* Used to encapsulate basic driver information used to create a database
* connection.
*
******************************************************************************/
public class Driver {
private String vendor;
private String driverClass;
private String protocol;
private java.sql.Driver driver;
/** Static list of drivers and corresponding metadata */
private static Driver[] drivers = new Driver[]{
//The following drivers have been tested worked at some point
new Driver("PostgreSQL","org.postgresql.Driver","jdbc:postgresql"),
new Driver("Oracle", "oracle.jdbc.driver.OracleDriver", "jdbc:oracle"),
new Driver("SQLServer","com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver"),
new Driver("DB2","com.ibm.db2.jcc.DB2Driver","jdbc:db2"), //"COM.ibm.db2.jdbc.net.DB2Driver"
new Driver("Sybase","com.sybase.jdbc3.jdbc.SybDriver","jdbc:sybase"),
new Driver("MySQL", "com.mysql.jdbc.Driver", "jdbc:mysql"),
new Driver("Derby","org.apache.derby.jdbc.EmbeddedDriver","jdbc:derby"),
new Driver("SQLite","org.sqlite.JDBC","jdbc:sqlite"),
new Driver("H2", "org.h2.Driver", "jdbc:h2"),
new Driver("OpenSearch", "org.opensearch.jdbc.Driver", "jdbc:opensearch"),
new Driver("Firebird", "org.firebirdsql.jdbc.FBDriver", "jdbc:firebirdsql"),
new Driver("Microsoft Access","sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}"),
//The rest of these drivers have never been tested
new Driver("FrontBase", "com.frontbase.jdbc.FBJDriver", "jdbc:FrontBase"),
new Driver("Informix", "com.informix.jdbc.IfxDriver", "jdbc:informix-sqli"),
new Driver("Cache", "com.intersys.jdbc.CacheDriver", "jdbc:Cache"),
new Driver("microsoft", "com.microsoft.jdbc.sqlserver.SQLServerDriver", "jdbc:microsoft"),
new Driver("Mimer", "com.mimer.jdbc.Driver", "jdbc:mimer"),
new Driver("Teradata", "com.ncr.teradata.TeraDriver", "jdbc:teradata"),
new Driver("Pervasive", "com.pervasive.jdbc.v2.Driver", "jdbc:pervasive"),
new Driver("Pointbase", "com.pointbase.jdbc.jdbcUniversalDriver", "jdbc:pointbase"),
new Driver("pointbase micro", "com.pointbase.me.jdbc.jdbcDriver", "jdbc:pointbase:micro"),
new Driver("Daffodil", "in.co.daffodil.db.jdbc.DaffodilDBDriver", "jdbc:daffodil"),
new Driver("daffodilDB", "in.co.daffodil.db.rmi.RmiDaffodilDBDriver", "jdbc:daffodilDB"),
new Driver("JTDS", "net.sourceforge.jtds.jdbc.Driver", "jdbc:jtds"), //Open source JDBC 3.0 type 4 driver for Microsoft SQL Server and Sybase ASE
new Driver("derby net", "org.apache.derby.jdbc.ClientDriver", "jdbc:derby:net"),
//new Driver("derby //", "org.apache.derby.jdbc.ClientDriver", "jdbc:derby://"),
new Driver("HyperSQL", "org.hsqldb.jdbcDriver", "jdbc:hsqldb"),
new Driver("odbc", "sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc")
};
/** Microsoft SQL Server database driver. */
public static Driver SQLServer = findDriver("SQLServer");
/** IBM DB2 database driver. */
public static Driver DB2 = findDriver("DB2");
/** Sybase ASE database driver. */
public static Driver Sybase = findDriver("Sybase");
/** PostgreSQL database driver. */
public static Driver PostgreSQL = findDriver("PostgreSQL");
/** Derby database driver. */
public static Driver Derby = findDriver("Derby");
/** SQLite database driver. */
public static Driver SQLite = findDriver("SQLite");
/** Microsoft Access database driver. */
public static Driver Access = findDriver("Microsoft Access");
public static Driver FrontBase = findDriver("FrontBase");
public static Driver Informix = findDriver("Informix");
public static Driver Cache = findDriver("Cache");
public static Driver Mimer = findDriver("Mimer");
public static Driver MySQL = findDriver("MySQL");
public static Driver Teradata = findDriver("Teradata");
public static Driver Pervasive = findDriver("Pervasive");
public static Driver Pointbase = findDriver("Pointbase");
//public static Driver pointbase micro = findDriver("pointbase micro");
public static Driver Daffodil = findDriver("Daffodil");
//public static Driver daffodilDB = findDriver("daffodilDB");
public static Driver JTDS = findDriver("JTDS");
public static Driver Oracle = findDriver("Oracle");
public static Driver Firebird = findDriver("Firebird");
public static Driver H2 = findDriver("H2");
public static Driver HyperSQL = findDriver("HyperSQL");
public static Driver ODBC = findDriver("odbc");
//**************************************************************************
//** Constructor
//**************************************************************************
/** Creates a new instance of this class. Here are some common examples:
<pre>
new Driver("SQLServer","com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver");
new Driver("DB2","com.ibm.db2.jcc.DB2Driver","jdbc:db2");
new Driver("Sybase","com.sybase.jdbc3.jdbc.SybDriver","jdbc:sybase");
new Driver("PostgreSQL","org.postgresql.Driver","jdbc:postgresql");
new Driver("Derby","org.apache.derby.jdbc.EmbeddedDriver","jdbc:derby");
</pre>
* @param vendor Name the database/vendor. This keyword used extensively in
* the javaxt.sql.Recordset class to accommodate inconsistent JDBC
* implementations between database vendors. As such, please use the names
* provided in the driver list above (e.g. "PostgreSQL", "SQLServer", etc).
* @param driver Class name used to create a java.sql.Driver.
* @param protocol Protocol used in the jdbc connection string.
*/
public Driver(String vendor, String driver, String protocol){
this.vendor = vendor;
this.driverClass = driver;
this.protocol = protocol;
}
//**************************************************************************
//** Constructor
//**************************************************************************
/** Creates a new instance of this class with a given java.sql.Driver.
*/
public Driver(java.sql.Driver driver){
String className = driver.getClass().getCanonicalName();
this.driverClass = className;
this.driver = driver;
for (Driver d : drivers){
if (d.equals(className)){
this.vendor = d.vendor;
this.protocol = d.protocol;
break;
}
}
}
//**************************************************************************
//** getProtocol
//**************************************************************************
/** Returns the url protocol used in the jdbc connection string (e.g.
* jdbc:sqlserver, jdbc:db2, jdbc:sybase, jdbc:postgresql, jdbc:derby).
*/
public String getProtocol(){
return protocol;
}
//**************************************************************************
//** getClassName
//**************************************************************************
/** Returns the class name used to create a new java.sql.Driver (e.g.
* com.microsoft.sqlserver.jdbc.SQLServerDriver).
*/
public String getClassName(){
return driverClass;
}
//**************************************************************************
//** getVendor
//**************************************************************************
/** Returns the name the database/vendor (e.g. SQLServer, DB2, Sybase, etc.)
*/
public String getVendor(){
return vendor;
}
//**************************************************************************
//** load
//**************************************************************************
/** Used to create a new instance of a java.sql.Driver that corresponds to
* the driver class specified in the constructor.
*/
public java.sql.Driver load() throws java.sql.SQLException{
if (driver==null && driverClass!=null){
//System.out.print("Loading Driver...");
try{
driver = (java.sql.Driver) Class.forName(driverClass).newInstance();
}
catch(Exception e){
throw new java.sql.SQLException("Failed to load driver " + driverClass, e);
}
//DriverManager.registerDriver(Driver);
//System.out.println("Done");
}
return driver;
}
protected java.sql.Driver getDriver(){
return driver;
}
//**************************************************************************
//** equals
//**************************************************************************
/** Used to compare drivers by class, protocol, and vendor.
* @param obj Accepts either a javaxt.sql.Driver or a String representing
* the driver class, protocol, or vendor.
*/
public boolean equals(Object obj){
if (obj instanceof Driver){
Driver driver = (Driver) obj;
if (driver.getClassName().equalsIgnoreCase(this.getClassName()) &&
driver.getProtocol().toLowerCase().startsWith(this.getProtocol()) &&
driver.getVendor().equalsIgnoreCase(this.getVendor())
){
return true;
}
else{
return false;
}
}
else if(obj instanceof java.lang.String){
String driverName = obj.toString();
//Fetch/update protocol to avoid NPE
String protocol = this.getProtocol();
if (protocol==null) protocol = "";
if (driverName.equalsIgnoreCase(this.getClassName()) ||
driverName.toLowerCase().startsWith(protocol.toLowerCase()) ||
driverName.equalsIgnoreCase(this.getVendor())
){
return true;
}
else{
return false;
}
}
else{
return false;
}
}
//**************************************************************************
//** findDriver
//**************************************************************************
/** Used to try to find a driver that corresponds to the vendor name, class
* name, or protocol.
*/
public static Driver findDriver(String driverName){
for (Driver driver : drivers){
if (driver.equals(driverName)) return driver;
}
if (driverName.contains(".")){
try{
return new Driver((java.sql.Driver) Class.forName(driverName).newInstance());
}
catch(Exception e){
e.printStackTrace();
}
}
return null;
}
//**************************************************************************
//** toString
//**************************************************************************
/** Returns the name the database/vendor. Same as getVendor()
*/
public String toString(){
return this.getVendor();
}
}
|
|