Home › Common JDBC connection URLs

Common JDBC connection URLs 

Dr. Xi
Joined:
04/09/2007
Posts:
710

October 02, 2008 03:15:54    Last update: October 02, 2008 03:31:10
Common JDBC connection URLs

  1. SQL Server
    • Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
      URL: jdbc:microsoft:sqlserver://<host_name>:<port_number>;DatabaseName=<database_name>

    • Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver (SQL Server 2005)
      URL: jdbc:sqlserver://serverName\instance:port[;user=value][;password=value][;property=value]

    • Driver: net.sourceforge.jtds.jdbc.Driver
      URL: jdbc:jtds:sqlserver://<server>[:<port>][/<database>][;<property>=<value>[;...]]


  2. Oracle
    • Driver: oracle.jdbc.OracleDriver
      URL: jdbc:oracle:thin:@<host_name>:<port_number>:<database_name>


  3. DB2
    • Driver: COM.ibm.db2.jdbc.net.DB2Driver
      URL: jdbc:db2://<host_name>:<port_number>/<database_name>


  4. MySQL
    • Driver: org.gjt.mm.mysql.Driver
      URL: jdbc:mysql://<host_name>:<port_number>/<database_name>


  5. Sybase
    • Driver: com.sybase.jdbc2.jdbc.SybDriver
      URL: jdbc:sybase:Tds:<host_name>:<port_number>/<database_name>

    • Driver: net.sourceforge.jtds.jdbc.Driver
      URL: jdbc:jtds:sybase://<server>[:<port>][/<database>][;<property>=<value>[;...]]


Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com

Related Notes