Pete's Guide to JDBC Driver URLs
MySQL (Connector/J)
Driver Class: com.mysql.jdbc.Driver
Default Port: 3306
JDBC URL
jdbc:mysql://[host][,failoverhost...][:port]/[database] jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...
PostgreSQL
Driver Class: org.postgresql.Driver
Default Port: 5432
JDBC URL
jdbc:postgresql:database jdbc:postgresql://host/database jdbc:postgresql://host:port/database jdbc:postgresql://host:port/database?user=userName&password=pass jdbc:postgresql://host:port/database?charSet=LATIN1&compatible=7.2
Microsoft SQL Server (jTDS Driver)
Driver Class: net.sourceforge.jtds.jdbc.Driver
Default Port: 1433
JDBC URL
jdbc:jtds:sqlserver://server[:port][/database][;property=value[;...]] jdbc:jtds:sybase://server[:port][/database][;property=value[;...]] jdbc:jtds:sqlserver://server/db;user=userName;password=password
Microsoft SQL Server (Microsoft Driver)
Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
Default Port: 1433
JDBC URL
jdbc:microsoft:sqlserver://host:port;databasename=name;user=yourUser;password=yourPwd
Questions, Comments, Additions: Contact Me