Service Virtualization

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

12-27-2017 01:28 PM

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]

Statistics
0 Favorited
3 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.