java/jdbc
authorTomas Zeman <tzeman@volny.cz>
Thu, 21 Jul 2011 14:32:22 +0200
changeset 13 f0e6a4b18ab8
parent 12 999aca5857e1
child 14 8ce422c2db6e
java/jdbc
java/jdbc
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/java/jdbc	Thu Jul 21 14:32:22 2011 +0200
@@ -0,0 +1,58 @@
+http://www.petefreitag.com/articles/jdbc_urls
+
+Guide to JDBC Driver URL's - MySQL, PostgreSQL, SQL Server, etc
+
+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
+
+List of URL properties
+
+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
+