Erro de execução

Front-end
#1

Boa galera bom carnaval para os amigos.
Aqui o irmão de vc?s tem o seguinte problema ou falta de conhecimento para resolver tal:

Segue o código:

<%@ taglib uri=“http://jsptags.com/tags/navigation/pager”
prefix=“pg” %>

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

<sql:setDataSource var=“consulta”
driver=“sun.jdbc.odbc.JdbcOdbcDriver”
url=“jdbc:odbc:monitor”
user=""
password=""
/>

<sql:query var=“consulta” dataSource="${consulta}">
select * from ramal

</sql:query>
Lista de Contatos

Lista de Contatos

<pg:pager id=“p” maxPageItems=“25” maxIndexPages=“30”
export=“number,offset” scope=“request” >

<c:forEach var=“linha” items="${consulta.rows}">
pg:item





</pg:item>
</c:forEach>
Ramal grupo
<c:out value="${linha.ramal}"/> <c:out value="${linha.grupo}"/>

pg:index
pg:first <a href="<c:out value="${pageUrl}"/>">[Primeira] </pg:first>
pg:prev <a href="<c:out value="${pageUrl}"/>">[(<c:out value="${pageNumber}"/>) <Anterior] </pg:prev>
pg:pages <a href="<c:out value="${pageUrl}"/>"> <c:out value="${pageNumber}"/> </pg:pages>
pg:next <a href="<c:out value="${pageUrl}"/>">[Próxima> (<c:out value="${pageNumber}"/>)] </pg:next>
pg:last <a href="<c:out value="${pageUrl}"/>">[Última] </pg:last>
</pg:index>

</pg:pager>

Boa galera me ajuda aí…

Shelter , bom carnaval aos irmões…

#2

Olá

Qual é o erro?

#3

Boa tarde amigo desculpa a demora segue o erro:

[Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado

Valmir Lopes

#4

desculpa , segue o erro certo:

HTTP Status 500 -

type Exception report

message

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

exception

org.apache.jasper.JasperException: Exception in JSP: /abertura3.jsp:42

39: user=""
40: password=""
41: />
42: <sql:query var=“rs” dataSource="${con}">
43: select count (*)As efetuadas from CRJJ01 where tipo = 0 and servico between 1 and 2 and data = date()
44:
45: </sql:query>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

javax.servlet.ServletException: Unable to get connection, DataSource invalid: “java.sql.SQLException: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado”
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
org.apache.jsp.abertura3_jsp._jspService(abertura3_jsp.java:316)
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:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: “java.sql.SQLException: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado”
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.abertura3_jsp._jspx_meth_sql_query_0(abertura3_jsp.java:357)
org.apache.jsp.abertura3_jsp._jspService(abertura3_jsp.java:104)
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:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

Apache Tomcat/5.5.20

Obrigado pela ajuda

Shelter

#5