 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | NEWBEE: try to connect to Firebird database. | NEWBEE: try to connect to Firebird database. 2003-10-11 - By Richard Drent (Drent IT BV)
Back
The weird this is that they are in
WEB-INF/lib
And also in the
Jakarta-tomcat/lib
And I tried also with attribute 777, but Im lost in this one...
Is my syntax of connecting OK???
Greetz richard
Root cause:
java.lang.NoClassDefFoundError 
at java.lang.Class (Native Method)
at java.lang.Class (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)" <info@(protected)>
To: "'Tomcat Users List'" <tomcat-user@(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 (See http://iso-8859.ora-code.com)-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 (See http://iso-8859.ora-code.com)-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 (JspServlet.java:508)
at javax.servlet.http.HttpServlet (HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper (ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper (ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager (ContextManager.java:81
2)
at
org.apache.tomcat.core.ContextManager (ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler
(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 (Thread.java:484)
Root cause:
java.lang.NoClassDefFoundError
at java.lang.Class (Native Method)
at java.lang.Class (Class.java:120)
at
_0002fconnect_00033_0002ejspconnect3_jsp_20._jspService(_0002fconnect_00033_
0002ejspconnect3_jsp_20.java:82)
at
org.apache.jasper.runtime.HttpJspBase (HttpJspBase.java:119)
at javax.servlet.http.HttpServlet (HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet $JspCountedServlet.service(JspServlet.ja
va:130)
at javax.servlet.http.HttpServlet (HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet $JspServletWrapper.service(JspServlet.ja
va:282)
at
org.apache.jasper.servlet.JspServlet (JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet (JspServlet.java:500)
at javax.servlet.http.HttpServlet (HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper (ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper (ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager (ContextManager.java:81
2)
at
org.apache.tomcat.core.ContextManager (ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler
(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 (Thread.java:484)
###########################
#############################
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
|
