Errror while connecting

I'm new to database connectivity through beans

when i use the follwing code in my jsp file

====================================

<%@ page language="Java" import="java.sql.*" %>

<jsp:useBean id="db" scope="request" class="sqlbean.DbBean" />

<jsp:setProperty name="db" property="*" /> \=============================

I get the follwing error

====================================================

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: /connecttest.jsp(7,0) The value for the useBean class attribute DbBean is invalid.

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: /connecttest.jsp(7,0) The value for the useBean class attribute DbBean is invalid.

org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)

org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:405)

org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:146)

org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1174)

org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1116)

org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)

org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213)

org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2219)

org.apache.jasper.compiler.Node$Root.accept(Node.java:456)

org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)

org.apache.jasper.compiler.Generator.generate(Generator.java:3304)

org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:198)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:295)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)

org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:303)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

=======================================

i have a class DbBean.java in package sqlbean

Please help in explaining why this error is happening

[2910 byte] By [rohit_sharma76a] at [2007-11-27 6:50:20]
# 1

please see the DB class

package sqlbean;

import java.sql.*;

import java.io.*;

public class DbBean {

String dbURL = "jdbc:microsoft:sqlserver://192.168.0.50:1433;DatabaseName=cns";

String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

private Connection dbCon;

public DbBean(){

super();

}

public boolean connect() throws ClassNotFoundException,SQLException{

Class.forName(dbDriver);

dbCon = DriverManager.getConnection(dbURL,"sa","sasa_01");

return true;

}

public void close() throws SQLException{

dbCon.close();

}

public ResultSet execSQL(String sql) throws SQLException{

Statement s = dbCon.createStatement();

ResultSet r = s.executeQuery(sql);

return (r == null) ? null : r;

}

public int updateSQL(String sql) throws SQLException{

Statement s = dbCon.createStatement();

int r = s.executeUpdate(sql);

return (r == 0) ? 0 : r;

}

}

rohit_sharma76a at 2007-7-12 18:24:17 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...