Unzip the connector and place the .jar file in the common\lib directory or in the webapps\**appname**\WEB-INF\lib directory.
-----Original Message----- From: Massimiliano PASQUALONI [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 9:00 AM To: users@tomcat.apache.org Subject: Msql Connector/J Hi everybody! I'ved downloaded mysql-connector-java-5.1.0.zip. I'ved put the mysql-connector-java-5.1.0-bin.jar in C:\Programmi\Java\jre1.6.0_01\lib and I'ved set the %CALSSPATH% on the same directory. I'ved create a jsp page: <%@ page import="java.sql.*" %> <% String connectionURL = "jdbc:mysql://localhost:3306/bi?user=USER;password=PASSWORD"; Connection connection = null; Statement statement = null; ResultSet rs = null; %> <html><body> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "", ""); statement = connection.createStatement(); rs = statement.executeQuery("SELECT * FROM TABLE WHERE username='ciao' and password='ciao' and Abilitato = 1"); while (rs.next()) { out.println(rs.getString("username")+"<br>"); } rs.close(); %> Tomcat send me an 500 error: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Exception in JSP: /prova.jsp:14 11: <html><body> 12: 13: <% 14: Class.forName("com.mysql.jdbc.Driver").newInstance(); 15: connection = DriverManager.getConnection(connectionURL, "", ""); 16: statement = connection.createStatement(); 17: rs = statement.executeQuery("SELECT * FROM ANAG_UTENTI WHERE username='ciao' and password='ciao' and Abilitato = 1"); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWra pper.java:467) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3 71) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) root cause javax.servlet.ServletException: com.mysql.jdbc.Driver org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI mpl.java:846) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:779) org.apache.jsp.prova_jsp._jspService(prova_jsp.java:79) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3 28) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) root cause java.lang.ClassNotFoundException: com.mysql.jdbc.Driver org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1359) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1205) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66) java.lang.ClassLoader.loadClassInternal(Unknown Source) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Unknown Source) org.apache.jsp.prova_jsp._jspService(prova_jsp.java:57) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3 28) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs. It's the connector don't work? Thanks!!! Massimiliano PASQUALONI Data Processing S.r.l. Reparto EDP S.S. 100 BA-TA Km 18 c/o "IL BARICENTRO" torre D 70010 CASAMASSIMA (BA) --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
