Jstl

Front-end
#1

Estou com o seguinte codigo:

Tenho uma tabela no postgre, e estou tendando exibila com o seguinte codigo:
<%@page contentType=“text/html”%>
<%@page pageEncoding=“UTF-8”%>

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

JSP Page 
<a href="./faces/welcomeJSF.jsp">Página de Boas-Vindas do JavaServer Faces</a>



<sql:setDataSource var="con"
driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/teste"
user="postgres"
password="1272"
/>    
<sql:query var="rs" dataSource="${con}">
SELECT * FROM atn   
</sql:query>

<B>Suas operadoras são</B>

<c:forEach var='row' items='${rs.rowsByIndex}'>
<c:out value='${rowData}'/>    
</c:forEach>


</body>

Estou recebendo este erro:
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: /index.jsp:29

26: user=“postgres”
27: password=“1272”
28: />
29: <sql:query var=“rs” dataSource="${con}">
30: SELECT * FROM atn
31: </sql:query>
32:

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause

javax.servlet.ServletException: Unable to get connection, DataSource invalid: “org.postgresql.util.PSQLException: FATAL: database “teste” does not exist”
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.index_jsp._jspService(index_jsp.java:107)
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:332)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: “org.postgresql.util.PSQLException: FATAL: database “teste” does not exist”
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:148)
org.apache.jsp.index_jsp._jspService(index_jsp.java:88)
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:332)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

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

Apache Tomcat/5.5.17

Boa galera …vlw pela dica

#2

só olhar seu log

[code]root cause

javax.servlet.ServletException: Unable to get connection, DataSource invalid: “org.postgresql.util.PSQLException: FATAL: database “teste” does not exist”

[/code]

#3

amigo , boa noite…sou iniciante …as vezes a insegurança cega… não consegui ainda ver o erro o nobre amigo poderia me ajudar mais claro…

te agradeço muito

um forte abraço E MUITO OBRIGADO.

#4

Shelter,

O que Giulliano tá te mostrando que a sua aplicação não esta encontrando o Banco-de-Dados com o nome “teste”.

Olha só o que o “log de erro” esta te retornando:
“org.postgresql.util.PSQLException: FATAL: database “[color=blue]teste[/color]” [color=darkred]does not exist[/color]”

Verifique se esse “Banco” realmente existe com esse nome =]

#5

Boa galera …vlw … o erro cx alta… Teste e teste …

na boa vlw…

abraços

#6