1 http://www.petefreitag.com/articles/jdbc_urls

     2 

     3 Guide to JDBC Driver URL's - MySQL, PostgreSQL, SQL Server, etc

     4 

     5 MySQL (Connector/J)

     6 ===================

     7 

     8 Driver Class: com.mysql.jdbc.Driver

     9 

    10 Default Port: 3306

    11 

    12 JDBC URL

    13 

    14 jdbc:mysql://[host][,failoverhost...][:port]/[database]

    15 jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...

    16 

    17 

    18 PostgreSQL

    19 ==========

    20 

    21 Driver Class: org.postgresql.Driver

    22 

    23 Default Port: 5432

    24 

    25 JDBC URL

    26 

    27     jdbc:postgresql:database

    28     jdbc:postgresql://host/database

    29     jdbc:postgresql://host:port/database

    30     jdbc:postgresql://host:port/database?user=userName&password=pass

    31     jdbc:postgresql://host:port/database?charSet=LATIN1&compatible=7.2

    32 

    33 Microsoft SQL Server (jTDS Driver)

    34 ==================================

    35 

    36 Driver Class: net.sourceforge.jtds.jdbc.Driver

    37 

    38 Default Port: 1433

    39 

    40 JDBC URL

    41 

    42     jdbc:jtds:sqlserver://server[:port][/database][;property=value[;...]]

    43     jdbc:jtds:sybase://server[:port][/database][;property=value[;...]]

    44     jdbc:jtds:sqlserver://server/db;user=userName;password=password

    45 

    46 List of URL properties

    47 

    48 Microsoft SQL Server (Microsoft Driver)

    49 =======================================

    50 

    51 Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver

    52 

    53 Default Port: 1433

    54 

    55 JDBC URL

    56 

    57     jdbc:microsoft:sqlserver://host:port;databasename=name;user=yourUser;password=yourPwd

    58