Forum:

JDBC and Relational Databases

configuring driver class name in init-parameter

Swetha Bhagavathula

Ranch Hand

Posts: 112

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

java.sql.SQLException: No suitable driver found for jdbc : oracle:thin: @localhost: 1521: orcl
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at mydbsrvtest.DBSrvtest.init(DBSrvtest.java:41)
.
.
.
.
.I am facing the above exception when I run my servlet program (in Netbeans 7.0).
I didn't configure driver class name as init parameter value as I am using ojdbc 6.jar.. Is it necssary to add driver class name..?
the following is my web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
 
 <servlet>
 <servlet-name>DBSrvtest</servlet-name>
 <servlet-class>mydbsrvtest.DBSrvtest</servlet-class>
 
 <init-param>
 
 <param-name>dburl</param-name>
 <param-value>jdbc:oracle:thin:@localhost:1521:orcl</param-value>
 </init-param>
 
 <init-param>
 <param-name>dbuser</param-name>
 <param-value>scott</param-value>
 </init-param>
 
 <init-param>
 <param-name>dbpwd</param-name>
 <param-value>tiger</param-value>
 </init-param>
 
 </servlet>
 
 
 <servlet-mapping>
 
 <servlet-name>DBSrvtest</servlet-name>
 <url-pattern>/DBSrvtest</url-pattern>
 </servlet-mapping>
 <session-config>
 <session-timeout>
 30
 </session-timeout>
 </session-config>
 
</web-app>

my html file code is:

and servlet program code is...:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package mydbsrvtest;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Swetha
 */
public class DBSrvtest extends HttpServlet {
    
    
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    public void init()
    {
        try {
//            get access to ServletConfig obj
            ServletConfig cg=getServletConfig();
//            read context param values from web.xml
         
            String s1=cg.getInitParameter("dburl");
            String s2=cg.getInitParameter("dbuser");            
             String s3=cg.getInitParameter("dbpwd");
//             create jdbc con obj
            
             con=DriverManager.getConnection(s1, s2, s3);
//             create jdbc PreapedStatement obj
             ps=con.prepareStatement("select ename,sal,hiredate from emp where empno=?");
             
                     
             
        } catch (Exception e) {
        e.printStackTrace();
        }
    }

@Override
 protected void doGet(HttpServletRequest request, HttpServletResponse response)
 throws ServletException, IOException {
 try {
// read for data from form page
 int no=Integer.parseInt(request.getParameter("teno"));
// get PrintWriter obj
 PrintWriter pw=response.getWriter();
// set response content type
 response.setContentType("text/html");
// write jdbc code..
// set value to parameter of the qry
 ps.setInt(1, no);
// execute the qry
 rs=ps.executeQuery();
// process the resultset
 if (rs.next()) {
 pw.println(" emp name is:</i."+rs.getString(1));
 pw.println(" emp name is:</i."+rs.getInt(2));
 pw.println(" emp name is:</i."+rs.getString(3));
 }
// close resultset obj
 rs.close();
// close strem obj
 pw.close();
 } catch (Exception e) {
 e.printStackTrace();
 }
 }

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
       doGet(request,response);
    }

}

please can anyone tell me where my mistake is..?

SCJP5

Tim McGuire

Ranch Hand

Posts: 820

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You need to specify it somewhere. Why do you think ojdbc6.jar would be an exception?

see: JDBCConnectionFAQ

Swetha Bhagavathula

Ranch Hand

Posts: 112

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Tim McGuire wrote:You need to specify it somewhere. Why do you think ojdbc6.jar would be an exception?

see: JDBCConnectionFAQ

i didn't mean ojdbc6.jar is an exception.what i mean is the driver class file is built in for oracle11g that contains ojdc6.jar with driver class file.so we need not specify it explicitely that is we need not load the class by using Class.forName("oracle.jdbc.driver.OracleDriver"); when i use type 4 jdbc driver.
so what i feel is what is the need of mentioning it in init parameters when i add jar file(that is ojdbc 6.jar) in libraries folder of my project (in IDE).If that is the case why am I facing the above error when i run my web application using glassfish 3.x server with net beans 7.0 ide.. please explain me and correct me

SCJP5

Tim McGuire

Ranch Hand

Posts: 820

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Swetha Bhagavathula wrote:what i mean is the driver class file is built in for oracle11g that contains ojdc6.jar with driver class file. so we need not specify it explicitely that is we need not load the class by using Class.forName("oracle.jdbc.driver.OracleDriver"); when i use type 4 jdbc driver.

The jar file may be there, but somewhere you need to tell your code to use that driver. This is proved by the exception you are getting.

Rob Spoor

Sheriff

Posts: 22817

132

I like...

posted 12 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

I don't like this code. You should declare your database connection as a resource, then retrieve it through JNDI. That way the container is in control of the connections, and may even use connection pooling.

SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions

Swetha Bhagavathula

Ranch Hand

Posts: 112

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Rob Spoor wrote:I don't like this code. You should declare your database connection as a resource, then retrieve it through JNDI. That way the container is in control of the connections, and may even use connection pooling.

can you please describe in detail. I am not aware of how to retrieve through JNDI.. please so that I can learn...

SCJP5

Rob Spoor

Sheriff

Posts: 22817

132

I like...

posted 12 years ago