MySQL JDBC Driver and URL Information
|
Listed below are connection examples for MySQL: MySQL Connector/J Driver DRIVER CLASS: com.mysql.jdbc.Driver DRIVER LOCATION: Simply provide the location of the jar file containing the MySQL JDBC Drivers. These drivers can be obtained from MySQL. See the MySQL web site for more information. Example: mysql-connector-java-3.1.11-bin.jar JDBC URL FORMAT: jdbc:mysql://<host>:<port>/<database_name> The default port for MySQL is 3306. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted. ADDITIONAL JDBC CONNECTION PROPERTIES Additional connection properties can be appended to the JDBC URL. The format to add connection properties is the following: jdbc:mysql://<host>:<port>/<database_name>?property1=value1&property2=value2 Here are examples of connection properties for the MySQL Connector/J driver. Consult your driver documentation for more examples of connection properties. connectTimeout (Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to 0.) socketTimeout (Timeout on network socket operations (0, the default means no timeout).) autoReconnect (Should the driver try to re-establish stale and/or dead connections.) Examples: jdbc:mysql://neptune.acme.com:3306/test jdbc:mysql://127.0.0.1:3306/test jdbc:mysql://localhost:3306/mysql?connectTimeout=0&socketTimeout=0&autoReconnect=true |
