Jaybird 2.2.11 for Java 8 / JDBC 4.2, zip kit

/** * Original version of this file was part of InterClient 2.01 examples * * Copyright InterBase Software Corporation, 1998. Written by * com.inprise.interbase.interclient.r&d.PaulOstler :-) * * Code was modified by Roman Rokytskyy to show that Firebird JCA-JDBC driver * does not introduce additional complexity in normal driver usage scenario. * * A small application to demonstrate basic, but not necessarily simple, JDBC * features. * * Note: you will need to hardwire the path to your copy of employee.fdb as well * as supply a user/password in the code below at the beginning of method * main(). */ public class DriverExample { private static final String URL_DEFAULT = "jdbc:firebirdsql://localhost:3050/c:/database/employee.fdb"; private static final String USER_DEFAULT = "sysdba"; private static final String PASSWORD_DEFAULT = "masterkey"; private static final int REGISTER_CLASS_FOR_NAME = 1; private static final int REGISTER_PROPERTIES = 2; private static final int REGISTER_JDBC4 = 3; private static final int CONNECT_DRIVERMANAGER = 1; private static final int CONNECT_DRIVER = 2; /** * Make a connection to an employee.fdb on your local machine, and * demonstrate basic JDBC features. * <p> * On the commandline a JDBC-url, username and password can be passed, * otherwise defaults are used. */ public static void main(String args[]) throws Exception { /* If localhost is not recognized, try using your local machine's name * or the loopback IP address 127.0.0.1 in place of localhost. * * The Firebird JDBC driver recognizes a number of different URLs: * * Pure Java / Type 4: * jdbc:firebirdsql://<host>[:<port>]/<alias-or-path-to-db> * NOTE: On linux <alias-or-path-to-db> MUST include the root / * Alternative URL format: * jdbc:firebirdsql:<host>[/port]:<alias-or-path-to-db> * Alternative prefix: * jdbc:firebirdsql:java: * Prefixes specifically for OpenOffice / LibreOffice Base: * jdbc:firebirdsql:oo: * jdbc:firebird:oo: * * Native / Type 2: * jdbc:firebirdsql:native://<host>[:<port>]/<alias-or-path-to-db> * Alternative URL format: * jdbc:firebirdsql:native:<host[/port]:<alias-or-path-to-db> * * Native / Type 2 local connection: * jdbc:firebirdsql:local:<alias-or-path-to-db> * * Firebird Embedded: * jdbc:firebirdsql:embedded:alias-or-path-to-db> * * The URL can be extended with properties to configure the connection * (similar to a HTTP query string) by adding to the end of the string: * ?<property>[=<value>](&<property>[=<value>])* * * Examples: * Connecting to employee.fdb on localhost using the type4 driver with UTF8: * jdbc:firebirdsql://localhost/C:/database/employee.fdb?lc_ctype=UTF8 * * Connecting to dialect1.fdb using native with WIN1252 and resultset tracking disabled: * jdbc:firebirdsql://localhost/C:/database/dialect1.fdb?dialect=1&lc_ctype=WIN1252&noResultSetTracking */ String databaseURL = args.length == 0 ? URL_DEFAULT : args[0]; String user = args.length < 2 ? USER_DEFAULT : args[1]; String password = args.length < 3 ? PASSWORD_DEFAULT : args[2]; /* Here are the JDBC objects we're going to work with. * We're defining them outside the scope of the try block because * they need to be visible in a finally clause which will be used * to close everything when we are done. */ java.sql.Driver driver = null; java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rs = null; try { /* Before a JDBC driver can be used, it must have been * registered with the DriverManager. * * Demonstrate the different methods to register the * Firebird JCA-JDBC driver with the driver manager */ int registrationAlternative = REGISTER_CLASS_FOR_NAME; switch (registrationAlternative) { case REGISTER_CLASS_FOR_NAME: /* For JDBC 3.0 and earlier, the standard method of registering * the driver is by loading the class. * * Class.forName() instructs the java class loader to load * and initialize a class. As part of the class initialization * any static clauses associated with the class are executed. * * Every driver class is required by the jdbc specification to * create an instance of itself and register that instance with * the DriverManager when the driver class is loaded by the java * classloader (this is done via a static clause associated with * the driver class). * * Notice that the driver name could have been supplied * dynamically, so that an application is not hardwired to any * particular driver as would be the case if a driver constructor * were used, eg. new org.firebirdsql.jdbc.FBDriver(). */ try { Class.forName("org.firebirdsql.jdbc.FBDriver"); } catch (java.lang.ClassNotFoundException e) { // A call to Class.forName() forces us to consider this exception System.out.println("Firebird JCA-JDBC driver not found in class path"); System.out.println(e.getMessage()); return; } break; case REGISTER_PROPERTIES: /* Add the Firebird JCA-JDBC driver name to your system's * jdbc.drivers property list. * * The driver manager will load drivers from this system * property list. */ java.util.Properties sysProps = System.getProperties(); StringBuffer drivers = new StringBuffer("org.firebirdsql.jdbc.FBDriver"); String oldDrivers = sysProps.getProperty("jdbc.drivers"); if (oldDrivers != null) drivers.append(":" + oldDrivers); sysProps.put("jdbc.drivers", drivers.toString()); System.setProperties(sysProps); break; case REGISTER_JDBC4: /* From JDBC 4.0 (Java 6), drivers are required to have a file * /META-INF/services/java.sql.Driver with the * classname(s) of the drivers. * * The DriverManager will automatically load all drivers, * so there is no need to explicitly load the driver. */ break; } /* At this point the driver should be registered with the DriverManager. * Try to find the registered driver that recognizes Firebird URLs */ try { // We pass the entire database URL, but we could just pass "jdbc:firebirdsql:" driver = java.sql.DriverManager.getDriver(databaseURL); System.out.println("Firebird JCA-JDBC driver version " + driver.getMajorVersion() + "." + driver.getMinorVersion() + " registered with driver manager."); } catch (java.sql.SQLException e) { System.out.println("Unable to find Firebird JCA-JDBC driver among the registered drivers."); showSQLException(e); return; } /* Now that Firebird