Srilatha,
I think Oracle drivers are missing in your CLASSPATH. Check your classpath...
Thanks,
~Hemu Naidu
-----Original Message-----
From: Sridhar Srilatha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 3:49 PM
To: [EMAIL PROTECTED]
Subject: java.sql.SQLException: No suitable driver error in my servlet
program
D:\MQWeb>java DBTest
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MoundDBConnection.getDBStatement(MoundDBConnection.java:12)
at DBTest.main(DBTest.java:13)
SQL Statement is NULL
It is a catch
there is exceptionnull
I have this specified in separate file where pdoc is the db instance and
mound is the db server
public java.sql.Statement getDBStatement() {
String dbUrl
= "jdbc:oracle:thin:ss44530/ss44530@mound:1526:pdoc";
String user = "ss44530";
String password = "ss44530";
java.sql.Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(
dbUrl,
user,
password );
stmt = con.createStatement();
} catch(Exception e) { e.printStackTrace(); }
return stmt;
}
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************
___________________________________________________________________________
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
