• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to connect to mysql using jsp  RSS feed

 
bindu priya
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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>
 
Richard Green
Ranch Hand
Posts: 536
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i had the same problem before. i cant exactly remember how i solved it - but i have a vague recollection of copying some more jars to my tomcat common/lib folder (aspectjrt.jar or something like that).

have a look at the mysql forum - thats where i found the solution when i had this problem.
 
Stefan Evans
Bartender
Posts: 1836
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which jbdc driver did you download?
Does it have a file "mysql-connector-java-3.1.8-bin.jar" - ie without the -g?

The correct driver should not require any other files.
 
bindu priya
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have used the mysql-connector-java-3.1.8-bin-g.jar file into the tomcat\common\lib and tomcat\webapps\ folder and no other files.wat is the correct jar file can you please tell me.for my code.
tomcat5.0
mysql5.0
j2sdk1.4.0
am i using the correct jar file?
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a debug version. I think you should use the one without "-g"
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!