Database Connection |
  
|
Database Connection |
|
Configure Database connections necessary for querying Tables (database tables) and providing Lookup functionality.
Note: Prerequisite for a working Database connection is installation of a JDBC driver on the application server respectively when using JDBC-ODBC-Bridges the configuration of a System DSN on the application server (Windows OS only).
Note: On 64Bit Windows OS two different System DSN configuration applications are provided.
•The configuration application linked in the windows start menu (respectively administrative tools) is the odbcad32.exe located in "c:\windows\system32" folder. This is the application to set up 64Bit System DSN. If you use the Java and Tomcat 64Bit components, you have to define your System DSN here. Most ODBC drivers for 64Bit are currently not a part of a default OS installation. Search the database provider websites for detailed information. E.g. for a 64Bit ODBC driver for a Microsoft Access database see http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d. Note that installation may cause compatibility problems with installed 32Bit drivers. System DSN entries made in the 32Bit configuration application (see below) may be affected too. See MS knowledge base for details.
•The configuration application located in "c:\windows\syswow64" folder (also called odbcad32.exe) is the application to set up 32Bit System DSN. If you use the Java and Tomcat 32Bit components you have to define your System DSN here.
After configuration Apache Tomcat has to be restarted.
Note: JDBC drivers are available for almost any database. Search the database provider websites for detailed information and JDBC driver download. The most important databases like ORACLE or Microsoft SQL Server provide JDBC driver setups for free. In case that no JDBC driver is available for a specific database, then it is possible to use the so called JDBC-ODBC bridge implemented by SUN in the SUN Java Virtual Machine (JVM). Using the JDBC-ODBC bridge it is possible to access the database from JAVA using an existing OBDC data source.
Note that with WebOffice 10 R3 there is no support for SQL Server 2000 driver. You can use the downward compatible SQL Server 2008R2 driver and syntax for connecting to a SQL Server 2000.
Database connection - General category
Below you find a detailed description of the Database connection properties.
Property |
Description |
DB-Connection parameter |
Database Connection information is needed for functions like advanced search with listvalues respectively for hierarchical search or for being able to create the quick search index. Note: Prerequisite for a working database connection is installation of a JDBC driver on the application server respectively when using JDBC-ODBC-Bridges the configuration of a System-DSN on the application server (windows only). •for ORACLE: jdbc:oracle:thin:@[HOST][:PORT]:SID or jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE •for MS SQL Server 2005 and 2008 (for default SQL Server configuration with dynamic port): jdbc:sqlserver://hostsde;DatabaseName=MyDatabase •for MS SQL Server 2005 and 2008 (for recommended SQL Server configuration with decidedly configured port): jdbc:sqlserver://hostsde:1433;DatabaseName=MyDatabase •for ODBC data source: jdbc:odbc:myDSN •for MySQL (MySQL Version 5.1.5): com.mysql.jdbc.Driver: Driver must be installed •for Postgres: jdbc:postgresql://hostsde:5432/mydatabase Note: The necessary Database connection parameter for successfully connecting to a database may vary because it depends on the actual installation and configuration. Refer to the JDBC driver documentation of the database and/or driver provider for details. |
DB user name |
Database user name for read access to the database. |
Password |
Password for the database user. |
Connection Pool |
Optional connection pool to be used. If configured then DB driver configuration is ignored. -'Oracle OCI' for ORACLE (pooled connections) oracle.jdbc.pool.OracleOCIConnectionPool: Suitable DB-Driver must be installed before -'Oracle Thin' for ORACLE (pooled connections) oracle.jdbc.pool.OracleDataSource: Has advantages when using 'multiplexed connections'; Suitable DB-Driver must be installed before (ojdbc14.jar) Note: It may be necessary to install specific DB components on the server to use connection pooling. |
Connection Pool max size |
Optional: Connection Pool max size |
Connection pool increments |
Optional: Connection Pool increment |
Idle time [s] |
Optional: Idle time in seconds, when an unused connection gets closed. |
Max. Statements |
Optional: Max. Statements cached |
Database connection - General category