This shows you the differences between two versions of the page.
dev:jdbc:home [2011/01/12 21:12] els |
dev:jdbc:home [2012/10/26 14:51] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | |||
- | ====== Development: JDBC Interface ====== | ||
- | |||
- | **[[dev:jdbc:home|Overview]]** | [[dev:jdbc:sample|Sample C# 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 using the following statement. | ||
- | |||
- | 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:sample|Next]]** | ||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:dev:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} | ||