Showing posts with label jdbc. Show all posts
Showing posts with label jdbc. Show all posts

Thursday, March 12, 2009

Connecting To Sybase using JDBC

------------------CODE Snippets For Connecting to Sybase Database--------------------

Connecting to Sybase:

driverclassname = "com.sybase.jdbc2.jdbc.SybDriver";
dbprefix += "sybase:";

System.out.println("Loading jdbc driver: " + driverclassname);

Class.forName(driverclassname);

DBURL= "jdbc:sybase:::/"
DBURL = dbprefix + DBURL;

After that get the useid and password from user :

con = DriverManager.getConnection(DBURL, userid, password);

---------------------------------Connection Successful-------------------------------

Sunday, December 2, 2007

Connecting To Oracle using JDBC

--------------CODE Snippets For Connecting to Oracle Database-----------------------

Connecting to Oracle Using Thin Driver :

driverclassname = "oracle.jdbc.driver.OracleDriver";
dbprefix += "oracle:thin:";

System.out.println("Loading jdbc driver: " + driverclassname);

Class.forName(driverclassname);

DBURL = "jdbc:oracle:oci8:@::
or @::");

DBURL = dbprefix + DBURL;

After that get the useid and password from user :

con = DriverManager.getConnection(DBURL, userid, password);

---------------------------------Connection Successful-------------------------------