Driver classes & Database URLs for JDBC Drivers

In this article we will see different Driver class & Database URL pattern(syntax) used with JDBC driver in JAVA. We will use them with JMeter under JDBC Connection Configuration config element.
See my SQL testing post for know more about SQL testing.

Database Name : MySQL
Driver class: com.mysql.jdbc.Driver
Database URL :jdbc:mysql://host[:port]/dbname

Database Name : PostgreSQL
Driver class: org.postgresql.Driver
Database URL : jdbc:postgresql:{dbname}

Database Name : Oracle
Driver class: oracle.jdbc.OracleDriver
Database URL : jdbc:oracle:thin:@//host:port/service
OR
jdbc:oracle:thin:@(description=(address=(host={mc-name})(protocol=tcp)(port={port-no}))(connect_data=(sid={sid})))

Database Name : Ingres (2006)
Driver class: ingres.jdbc.IngresDriver
Database URL : jdbc:ingres://host:port/db[;attr=value]

Database Name : Apache Derby
Driver class: org.apache.derby.jdbc.ClientDriver
Database URL : jdbc:derby://server[:port]/databaseName[;URLAttributes=value[;...]]

Database Name : SQL Server (MS JDBC driver)
Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Database URL : jdbc:sqlserver://host:port;DatabaseName=[dbname]
OR 
 jdbc:sqlserver://host:port;instanceName=[sqlexpress];DatabaseName=[dbname]


Database Name : SQL Server (Sourgeforge Driver)
Driver class: net.sourceforge.jtds.jdbc.Driver
Database URL : jdbc:jtds:sqlserver:// [server name or ip] / [db name]

Database Name : MS Acces [ODBC bridged]
Driver class: sun.jdbc.odbc.JdbcOdbcDriver
Database URL : jdbc:odbc:dsn", "", ""

Database Name : MS Acces( StelsMDB)
Driver class: jstels.jdbc.mdb.MDBDriver2
Database URL : jdbc:jstels:mdb:
For more idea, see this

Database Name : cassandra-jdbc
Driver class:org.apache.cassandra.cql.jdbc.CassandraDriver
Database URL : jdbc:cassandra://host:port/dbName;

Database Name : SqlLite
Driver class: org.sqlite.JDBC
Database URL : jdbc:sqlite:sample.db


This is all from the jmeter doc. I mention separately to help other in finding them. 
I will try to increase more driver syntax incrementally.

Thanks ...:)

2 comments:

  1. can anyone please tell me where can i find jdbc driver for DynamoDB?

    ReplyDelete
    Replies
    1. If you are referring Amazon's Dynamic DB, then here it is http://www.rssbus.com/jdbc/amazon-dynamodb/

      Delete