• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JSP and ODBC

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to execute a java program from JSP, which will return a ResultSet to JSP. I am getting the Class not found error.
Part of my JSP:
<%@ page contentType="text/xml" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dbconnectbean" scope="page" class="DBConnectBean"/>
<%!
ResultSet rs=null;
ResultSetMetaData rsmd=null;
int count;
%>
<resultset>
<%
rs=dbconnectbean.getResult(); ----> ERROR IN THIS LINE
My Java program:
import java.util.*;
import java.sql.*;
import java.io.*;
import java.text.*;
public class DBConnectBean implements Serializable {
private Connection con = null;
private String url;
private String userLogin;
private String password;
private static final String empID = "EMP1002";
public ResultSet rs = null;
private Statement stmt = null;
private PrintWriter out = null;
private String SQL;
static {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception e) {
System.out.println("Can't get the driver");
e.printStackTrace();
}
}
public DBConnectBean() {
url=null;
userLogin=null;
password=null;
SQL=null;
}
public ResultSet getResult() throws SQLException
{
try {
url="jdbc dbc:JSPTest";
userLogin="guest";
password="guest";
con = DriverManager.getConnectionurl,userLogin, password);
} catch (Exception e) { e.printStackTrace(); }
try {
SQL="select * from employee_mst;
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
} catch (Exception e) { out.println ("Exception " + e ; }
return rs;
}
}
The error is:
org.apache.jasper.JasperException: Unable to compile class for JSPD:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fjsp_0002fxmldb_0002ejspxmldb_jsp_2.java:73: Class jsp.DBConnectBean not found.
DBConnectBean dbconnectbean = null;
Any help is appreciated.
Regds
Devi
 
Ranch Hand
Posts: 234
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You need to import whatever package your DBConnectBean class is in.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic