NEWBEE: try to connect to Firebird database.

Sat, 11 Oct 2003 08:33:04 -0700 


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]























					Reply via email to