Jsp, erro no select  XML
Índice dos Fóruns » Desenvolvimento Web
Autor Mensagem
[Post New]11/12/2006 10:14:41
    Assunto: Jsp, erro no select
[Up]
evandro_araujo
Thread.start()

Membro desde: 21/10/2006 15:40:23
Mensagens: 35
Offline
Minha conexao:

<sql:setDataSource var="ds"

url="jdbc:firebirdsql:localhost/3050:c:/academirco.gdb"

user="sysdba"

password="masterkey"

scope="session"/>


Quando incluo esta linha no meu jsp

<sql:query var="qryEstados" dataSource="${ds}">

select * from ESTADOS

order by

NOME

</sql:query>


da o seguinte erro:


message

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

exception

javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:84
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.index_jsp._jspService(index_jsp.java:174)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)


root cause

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
org.apache.jsp.index_jsp._jspx_meth_sql_query_0(index_jsp.java:213)
org.apache.jsp.index_jsp._jspService(index_jsp.java:133)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.

o que sera que esta acontecendo???



Evandro
[Post New]11/12/2006 10:21:02
    Assunto: Jsp, erro no select
[Up]
furutani
JWizard
[Avatar]

Membro desde: 11/10/2003 23:58:51
Mensagens: 2995
Localização: Iacri-SP e São Paulo-SP
Offline
O driver do firebird esta no classpath?
Até mais,
Roberto Jundi Furutani


Sun Certified Business Component Developer 1.3
Sun Certified Web Component Developer
Sun Certified Java Programmer
SAP Certified Development Associate - ABAP with SAP NetWeaver 7.0

[WWW]
[Post New]11/12/2006 11:20:23
    Assunto: Re:Jsp, erro no select
[Up]
evandro_araujo
Thread.start()

Membro desde: 21/10/2006 15:40:23
Mensagens: 35
Offline
sim
[Post New]11/12/2006 11:20:45
    Assunto: Re:Jsp, erro no select
[Up]
evandro_araujo
Thread.start()

Membro desde: 21/10/2006 15:40:23
Mensagens: 35
Offline
sim
 
Índice dos Fóruns » Desenvolvimento Web
Ir para:   
Powered by JForum 2.1.8 © JForum Team