//
you're reading...
Java, JDBC

JDBC Connections

1.Access

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn = DriverManager.getConnection( "dbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\database.mdb", sUsr, sPwd);

2.MySQL (http://www.mysql.com) mm.mysql-4.0.2-bin.jar

Class.forName("org.gjt.mm.mysql.Driver");
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );

or:

Class.forName("com.mysql.jdbc.Driver");
cn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/mydata?user=root&password=root");

3.Microsoft SQLServer (http://jtds.sourceforge.net)

Class.forName("net.sourceforge.jtds.jdbc.Driver");
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDBServerOrIP:1433/master", sUsr, sPwd );

4. Microsoft SQLServer (http://www.microsoft.com)

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDBServerOrIP:1433;databaseName=master", sUsr, sPwd );

5.oracle (http://www.oracle.com/ip/deploy/database/oracle10g/) classes14.zip

Class.forName("oracle.jdbc.driver.OracleDriver");
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDBServerOrIP:1521:ORCL", sUsr, sPwd );

6.Sybase (http://jtds.sourceforge.net) jconn2.jar

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDBServerOrIP:2638", sUsr, sPwd );
// (Default-Username/Password: "dba"/"sql")

7.ODBC

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd);

8.DB2

Class.forName("Com.ibm.db2.jdbc.net.DB2Driver");
String url="jdbc:db2://192.168.1.1:6789/SAMPLE"
cn = DriverManager.getConnection( url, sUsr, sPwd );

9.PostgreSQL (http://www.de.postgresql.org) pgjdbc2.jar

Class.forName("org.postgresql.Driver");
cn = DriverManager.getConnection( "jdbc:postgresql://MyDBServerOrIP/myDatabaseName", sUsr, sPwd );
Advertisements

About daviewning

I am an Oracle DBA

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: