User`s guide

database
7-53
Database JDBC Driver Name and Database URL Example Syntax
Database URL: jdbc:sqlserver://
localhost:port;database=databasename
MySQL JDBC driver: twz1.jdbc.mysql.jdbcMysqlDriver
Database URL: jdbc:z1MySQL://natasha:3306/metrics
JDBC driver: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://devmetrics.mrkps.com/testing
To insert or select characters with encodings that are not default,
append the string useUnicode=true&characterEncoding=... to the
URL, where ... is any valid MySQL character encoding. For example,
useUnicode=true&characterEncoding=utf8.
Oracle oci7drivers JDBC driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:oci7:@rex
Oracle oci8drivers JDBC driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:oci8:@111.222.333.44:1521:
Database URL: jdbc:oracle:oci8:@frug
Oracle 10
Connections
with JDBC (Thin
drivers)
JDBC driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:
Oracle
Thindrivers
JDBC driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:@144.212.123.24:1822:
Database URL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS
= (PROTOCOL = TCP)(HOST = ServerName)(PORT = 1234))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
dbname) ) )
PostgreSQL JDBC driver: org.postgresql.Driver
Database URL: jdbc:postgresql://host:port/database