Hi,
I am trying to access an oracle database in an Unix Machine from my
machine. However I keep getting an error message.. the value of the
message is "oracle.jdbc.driver.OracleDriver" ( the code to instantiate
the driver an open the connection is below).
My specs are the following:
1) OS = Windows 98
2) Oracle Client Version = 8.0.5
3) Web Server = Sun's Java web Server (the server is running on my
machine)
4) Development tool = Metrowerks Codewarrior 4.0
5) JDK = 1.2
6) JSDk = 2.0
My Questions are:
1) Does the driver have to be on my machine or the machine in which the
database resides (I have installed Oracle again... and selected the
option of installing the JDBC drivers... so I know they are there... or
is there any other way in which I can double check?
2) Is there something that I have to do with codewarrior? I was
reading that I had to add the Classes111 file to my Classpath which I
had done but nothing seems to work.
Please... give me any pointers... Thanks in advance.
try {
//Load(and therefore register the oracle driver
Class.forName("oracle.jdbc.driver.OracleDriver");
// Get a connection to the database
con =
DriverManager.getConnection("jdbc:oracle:thin:mydatabase","xx","xxxx");
// Create a statement object
stmt = con.createStatement();
// Execute and SQL query and get a resultSet
rs = stmt.executeQuery("SELECT NAME,LOGIN FROM MYUSERS");
Thanks.
Felix.
_____________________________________________________
Felix Guerrero
Multimedia Technologist
ITS (Information Technology Services)
IACC Building Room 246
North Dakota State University
Fargo, ND 58105
Ph. Office: (701) 231 6284
Fax: (701) 231 8541
Home: 701 280-1995
____________________________________________________
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
