This shows you the differences between two versions of the page.
|
dev:jdbc:home [2011/01/12 20:47] els |
dev:jdbc:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Development: JDBC Interface ====== | ||
| - | |||
| - | **[[dev:jdbc:home|Overview]]** | [[dev:jdbc:datasources|JDBC Datasources]] | [[dev:jdbc:sample|Sample Program]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | |||
| - | ===== Overview ===== | ||
| - | |||
| - | The Omnidex JDBC Driver is a standard-compliant JDBC driver that provides Java access to Omnidex Environments. The Omnidex JDBC Driver is supported on Microsoft Windows and Linux operating systems. | ||
| - | |||
| - | ==== The Omnidex JDBC Classes ===== | ||
| - | |||
| - | The Omnidex JDBC class files are stored in a jar file named Omnidex.jar, which is located in the bin subdirectory of the Omnidex home directory on a Microsoft Windows computer (%OMNIDEX_HOME%/bin/Omnidex.jar), or the lib directory on a Linux computer ($OMNIDEX_HOME/lib/Omnidex.jar). | ||
| - | |||
| - | JDBC classes require that you import java.sql into the Java application. | ||
| - | |||
| - | import java.sql.*; | ||
| - | |||
| - | The Omnidex JDBC driver requires that you load it with the java.sql.DriverManager. | ||
| - | |||
| - | Class.forName("omnidex.jdbc.OdxJDBCDriver"); | ||
| - | |||
| - | ==== Connecting to an Omnidex Environment ==== | ||
| - | |||
| - | Connecting to an Omnidex Environment File in JDBC simply requires referencing the Omnidex connection string in the call to DriverManager.getConnection: | ||
| - | |||
| - | Connection conn = | ||
| - | DriverManager.getConnection( "jdbc:omnidex:[server1:7555]C:\\class\\simple.xml"); | ||
| - | |||
| - | It is also possible to reference a File DSN in the call to DriverManager.getConnection. File DSN's are typically used with ODBC applications, but can be useful for externalizing the connection string. Consult the [[dev:odbc:filedsn| ODBC File DSN Syntax Specification]] for instructions to build a File Datasource. | ||
| - | |||
| - | Connection conn = | ||
| - | DriverManager.getConnection( "jdbc:omnidex:simple.dsn"); | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[dev:jdbc:datasources|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:dev:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||