|
|
||||||||||||||||||||||
|
|||||||||||||||||||||||
|
In the instructions below, substitute your UW Net ID wherever you see "uwnetid". Last updated: 12 Sep 2007
JDBC for FirebirdJDBC is the Java Database Connectivity API, which allows a Java program to access data stored in tabular form, such as those in relational databases and spreadsheets. Typically, a database driver is written by the database vendor and it is implemented as a class which is loaded prior to using the JDBC methods it provides. The driver and supporting classes and information are typically packaged in a jar file. Firebird is a commercial-quality open-source database management system (DBMS) that supports JDBC. The official JDBC driver for Firebird is called JBird or JayBird. It is a "Class 4 JCA-JDBC Driver". A good but somewhat outdated source for documentation on how to use this driver can be found in the Jaybird FAQ.
JDBC Drivers in the LabsJDBC drivers for some DBMSes have been installed in the labs for your convenience. If they are not in a CLASSPATH environment variable, you will need to either set one or specify all classpaths as a parameter to the java command when running your application. For Firebird:
The Connection StringThe release notes list how to register the driver with the driver manager, which effectively loads the driver so you can create a connection to the database that the driver supports: A "connection string" is a URI for specifying how to access the database. The format for the connection string is well defined (an example is given later). However, various values are specific to the installation. An empty Firebird directory in which to store your databases has already been created for you on the Repository Server. You will need to create a database (using isql or a GUI-based tool), which is just a file in that directory. For example, after logging into the Repository Server (as, for example, user "johndoe"):
The connection string requires the host, port, database, database user, and database user password:
...and the restThe rest of the code is specific to the JDBC API, your database and table definitions, and the Firebird command set.
Change Log
Hours | Support Information | News | Policies | Emergencies |