Page History
...
Database connections can be used to view the contents of a database in a tree (schemas, tables and columns).
JDBC is an abstraction layer used by Java applications to connect to databases. The JDBC driver, created and provided by the database vendors, implement the generic API by defining the database specifics. This allows the Java application then to be database agnostic to some extent. The preferred connection method for most databases in WhereScape 3D is JDBC.
In WhereScape 3D, ODBC connections are established via the JDBC-ODBC bridge. ODBC data sources can be configured in the operating system using the standard ODBC manager.
Tutorial connections are a special type of JDBC connection used to connect to the tutorial databases shipped with WhereScape 3D.
Similarly, Repository connections are a special type of JDBC connection used to connect to the WhereScape 3D metadata repository.
Derby database connections can now be established to both embedded and multi-user databases.
Note | ||
---|---|---|
| ||
With the release of Java 8 the Sun JDBC-ODBC bridge has been removed. To continue supporting ODBC on Windows, WhereScape 3D now bundles a custom bridge driver called JdbcOdbc.dll which is copied into the chosen install location during the installation process. |
...
WhereScape 3D can also use files stored on a host machine as a data source by selecting Host as the connection type. There are also several different types of host connections:
...