小弟在做一个例的时,想用jsp连接mysql(5.0.19)我用的JDBC驱动是mysql-connector-java-3.1.12-bin.jar,应用服务是tomcat(5.0.28),jdk(1.4.2_07).不在tomcat服务下时,我写了个控制台的程序,可以连接数据,可是到tomcat下就不行了,现面是原码和错误:
<%
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("Class.forName()");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/demo","root","guopeng");
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from user");
while(rs.next())
{
System.out.println(rs.getString(2).toString());
}
}catch(Exception e)
{
out.println("LoadDriver: \n"+e.toString());
}
%>///////////////////////////////////////////////////////////////////////////
type Exception reportmessage 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.login_jsp._jspService(login_jsp.java:115)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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:802)
root cause java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
org.apache.jsp.login_jsp._jspService(login_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
<%
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("Class.forName()");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/demo","root","guopeng");
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from user");
while(rs.next())
{
System.out.println(rs.getString(2).toString());
}
}catch(Exception e)
{
out.println("LoadDriver: \n"+e.toString());
}
%>///////////////////////////////////////////////////////////////////////////
type Exception reportmessage 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.login_jsp._jspService(login_jsp.java:115)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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:802)
root cause java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
org.apache.jsp.login_jsp._jspService(login_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
解决方案 »
- SSH 中hibernate一级缓存问题(求助)
- js中的geturl取值的内容
- 求助:axis2用DII方式发布web service时显示Requested resource not found!
- struts2+spring 分页程序,那位有现在的代码?用的是spring jdbctemplet
- 兄弟有关jsp阿拉伯语资源文件显示的问题,请大侠帮忙。在线急等。问题见正文
- jsp中怎么解析XML语句???
- 高手进 在线 等!!!!!!!!!
- 简单问题,setproperty
- jsp做WEB进销存系统怎样实现多栏输入并保存到数据库?
- 唉!还是中文问题!!!!!!!!!!
- Tomcat5.5.16 安装后出问题了!
- 请高手9命啊!! 帮忙看看是怎么回事!!
http://www.eclipse.org/downloads/download.php?file=/technology/aspectj/aspectj-1.5.0.jar&url=http://anak.kambing.vlsm.org/eclipse/technology/aspectj/aspectj-1.5.0.jar&mirror_id=171
工程里是否引入了mysql包啊?