pls chk your format for ur dbURL
it should looks like this
conn = DriverManager.getConnection
("jdbc:oracle:thin:@hostname:1521:orcl", "scott",
"tiger");
your hostname, portnumber = 1526 and your Oracle SID =
pdoc need to be specify
rgds
CT
--- Sridhar Srilatha
<[EMAIL PROTECTED]> wrote:
> 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
>
__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
___________________________________________________________________________
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
