Root cause: java.lang.NoClassDefFoundError at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:120)
The problem is that you don't deploy the "FirebirdSQL" driver. Put all the following files firebirdsql-full.jar jaas.jar log4j-core.jar mini-concurrent.jar mini-j2ee.jar in the "WEB-INF\lib" folder. That's all. Diego ----- Original Message ----- From: "Richard Drent (Drent IT BV)" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 5:33 PM Subject: NEWBEE: try to connect to Firebird database. Hi all I'm lost, I try to connect to a firebird database with the Jaybird jdbc. I have her the syntax of my page, because I don't now if it is tomcat, the JDBC or my page who is making the error. The error is at the bottom of this msg. So can some body tell me what is wrong here, or where to start. Thnx Richard ################## Here is the syntax of my page ########################### <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*, javax.naming.*,javax.sql.*" errorPage="" %> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <% Connection con; String databaseURL = "jdbc:firebirdsql:192.168.0.115/3050:/home/firebird/data/employee.fdb"; String user = "sysdba"; String password = "richard"; //String driverName = "org.firebirdsql.jdbc.FBDriver"; java.sql.Connection c = null; java.sql.Statement s = null; java.sql.ResultSet rs = null; //Load driver Class.forName("org.firebirdsql.jdbc.FBDriver"); //Attempt to connect to a driver. c = DriverManager.getConnection(databaseURL, user, password); //Create a Statement object s = c.createStatement(); //java.sql.ResultSet result = stmt.executeQuery ("select full_name from employee where salary < 50000"); rs = s.executeQuery("SELECT * FROM SALES"); %> </table> </body> </html> ###################### ######################## Error msg ##################### Error: 500 Location: /connect3.jsp Internal Servlet Error: javax.servlet.ServletException at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:508) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 2) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection (Ajp12ConnectionHandler.java:166) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Thread.java:484) Root cause: java.lang.NoClassDefFoundError at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:120) at _0002fconnect_00033_0002ejspconnect3_jsp_20._jspService(_0002fconnect_00033_ 0002ejspconnect3_jsp_20.java:82) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja va:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:282) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 2) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection (Ajp12ConnectionHandler.java:166) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Thread.java:484) ########################### ############################# --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]