Alan_
unread,Sep 15, 2008, 3:49:31 PM9/15/08Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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