 |
|
| JDBC Configuration Parameters | ||
| Here are examples of how you pass the JDB configuration parameters for databases that zeroCode supports. | ||
|
|
DB2 JDBC Configuration Parameters: |
|
||
 |
Database type: database.db.type = DB2 7.2.0 |
|
| |
Class name of the JDBC
driver: database.db.jdbcDriverClass = COM.ibm.db2.jdbc.net.DB2Driver |
|
| |
JDBC connect string: database.db.jdbcUrl = jdbc:db2://192.168.11.3:5432/sample |
|
| |
JDBC
properties (passed directly to the JDBC driver): database.db.jdbcProperties.server = 192.168.11.3 database.db.jdbcProperties.user = postgres database.db.jdbcProperties.password = postgres |
|
| |
Max number of
records to read in response to a single query. If a query returns more than this many records, an exception is thrown. database.db.maxRecsPerQuery = 25000 |
|
| |
Max number of entries in the
database cache: database.cacheSize = 500 |
|
| II. | PostgreSql JDBC Configuration Parameters: | |
| |
Database type: database.db.type =Postgre SQL 6.5 |
|
| |
Class name of the JDBC
driver: database.db.jdbcDriverClass = org.postgresql.Driver |
|
| |
JDBC connect string: database.db.jdbcUrl = jdbc:postgresql://192.168.11.3:5432/postgres |
|
| |
JDBC properties (passed
directly to the JDBC driver): database.db.jdbcProperties.server = 192.168.11.3 database.db.jdbcProperties.user = postgres database.db.jdbcProperties.password = |
|
| |
Max number of records to
read in response to a single query. If a query returns more than this many records, an exception is thrown. database.db.maxRecsPerQuery = 25000 |
|
| |
Max number of entries in the
database cache: database.cacheSize= 500 |
|
| III. | PointBase JDBC Configuration Parameters: | |
| |
Database type: PointBase 4.0 | |
| |
JDBC driver's class name: com.pointbase.jdbc.jdbcUniversalDriver | |
| |
JDBC connect string (also called the JDBC URL): jdbc:pointbase:server://192.168.11.21:9092/oes |
|
| |
Database server: Archimedes | |
| |
Database user name | |
| |
Database password | |