connecting to mysql using jsp

Thread view:

bindu - 24 Sep 2006 17:26 GMT

hi,
I am trying to connect to database using jsp and mysql.java1.4.0,mysql5.0.
25and tomcat5.0 and copied mysql-connector-java-3.1.8-bin-g.jar into tomcat\
common\lib folder and also in tomcat\webapps.In the webapps i stored my
folder.when irun my code i am getting following error
HTTP Status 500 -

------------------------------------------------------------------------------
--

type Exception report

message

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

exception

javax.servlet.ServletException: org/aspectj/lang/Signature
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException
(PageContextImpl.java:825)
    org.apache.jasper.runtime.PageContextImpl.handlePageException
(PageContextImpl.java:758)
    org.apache.jsp.imagecode_jsp._jspService(imagecode_jsp.java:129)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
298)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

root cause

java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:130)
    org.apache.jsp.imagecode_jsp._jspService(imagecode_jsp.java:84)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
298)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

note The full stack trace of the root cause is available in the Apache
Tomcat/5.0.25 logs.

------------------------------------------------------------------------------
--
this is the code for inserting data;

<html>
<head>
<title>result:</title>
</head>
<body bgcolor=#FFFFFF>

<h1>
<font color=white>
result:
</font>
</h1>

<%@ page info="File uploader"%>
<%@ page import="java.io.*"%>
<%@ page import="java.io.File"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.Blob"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%

//initializing database connection
try
{

String driver = "org.gjt.mm.mysql.Driver";
Class.forName(driver).newInstance();

Connection con=null;
ResultSet rst=null;

Statement stmt=null;

String url="jdbc:mysql://localhost:3306/tenminutesoffame?
user=root&password=123456";

con=DriverManager.getConnection(url);
stmt=con.createStatement();

String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String country=request.getParameter("country");

stmt.executeUpdate("insert into form(fname,lname,country) values('"+fname+"',
'"+lname+"','"+country+"')");

con.close();
}

catch (Exception e) {
//print error message
out.println("<center><font size=5> Error in inserting the
data</font></center>");
out.println("the error is:"+e.toString());

}

%>
</body>
</html>
********************************************************************************
this code to retrive data;

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.Blob"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page info="File uploader"%>
<%

Connection con=null;
ResultSet rst=null;

Statement stmt=null;
try
{
String driver = "org.gjt.mm.mysql.Driver";
Class.forName(driver).newInstance();

String url="jdbc:mysql://localhost:3306/tenminutesoffame?
user=root&password=123456";

con=DriverManager.getConnection(url);
stmt=con.createStatement();

rst=stmt.executeQuery("select * " + "from form");

while(rst.next())
{

out.println( rst.getString("fname") );
out.println(rst.getString("lname"));
out.println(rst.getString("country"));

}
rst.close();
con.close();
}

catch (Exception e) {
//print error message
out.println("<center><font size=5> Error in inserting the
data</font></center>");
out.println("the error is:"+e.toString());

}

%>

********************************************************************************
this is html code

<html>
<title></title>
<BODY bgColor=lightyellow>

<FORM name=registrationpage2 method=post action="imagecode.jsp">
FIRST NAME:
<INPUT type="text" name="fname" value=" ">

<br>
LAST NAME
<input type="text name="lname" value=" ">
<br>
COUNTRY:
<input type="text name="country" value=" ">
<br>
<input type="button" name=Submit value="Submit">

</body>
</html>

Reply to this Message

David Harper - 24 Sep 2006 20:46 GMT

> hi,
> I am trying to connect to database using jsp and mysql.java1.4.0,mysql5.0.
> 25and tomcat5.0 and copied mysql-connector-java-3.1.8-bin-g.jar into tomcat\
> common\lib folder and also in tomcat\webapps.In the webapps i stored my
> folder.when irun my code i am getting following error

[SNIP]

> root cause
>
[quoted text clipped - 9 lines]
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

From the Java API documentation for java.lang.NoClassDefFoundError:

Thrown if the Java Virtual Machine or a ClassLoader instance tries
to load in the definition of a class (as part of a normal method
call or as part of creating a new instance using the new expression)
and no definition of the class could be found.

The searched-for class definition existed when the currently
executing class was compiled, but the definition can no longer be
found.

This means that the Tomcat JVM cannot find the class file for the class
org.aspectj.lang.Signature.

Check that the AspectJ JAR file is in a location where the Tomcat JVM
can find it.

David Harper
Cambridge, England

Reply to this Message

connecting to mysql using jsp

Free Magazines