Bom dia pessoal.
Está sendo impresso no console do myeclipse cada vez que mudo de página em uma datatable com paginação (richfaces 3.1.1GA) uma listagem enorme de erros, por enquanto está funcionando, os dados estão corretos, consigo navegar nos dados atraves da paginação, mas não sei o que está errado.
Optei por richfaces pois já tem ajax embutido e a implementação que estou usando é a da Sun 1.1.01.
qualquer ajuda é válida.
Desde já agradeço.
Vou postar aqui minha classe de UsuarioDAO e a mensagem de erro:
public class UsuarioDAO {
private Connection conn;
private List<Usuario> listarUsuarios;
public UsuarioDAO() throws MyExceptions {
try {
this.conn = dbConexaoFactory.getConnection();
} catch (Exception e) {
throw new MyExceptions("Erro: " + e.getMessage());
}
}
public List<Usuario> listarTodos() throws MyExceptions {
PreparedStatement ps = null;
Connection conn = null;
ResultSet rs = null;
try {
conn = this.conn;
ps = conn.prepareStatement("SELECT cod_pes, raz_soc FROM pessoa;");
rs = ps.executeQuery();
listarUsuarios = new ArrayList<Usuario>();
while (rs.next()) {
Usuario user = new Usuario();
user.setCodigoPessoa(rs.getInt("cod_pes"));
user.setRazaoSocial(rs.getString("raz_soc"));
listarUsuarios.add(user);
}
return listarUsuarios;
} catch (SQLException sqle) {
throw new MyExceptions(sqle);
} finally {
dbConexaoFactory.closeConnection(conn, ps, rs);
}
}
public List<Usuario> getListarUsuarios() throws MyExceptions {
try{
listarTodos();
}catch (Exception e){
e.printStackTrace();
throw new MyExceptions("Erro: " + e.getMessage());
}
return listarUsuarios;
}
}
Mensagem de erro que vai para o console:
br.com.tgp.conexao.MyExceptions: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544363. no transaction for request
at br.com.tgp.dao.UsuarioDAO.listarTodos(UsuarioDAO.java:114)
at br.com.tgp.dao.UsuarioDAO.getListarUsuarios(UsuarioDAO.java:147)
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:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
at org.apache.el.parser.AstValue.getValue(AstValue.java:97)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at com.sun.faces.application.ValueBindingValueExpressionAdapter.getValue(ValueBindingValueExpressionAdapter.java:102)
at javax.faces.component.ValueExpressionValueBindingAdapter.getValue(ValueExpressionValueBindingAdapter.java:73)
at javax.faces.component.UIData.getValue(UIData.java:582)
at org.ajax4jsf.component.SequenceDataAdaptor.getDataModel(SequenceDataAdaptor.java:70)
at org.ajax4jsf.component.SequenceDataAdaptor.createDataModel(SequenceDataAdaptor.java:64)
at org.ajax4jsf.component.UIDataAdaptor.getExtendedDataModel(UIDataAdaptor.java:566)
at org.ajax4jsf.component.UIDataAdaptor.getRowCount(UIDataAdaptor.java:233)
at org.richfaces.component.UIDatascroller.getRowCount(UIDatascroller.java:365)
at org.richfaces.component.UIDatascroller.getPageCount(UIDatascroller.java:344)
at org.richfaces.renderkit.html.DataScrollerRenderer.isRenderedOnSinglePage(DataScrollerRenderer.java:47)
at org.richfaces.renderkit.html.DatascrollerTemplate.doEncodeEnd(DatascrollerTemplate.java:181)
at org.richfaces.renderkit.html.DatascrollerTemplate.doEncodeEnd(DatascrollerTemplate.java:639)
at org.ajax4jsf.renderkit.RendererBase.encodeEnd(RendererBase.java:135)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:833)
at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:286)
at org.richfaces.renderkit.AbstractRowsRenderer.encodeCellChildren(AbstractRowsRenderer.java:283)
at org.richfaces.renderkit.AbstractRowsRenderer.encodeTableHeaderFacet(AbstractRowsRenderer.java:305)
at org.richfaces.renderkit.AbstractTableRenderer.encodeFooter(AbstractTableRenderer.java:182)
at org.richfaces.renderkit.AbstractTableRenderer.encodeTableStructure(AbstractTableRenderer.java:82)
at org.richfaces.renderkit.html.DataTableRenderer.doEncodeBegin(DataTableRenderer.java:139)
at org.richfaces.renderkit.html.DataTableRenderer.doEncodeBegin(DataTableRenderer.java:128)
at org.ajax4jsf.renderkit.RendererBase.encodeBegin(RendererBase.java:101)
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:785)
at javax.faces.component.UIData.encodeBegin(UIData.java:879)
at org.ajax4jsf.component.UIDataAdaptor.encodeBegin(UIDataAdaptor.java:1041)
at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:280)
at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:143)
at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:86)
at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:134)
at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:86)
at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:134)
at org.ajax4jsf.renderkit.AjaxContainerRenderer.encodeAjax(AjaxContainerRenderer.java:122)
at org.ajax4jsf.component.AjaxViewRoot.encodeAjax(AjaxViewRoot.java:553)
at org.ajax4jsf.component.AjaxViewRoot$4.invokeRoot(AjaxViewRoot.java:384)
at org.ajax4jsf.context.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:56)
at org.ajax4jsf.context.AjaxContextImpl.invokeOnRegionOrRoot(AjaxContextImpl.java:173)
at org.ajax4jsf.component.AjaxViewRoot.encodeChildren(AjaxViewRoot.java:401)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:244)
at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:174)
at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:216)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
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:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
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:175)
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:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544363. no transaction for request
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:877)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:293)
at br.com.infoserv.dao.UsuarioDAO.listarTodos(UsuarioDAO.java:94)
... 72 more
21/11/2007 11:47:47 com.sun.faces.lifecycle.RenderResponsePhase execute
INFO: WARNING: FacesMessage(s) have been enqueued, but may not have been displayed.
sourceId=null[severity=(INFO 0), summary=(ok...), detail=(ok...)]
sourceId=null[severity=(INFO 0), summary=(GDS Exception. 335544363. no transaction for request), detail=(GDS Exception. 335544363. no transaction for request)]