找不到类com.mysql_java – 在webservice 中找不到类异常Class.forName(“com.mysql.jdbc.Driver”)...

参见英文答案 >

How to install JDBC driver in Eclipse web project without facing java.lang.ClassNotFoundexception                                    13个

我有一个问题,需要帮助Class.forName(“com.mysql.jdbc.Driver”),当我从eclipse运行webservice时抛出类未找到异常,但是当我创建新的java项目时,它运行完美.

我在两个项目的构建路径中添加了mysql-connector-java-5.1.19-bin.jar

但我不知道webservice中的问题是什么.

public String insertOrder(

int current_id,

int table_id)

{

try {

Class.forName("com.mysql.jdbc.Driver");

Connection con =

DriverManager.getConnection("jdbc:mysql://localhost:3306/myhoteldb", "root", "mypassword");

PreparedStatement st =

con.prepareStatement("insert into orders(orders.current_id,orders.table_id) values(?,?)");

st.setInt(1, current_id);

st.setInt(2, table_id);

st.executeUpdate();

} catch (Exception e) {

System.out.println(e.getMessage());

}

return "record inserted";

}

}

这个错误日志

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at pkg.MyServices.insertOrder(MyServices.java:124)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:194)

at org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:102)

at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)

at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)

at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:173)

at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:173)

at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:144)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Unknown Source)