SQL.INI File - BBj

BBj still uses a SQL.INI file to define the data sources available to the user. However, the SQL.INI file has changed in its syntax, the information contained in the file, and the way that data sources are defined.

The following is a short list of terms that should be understood before configuring BBj for using SQL. The terminology now reflects the use of JDBC by BBj:

• JDBC – Java Database Connectivity. JDBC is an API specification that provides a standard interface for accessing databases. It is similar in purpose to ODBC, but its interface is object oriented and similar to some of the ODBC wrapper interfaces such as ADO, DAO, etc.

• JDBC Driver – A JDBC driver is a Java implementation of the JDBC API for a specific database management system. Each database vendor uses a different JDBC driver, usually developed by the vendor.

• JDBC Connection String (URL) – This is a connection string that is used to establish a connection to a JDBC data source. The string is referred to as a URL because it describes the location of a JDBC data source. The format of a JDBC connection string is specific to the particular JDBC driver being used.

• BBj JDBC Driver – This is the implementation of the JDBC API for accessing the BBj Data Server.