aspose file tools*
The moose likes JDBC and the fly likes how to connect java with oracle rdb Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect java with oracle rdb" Watch "how to connect java with oracle rdb" New topic
Author

how to connect java with oracle rdb

freak_creak
Greenhorn

Joined: Feb 05, 2001
Posts: 2
hi
pleaz help me out ...iam not able to connect the driver that comes with ODBC32 icon in the control panel and am not even sure bout the syntax iam giving in the program...its like
class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc dbc:mydb","scott","tiger");
pleaze check this out
thanx
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements.
Thanks.

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
Hi,
Follow these steps.
1. Create an ODBC DSN - Using the Windows Control Panel, create an ODBC DSN (data source name) for the database.
2. Load the driver - In a JDBC program, one of the first things to do is to load the JDBC driver by calling the forName() static method of the Class class. forName() takes one string parameter: the name of the driver along with its package. For JavaSoft's JDBC-ODBC Bridge, this string is "sun.jdbc.odbc.JdbcOdbcDriver". Therefore, the call would look like:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
3. Establish a database connection
Once the JDBC driver loads, you can establish a connection to the database using the DriverManager.getConnection() method. This method's first argument is a string that contains the JDBC URL for the database. The second and third parameters are the user name and password, respectively.
A JDBC URL is formulated using the following pattern:
jdbc:<subprotocol>:<subname>
A connection to the database could be estd. in this manner:
Connection connection_ = DriverManager.getConnection("jdbcdbc:myDSN", "sa", "");
I hope you must have got it.
Parmeet


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
 
 
subject: how to connect java with oracle rdb