Ajudar com configuração

5 views
Skip to first unread message

Alan_

unread,
Sep 15, 2008, 3:49:31 PM9/15/08
to javasf: JavaServer Faces International Group
Bom Tarde a todos... Estou com uma problema que nao estou conseguindo
resolver.

Tenho uma classes de conexao:
public static Connection getConexao(){

try{
System.out.println("Carregar Driver");
Class.forName("org.postgresql.Driver");

conn = DriverManager.getConnection("jdbc:postgresql://localhost:
5432/projeto_pessoal","postgres","123456");

System.out.println("Conexao com banco");

}catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
}

return conn;
}
Um Bean que chama esse classe:
private static Connection conn;

public String mostrarConexao() throws SQLException {

System.out.println("conexao");

try{
conn= Conexao.getConexao();
System.out.println("conexao feita");
}
catch (Exception e) {
e.printStackTrace();
}finally{
conn.close();
}
return "";
}

e tenho uma pagina jsp, que chama a acao:
<h:form id="main">
<h:commandButton action="#{teste.mostrarConexao}" id="id" />
</h:form>

e por fim tenho um problema que nao estou conseguindo resolver:

15/09/2008 16:27:11 javax.faces.webapp._ErrorPageWriter
handleException
SEVERE: An exception occurred
javax.faces.FacesException: Error calling action method of component
with id main:id
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:
69)
at javax.faces.component.UICommand.broadcast(UICommand.java:121)
at
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:
316)
at
org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:
291)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:
248)
at
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:
461)
at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:
32)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:
103)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:
76)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:148)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:
147)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
at org.ajax4jsf.Filter.doFilter(Filter.java:175)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
845)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
447)
at java.lang.Thread.run(Thread.java:595)
Caused by: javax.faces.el.EvaluationException:
org.apache.jasper.el.JspELException: /index.jsp(19,2)
'#{teste.mostrarConexao}' java.lang.NullPointerException
at
javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:
79)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:
54)
... 26 more
Caused by: org.apache.jasper.el.JspELException: /index.jsp(19,2)
'#{teste.mostrarConexao}' java.lang.NullPointerException
at
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:
77)
at
javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:
75)
... 27 more
Caused by: java.lang.NullPointerException
at br.com.classes.Teste.mostrarConexao(Teste.java:23)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.el.parser.AstValue.invoke(AstValue.java:172)
at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:
276)
at
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:
68)
... 28 more

------------------------------------------------------------------------

O estranho que eu acho é quando eu vou carregar o Driver, ele nao dar
esse erro ai!

Alguem poderia me ajudar??!!??!
Nao sei mais o que fazer!

agradeço a atenção

Rodrigo Aguas

unread,
Sep 15, 2008, 9:06:31 PM9/15/08
to jav...@googlegroups.com

Colocou o ManagedBean no faces-config.xml com o nome de teste?
--
Rodrigo Aguas
www.rodrigoaguas.com
Reply all
Reply to author
Forward
0 new messages