Tech Tips: SQL Database Connection (JDBC) Driver and Connect String to Use

Document created by MarcyNunns Employee on Dec 27, 2017Last modified by MarcyNunns Employee on Dec 27, 2017
Version 2Show Document
  • View in full screen mode

Connection Info Oracle (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)

Select one of the two connection URLs depending on usage of SID or SERVICE

    JDBC Driver: oracle.jdbc.driver.OracleDriver
 Connect String: jdbc:oracle:thin:@[HOST]:1521:[SID]
                 jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE


Connection Info MS SQL Server (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)

   JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServer
Connect String: jdbc:sqlserver://[SERVER]:[PORT];databaseName=[DATABASENAME]

 
Connection Info DB2 (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)

   JDBC Driver: com.ibm.db2.jcc.DB2Driver
Connect String: jdbc:db2://[HOSTNAME]:[PORT]/[DATABASENAME]:progressiveStreaming=2;

 

Connection Info MySQL (DevTest does not deliver this connection jar, refer to link https://dev.mysql.com/downloads/connector/j/ to get jar)

   JDBC Driver: com.mysql.jdbc.Driver
Connect String: jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]


Connection Info Derby ((DevTest delivers this connection jar in LISA_HOME/lib/shared folder)

   JDBC Driver: org.apache.derby.jdbc.ClientDriver
Connect String: jdbc:derby://[SERVER]:[PORT]/[DATABASE]

Attachments

    Outcomes