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 |
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 |
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
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
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 |
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 |
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 |
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 |
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
|