Table of Contents

About

JDBC is using URL to locate the database schema.

Database URLs are strings that you specify for the value of the url property of the DataSource object.

You can add to all JDBC URL, the user and the password in the query part. Example 

jdbc:subProtocol://hostname;user=[userName];password=[userPassword];DatabaseName=[Databasename]

The userName and the userPassword must be encoded as all query properties.

URL

The getConnection function gives the following format for the beginning of the string. 

jdbc:subprotocol:subname

The format of a url is DB-specific but many follows the following syntax: 

jdbc:subprotocol:uri
# ie 
jdbc:subprotocol:scheme://autority....

where:

Default Values

Hyperion

Microsoft SQL Server 2005

  • driver= hyperion.jdbc.sqlserver.SQLServerDriver
  • url= jdbc:hyperion:sqlserver://[hostname]:[port];DatabaseName=[Databasename]

Microsoft SQL Server 2000

  • driver= hyperion.jdbc.sqlserver.SQLServerDriver
  • url= jdbc:hyperion:sqlserver://[hostname]:[port];DatabaseName=[Databasename]

IBM Db2 Universal Database version 9

  • driver= hyperion.jdbc.db2.DB2Driver
  • url= jdbc:hyperion:db2://[host]:[port];DatabaseName=[dbname]

IBM Db2 Universal Database version 8

  • driver= hyperion.jdbc.db2.DB2Driver
  • url= jdbc:hyperion:db2://[host]:[port];DatabaseName=[dbname]

Sybase Adaptive Server Enterprise 15

  • driver= hyperion.jdbc.sybase.SybaseDriver
  • url= jdbc:sybase:Tds:[host]:[port]

DB2

  • jar: db2java.zip

Odbc Bridge

see JDBC - ODBC bridge

  • Driver Class= sun.jdbc.odbc.JdbcOdbcDriver
  • Jdbc Url= jdbc:odbc:[dsn]

Oracle

Oracle Maven Repository

Oracle 11g

  • Driver Class= oracle.jdbc.OracleDriver
  • url= jdbc:oracle:thin:@[host]:[port]:[sid] (connection by SID is deprecated)
  • url= jdbc:oracle:thin:@[host]:[port]/[servicename]
  • jar: ojdbc6.jar

The colon “:” implies SID, the slash “/” implies service_name.

Example: 

jdbc:oracle:thin:scott/tiger@myhost:1521:mysid

Oracle 10g

  • driver= oracle.jdbc.OracleDriver
  • url= jdbc:oracle:thin:@[host]:[port]:[sid]

Oracle 9i

  • driver= oracle.jdbc.OracleDriver
  • url= jdbc:oracle:thin:@[host]:[port]:[sid]

Oracle BI Server (OBIEE)

  • driver= oracle.bi.jdbc.AnaJdbcDriver
  • url= jdbc:oraclebi://[host]:[port]/ (default: jdbc:oraclebi://hostName:9703/ )

With user: jdbc:oraclebi://localhost:9703/user=Nico;password=********;

Others parameters:

  • SECONDARYCCSPORT=9706
  • MAXRECONNECTATTEMPTS=3
  • TRUSTANYSERVER=true
  • PRIMARYCCSPORT=9706
  • MAXRPCCLIENTCREATEATTEMPTS=3
  • USER=ngerarlocal
  • HEARTBEATINTERVAL=60
  • MAXHEARTBEATATTEMPTS=3
  • MAXRPCCLIENTCOUNT=100
  • SSL=false
  • TRUSTSTOREPASSWORD=***
  • PASSWORD=***
  • SECONDARYCCS=
  • PORT=9703
  • CATALOG=
  • HOST=localhost
  • PRIMARYCCS=
  • SSLKEYSTOREPASSWORD=***
  • RPCCLIENTEXPIRATIONTIME=60

SQL Server

2008 R2

  • driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
  • url = jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

Example: 

jdbc:sqlserver://localhost;user=MyUserName;password=*****;databaseName=AdventureWorks;
  • jar: sqljdbc.jar

Sybase IQ 12

  • driver= om.sybase.jdbc3.jdbc.SybDriver
  • url= jdbc:sybase:Tds:[host]:[port]?ServiceName=[database_name]

Informix IDS 10.0

  • driver= com.informix.jdbc.IfxDriver
  • url= jdbc:informix-sqli://[host_name]:[port_number]/[database_name]:INFORMIXSERVER=[server_name]

Informix IDS 9.4

  • driver= com.informix.jdbc.IfxDriver
  • url= jdbc:informix-sqli://[host_name]:[port_number]/[database_name]:INFORMIXSERVER=[server_name]

Teradata

  • jar: terajdbc4.jar, log4j.jar, teradata.jar, tdgssjava.jar, tdgssconfig.jar

NCR Teradata 12.0

  • driver= com.ncr.teradata.TeraDriver
  • url= jdbc:teradata://[DatabaseServerName]

NCR Teradata V2R6.2

  • driver= com.ncr.teradata.TeraDriver
  • url= jdbc:teradata://[DatabaseServerName]

NCR Teradata V2R5.1

  • driver= com.ncr.teradata.TeraDriver
  • url= jdbc:teradata://[DatabaseServerName]

MySQL

MySQL 5.0

  • driver= com.mysql.jdbc.Driver
  • url= jdbc:mysql://[host]:[port]/[database]
  • jar: Mysql-connector-java*.jar

MySQL 4.1

  • driver= com.mysql.jdbc.Driver
  • url= jdbc:mysql://[host]:[port]/[database]

Netezza 4.0

  • driver= org.netezza.Driver
  • url= jdbc:netezza://[host]:[port]/[database]

TimesTen

The driver= com.timesten.jdbc.TimesTenDriver. The jar driver is located int the TIMESTEN_BASE\lib directory. The jar file ttjdbc5.jar is for the Java SDK version 5 and ttjdbc6.jar is for version 6. (ttjdbc5.jar, ttjdbc6.jar)

URL: 

jdbc:timesten:{direct|client}:dsn=DSNname;[DSNattributes;]

Example: 

jdbc:timesten:client:dsn=TT_DATA_STORE;UID=login;Pwd=pwd;SQLQUERYTIMEOUT=0

RPAS 13.0.1 int1

  • driver= jdbc.sql.oadriver
  • url= jdbc:OpenRDA:[DSN Name]

Java DB - Derby

Embedded

For the Embedded configuration

  • Driver: org.apache.derby.jdbc.EmbeddedDriver.
  • URL: jdbc:derby:databaseName;URLAttributes where:
    • databaseName. The name of the database that you want to connect to
    • URLAttributes. One or more of the supported attributes of the database connection URL, such as ;territory=ll_CC or ;create=true.

Client/server

For the client/server communication:

  • Driver: org.apache.derby.jdbc.ClientDriver.
  • URL: jdbc:derby://server[:port]/databaseName[;URLAttributes=value[;...]] where:
    • the server and port specify the host name (or IP address) and port number where the server is listening for requests
    • databaseName is the name of the database you want to connect to.
    • URLAttributes can be either Derby embedded or network client attributes.

Documentation / Reference