Hi,
I have a problem with jdbc ResultSet class in method next() or first().
The MAXDB version is 7.6.00.16 and JDBC is 7.6.00.16.4753, the problem always
does not occur.
Full stack trace error:
com.sap.dbtech.jdbc.ResultSetSapDB.fetchFirst(ResultSetSapDB.java:2512)com.sap.dbtech.jdbc.ResultSetSapDB.next(ResultSetSapDB.java:387)com.sap.dbtech.jdbcext.ClientResultSetSapDB.next(ClientResultSetSapDB.java:259)dao.DAOEstoqueCartaoRevenda.listarTransferencia(DAOEstoqueCartaoRevenda.java:1039)action.estoque.PaginaEstoqueTransferenciaAction.obterListagem(PaginaEstoqueTransferenciaAction.java:127)action.estoque.PaginaEstoqueTransferenciaAction.performAction(PaginaEstoqueTransferenciaAction.java:91)br.com.softfocus.infra.action.SoftfocusAction.performCoreAction(SoftfocusAction.java:34)br.com.softfocus.infra.action.SoftfocusCoreAction.execute(SoftfocusCoreAction.java:45)org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)javax.servlet.http.HttpServlet.service(HttpServlet.java:709)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)java.lang.Thread.run(Unknown
Source)
java code:
StringBuffer sql = new StringBuffer();
sql.append("SELECT A.CODIGO, A.LOTE, A.NUMERO, C.CODIGO, C.NOME, B.DESCRICAO,
B.QTDE_MINIMA, B.CODIGO, D.VALOR_ATUAL ");
sql.append(" FROM ESTOQUE_CARTAO_REVENDA AS A ");
sql.append(" INNER JOIN PRODUTO AS B ON ");
sql.append(" A.CODIGO_PRODUTO = B.CODIGO ");
sql.append(" INNER JOIN SYS_OPERADORA AS C ON ");
sql.append(" A.CODIGO_OPERADORA = C.CODIGO ");
sql.append(" INNER JOIN PRODUTO_VALOR AS D ON ");
sql.append(" B.CODIGO = D.CODIGO_PRODUTO ");
sql.append(" WHERE A.CODIGO_REPRESENTANTE IS NULL ");
sql.append(" AND A.DATA_VENDA IS NULL ");
sql.append(" AND A.CODIGO_REVENDA = ? ");
if (beanPesquisa.getDescricao().trim().length() > 0) {
sql.append(" AND ( UPPER(B.DESCRICAO) LIKE ? ");
sql.append(" OR UPPER(C.NOME) LIKE ? )");
}
if (beanPesquisa.getLote().trim().length() > 0) {
sql.append(" AND A.LOTE = ? ");
}
sql.append(" ORDER BY C.NOME, B.DESCRICAO, A.LOTE, A.NUMERO ");
prepSt = con.prepareStatement(sql.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
int i = 1;
prepSt.setInt(i++, beanPesquisa.getBeanRevenda().getCodigo());
if (beanPesquisa.getDescricao().trim().length() > 0) {
prepSt.setString(i++, beanPesquisa.getDescricao().toUpperCase() + "%");
prepSt.setString(i++, beanPesquisa.getDescricao().toUpperCase() + "%");
}
if (beanPesquisa.getLote().trim().length() > 0) {
prepSt.setString(i++, beanPesquisa.getLote());
}
rs = prepSt.executeQuery();
rs.setFetchSize(beanPaginacao.getQtdeLinhasPagina());
if (rs.next()) { --> in this line occur the java.lang.NullPointerException
.
.
.
Thanks
Marcio Cardozo
Diretor
Softfocus. Sua empresa em foco.
__________________________
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
