• Loading...
This documentation refers to a previously released version of BMC Atrium Discovery (other versions).

JDBC Drivers

Skip to end of metadata
Go to start of metadata
Space Search

Searching TWF 7.3

Table of Contents

The following table provides an example JDBC URL for database targets. It also provides documentation and download URLs where available.

Database JDBC URL
Internet site
MySQL
jdbc:mysql://[host][,failoverhost...][:port]/[database]
    [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]


The following example URL connects to a MySQL server running on a host on IP address 192.168.0.100, port 3306, database name TIDEWAY_IMPORT, user fred and password password.
jdbc:mysql://192.168.0.100:3306/TIDEWAY_IMPORT?user=fred&password=password

Download: http://www.mysql.com/products/connector/
Documentation: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html

Postgres
jdbc:postgresql://host:port/database


The following example URL connects to a Postgres server running on a host on IP address 192.168.0.100, port 5432, and database name tidewaydatabase.
jdbc:postgresql://192.168.0.100:5432/tidewaydatabase

Download: http://jdbc.postgresql.org/download.html
Documentation: http://jdbc.postgresql.org/documentation/83/connect.html

Oracle For Oracle there are two possible connection styles:

Connection using service
jdbc:oracle:<drivertype>:@//<host>[:<port>]/<service>


The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and service tw_DB.
jdbc:oracle:thin:@//192.168.0.100:1521/tw_DB

Connection using SID

jdbc:oracle:<drivertype>:@<host>[:<port>]:<SID>


The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and SID tw100.
jdbc:oracle:thin:@192.168.0.100:1521:tw100

Download: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Documentation: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
See here for more information on setting up both styles in Foundation.

Ingres
jdbc:ingres://<host>:<port>/<database>;<attributes>


The following example URL connects to an Ingres server running on a host on IP address 192.168.0.100, port mnemonic II7, database name tidewaydatabase, user fred and password password.
jdbc:ingres://192.168.0.100:II7/tidewaydatabase;user=fred;password=password

Download: http://community.ingres.com/wiki/JDBC_Driver
Documentation:

http://community.ingres.com/wiki/Open_Office_How_To#Ingres_JDBC_URL_Connection_Information
Sybase
jdbc:sybase:Tds:<host_machine>[:<port>]/<database>


The following example URL connects to a Sybase server running on a host on IP address 192.168.0.100, port 6689, and database name tidewaydatabase.
jdbc:sybase:Tds:192.168.0.100:6689/tidewaydatabase

Documentation:

http://www.sybase.com/detail?id=1009876#sec2q2
MS SQL
jdbc:sqlserver://[serverName[\instanceName][:portNumber]]
    [;property=value[;property=value]]

The following example URL connects to an instance of MS SQL server called TDA running on a host on IP address 192.168.0.100, port 1433, user fred and password password.
jdbc:sqlserver://192.168.0.100\TDA:1433;User=fred;Password=password

Download: http://msdn.microsoft.com/en-us/data/aa937724.aspx
Documentation: http://msdn.microsoft.com/en-us/library/ms378428.aspx

JTDS
 jdbc:jtds:sqlserver://<server>[:<port>][/<database>][;<property>=<value>[;...]]


The following example URL connects using JTDS to an MS SQL server server running on a host on IP address 192.168.0.100, port 1433, database name TIDEWAY_IMPORT, instance TDA, user fred and password password.
jdbc:jtds:sqlserver://192.168.0.100:1433/TIDEWAY_IMPORT;
    instance=TDA;user=fred;password=password

Documentation: http://jtds.sourceforge.net/faq.html#urlFormat

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.