JDBC Connection Strings

/* MySQL With MM JDBC */
jdbc driver and url
driver = "org.gjt.mm.mysql.Driver";
url = "jdbc:mysql://localhost/dbname";

/*Sybase jconnect2.jar */
url = "jdbc:sybase:Tds:host:port";
driver = "com.sybase.jdbc2.SybDriver";

/*Oracle JDBC Thin Driver classes12.zip */
url = "jdbc:oracle:thin:@host:port:sid";
driver = "oracle.jdbc.driver.OracleDriver";

/*Oracle OCI Driver classes12.zip*/
url = "jdbc:oracle:thin:@host:port:sid";
driver = "oracle.jdbc.driver.OracleDriver";

/* OpenBase OpenBaseJDBC.jar (download from www.openbase.com) */
url = "jdbcpenbase://host/database";
driver = "com.openbase.jdbc.ObDriver";

/* MySQL Connector/J from MySql (www.mysql.com)*/
url = "jdbc:mysql://host/database";
driver = "com.mysql.jdbc.Driver";

/*JDBC Drivers from Microsoft MSSQL 2000 */
url = "jdbc:microsoft:sqlserver://host:port";
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
/*JSQLConnect from JDBC Drivers from Microsoft MSSQL 2000*/
url = "jdbc:microsoft:sqlserver://host:port";
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
/*DB2 Universal JDBC Driver from IBM
jdbc classes: db2java.zip */
url = "jdbc:db2:host";
driver = "COM.ibm.db2.jdbc.app.DB2Driver";

/*DB2 Universal JDBC Driver from IBM type4
jdbc classes: db2jcc.jar*/
driver = "com.ibm.db2.jcc.DB2Driver"
url = "jdbc:db2://{host}:50000/{database name}"

/*DB2 Universal JDBC Driver from IBM
jdbc classes: db2java.zip */
url = "jdbc:db2://{host}:{port}/{database name}";
driver = "COM.ibm.db2.jdbc.net.DB2Driver";

/*OpenBase5.1 jdbc driver for neusoft
jdbc class: openBASE.jar*/
url = "jdbc:OpenBASE:database"
url = "jdbc:OpenBASE://host/database"
url = "jdbc:OpenBASE://host:port/database"
url = "jdbc:OpenBASE://host:port/database;user=username;password=pwd"
driver = "com.neusoft.OpenBASE.Driver"
( Nov 18 2005, 01:07:47 AM GMT-08:00 ) Permalink Comments [0]

Sunday August 14, 2005
Test Statement for database

In some case, we will want to check database connection is really ok, below sql statement maybe used.

*for MySQL use: select 1

*for PostgreSQL use: select now().

*for Apache Derby use: values 1.

*for HSQL use: call now().

*for SAP DB (MySQL MaxDB) use: select count(*) from versions.

*for Oracle use: select * from dual.

*for Firebird use: select * from rdb$types.

*for InstantDB use: set date format "yyyy/mm/dd".

*for Interbase use: select * from rdb$types.

*for Microsoft SQL server 2000 use: select 1.