Tomcat+JSTL+JayBird+Firebird embeeded

Front-end
#1

Aguém já uso o firebird embarcado, com o tomcat?

O jaybird, copiei para o diretorio :…/webapps/testefirebird/WEB-INF/LIB, neste mesmo diretorio coloquei o firebird.

Charles.

<%@ taglib prefix=“sql” uri=“http://java.sun.com/jstl/sql” %>
<%@ taglib prefix=“c” uri=“http://java.sun.com/jstl/core” %>

<%–
<c:if test="${empty param.usuario or empty param.senha}">
<c:redirect url=“index.html” />
</c:if>
–%>

<sql:setDataSource
var=“ds”
driver=“org.firebirdsql.jdbc.FBDriver”
url=“jdbc:firebirdsql:embedded:…/webapps/testefirebird/WEB-INF/data/kitdb.fdb”
user=“SYSDBA”
password=“masterkey”
/>

<sql:transaction dataSource="${ds}">
sql:update
INSERT INTO usuario
(nome, username, senha, email)
VALUES
(’${param.nome}’, ‘${param.username}’, ‘${param.senha}’, ‘${param.email}’)
</sql:update>
</sql:transaction>

<c:set var=“user” value="${username}" scope=“session”/>
<c:redirect url=“lista_produtos.jsp”/>

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: javax/resource/ResourceException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.inserirusuario_jsp._jspService(inserirusuario_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NoClassDefFoundError: javax/resource/ResourceException
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:219)
org.apache.taglibs.standard.tag.common.sql.DataSourceWrapper.setDriverClassName(DataSourceWrapper.java:46)
org.apache.taglibs.standard.tag.common.sql.SetDataSourceTagSupport.doStartTag(SetDataSourceTagSupport.java:102)
org.apache.jsp.inserirusuario_jsp._jspx_meth_sql_setDataSource_0(inserirusuario_jsp.java:114)
org.apache.jsp.inserirusuario_jsp._jspService(inserirusuario_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

#2

tava tendo esse mesmo problema, verifica a jvm que vc ta usando e baixa o jaybird correspondente a sua jvm, aqui estou usando a jvm 1.5 baixei o jaybird 2.1 para jvm 1.5 e ate agora pareceque esta funcionando.

#3