Two Laptop Bag*
The moose likes JSP and the fly likes Error in JSP when using bean concept Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Error in JSP when using bean concept" Watch "Error in JSP when using bean concept" New topic
Author

Error in JSP when using bean concept

raji navaneethan
Greenhorn

Joined: Apr 06, 2006
Posts: 15
// My JSP coding. This is stored in the following path ]http://localhost:8080/vennila/test.jsp
<HTML>
<HEAD><TITLE>DataBase Search</TITLE></HEAD>
<BODY>

<%@ page language="Java" import="java.sql.*" %>
<jsp:useBean id="db" scope="application" class="SQLBean.DbBean"/>
<jsp:setProperty name="db" property="*" />

<%!
ResultSet rs = null ;
ResultSetMetaData rsmd = null ;
int numColumns ;
int i;
%>
<center>
<h2> Results from </h2>
<hr>
<br><br>
<table>
<%
db.connect();
rs = db.execSQL("select * from emp1");
i = db.updateSQL("UPDATE emp1 set fname = 'hello world' where
empid=101");
out.println(i);

rsmd = rs.getMetaData();
numColumns = rsmd.getColumnCount();
for(int column=1; column <= numColumns; column++)
{
out.println(rsmd.getColumnName(column));
}
%>

<%
while(rs.next())
{
%>
<%= rs.getString("empid") %>
<BR>
<%
}
%>
<BR>
<%
db.close();
%>
Done
</table>
</body>
</HTML>



//My Java Package Coding. It is compiled and stored in the following path :
C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\



package SQLBean;

import java.sql.*;
import java.io.*;


public class DbBean {

String dbURL = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbDriver = "'jdbc dbc:emp','',''";
private Connection dbCon;

public DbBean(){
super();
}

public boolean connect() throws ClassNotFoundException,SQLException{
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL);
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;
}

}

----------------- xxxx-------------------------

When i run the jsp in internet explorer its giving me the following error :

C:\Program Files\Apache Tomcat 4.0 work\localhost\vennila\test$jsp.java:72: Class SQLBean.DbBean not found.
SQLBean.DbBean db = null;
^



I am breaking my head towards this problem for the past 4 days. I am new to Bean concept. kindly help me to solve this problem.

[ April 16, 2006: Message edited by: raji navaneethan ]
[ April 16, 2006: Message edited by: raji navaneethan ]
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\


Should be in C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\SQLBean\


[My Blog]
All roads lead to JavaRanch
raji navaneethan
Greenhorn

Joined: Apr 06, 2006
Posts: 15
// My JSP coding. This is stored in the following path ]http://localhost:8080/vennila/test.jsp

<HTML>
<HEAD><TITLE>DataBase Search</TITLE></HEAD>
<BODY>

<%@ page language="Java" import="java.sql.*" %>
<jsp:useBean id="db" scope="application" class="SQLBean.DbBean"/>
<jsp:setProperty name="db" property="*" />

<%!
ResultSet rs = null ;
ResultSetMetaData rsmd = null ;
int numColumns ;
int i;
%>
<center>
<h2> Results from </h2>
<hr>
<br><br>
<table>
<%
db.connect();
rs = db.execSQL("select * from emp1");
i = db.updateSQL("UPDATE emp1 set fname = 'hello world' where
empid=101");
out.println(i);

rsmd = rs.getMetaData();
numColumns = rsmd.getColumnCount();
for(int column=1; column <= numColumns; column++)
{
out.println(rsmd.getColumnName(column));
}
%>

<%
while(rs.next())
{
%>
<%= rs.getString("empid") %>
<BR>
<%
}
%>
<BR>
<%
db.close();
%>
Done
</table>
</body>
</HTML>



//My Java Package Coding. It is compiled and stored in the following path: C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\

package SQLBean;

import java.sql.*;
import java.io.*;


public class DbBean {

String dbURL = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbDriver = "'jdbc dbc:emp','',''";
private Connection dbCon;

public DbBean(){
super();
}

public boolean connect() throws ClassNotFoundException,SQLException{
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL);
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;
}

}

----------------- xxxx-------------------------

When i run the jsp in internet explorer its giving me the following error :

C:\Program Files\Apache Tomcat 4.0 work\localhost\vennila\test$jsp.java:72: Class SQLBean.DbBean not found.
SQLBean.DbBean db = null;
^


My Java file is stored in the following path : C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes

My Class file is stored in the following path :
C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\SQLBean


I am breaking my head towards this problem for the past 4 days. I am new to Bean concept. kindly help me to solve this problem.
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

I don't know if it has some relation but try to rename your package in lowercase :
sqlbean, not SQLBean.

Correct your java and jsp files, recompile and redeploy.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
P.S. Never under-estimate naming conventions. They can show you worst.
Rodrigo Alvarez
Ranch Hand

Joined: Apr 10, 2006
Posts: 75
I think you need to import your SQLBean package in the JSP file, try this :




It is a mistake to think you can solve any major problems just with potatoes.<br />--Douglas Adams
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in JSP when using bean concept