Java - JDBC Driver for MySQL, PostgreSQL, SQL Server and Oracle

MySQL (Connector/J):

Driver: com.mysql.jdbc.Driver (http://www.mysql.com/products/connector/j/)
Default port: 3306
JDBC Url:
jdbc:mysql://[host][:port]/[database] jdbc:mysql://[host][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...

PostgreSQL

Driver: org.postgresql.Driver (http://jdbc.postgresql.org/)
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

Microsoft SQL Server (jTDS Driver)


Driver: net.sourceforge.jtds.jdbc.Driver (http://jtds.sourceforge.net/)
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/database;user=UserName;password=password

Microsoft SQL Server (Microsoft Driver)

Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
(http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en) Default Port: 1433

JDBC URL:
jdbc:microsoft:sqlserver://host:port;databasename=name;user=UserName;password=Password

Oracle
Driver: oracle.jdbc.driver.OracleDriver
Default port: 1521
JDBC Url:
jdbc:oracle:thin:@host:port:database
jdbc:oracle:oci8:@host:port:database

Comments