Ajuda com Statement

Olá Pessoal, estou trabalhando com um componente chamado open swing,

Tá dando erro no statemente, quando passo a sql, alguem tem ideia

olhe o codigo

[code]package br.com.controllers;

import br.com.frames.CadCliFr;
import br.com.vos.CadCliVO;
import java.sql.;
import java.util.
;
import org.openswing.swing.mdi.client.MDIFrame;
import org.openswing.swing.message.receive.java.*;
import org.openswing.swing.message.send.java.FilterWhereClause;
import org.openswing.swing.table.client.GridController;
import org.openswing.swing.table.java.GridDataLocator;

public class CadCliController extends GridController implements GridDataLocator {

private CadCliFr grid = null;
private Connection conn = null;

public CadCliController(Connection conn) {

    this.conn = conn;
    grid = new CadCliFr(conn, this);
    
    /* FAZER UMA VERIFICAÇÃO
     * PARA NÃO DEIXAR ABRIR O MESMO
     * FORM MAIS DE UMA VEZ
    */

    MDIFrame.add(grid, true);
}

public void DoubleClick(int rowNumber, ValueObject persistentObject){

// CadCliVO vo = (CadCliVO) persistentObject;
// new

}



  @Override
public Response loadData(
          int action,
          int startIndex,
          Map filteredColumns,
          // atuais colunas classificadas
          ArrayList currentSortedColumns,
          //ordenar as colunas classificadas X colunas
          ArrayList currentSortedVersusColumns,
          Class valueObjectType,
          Map otherGridParams) {

    PreparedStatement stmt = null;

    System.out.println("Entrou no load data");

    try {

        System.out.println("Entrou no try");

        String sql = "SELECT c.auto, "
                        + "  c.razao_social, "
                        + "  c.cpf_cnpj, "
                        + "  c.tel_cont1, "
                        + "  c.tel_cont2, "
                        + "  c.tel_cont3, "
                        + "  c.nome_fantasia, "
                        + "  c.cep, "
                        + "  c.tipo_logradouro, "
                        + "  c.logradouro, "
                        + "  c.complemento, "
                        + "  c.bairro, "
                        + "  c.cidade, "
                        + "  c.email1, "
                        + "  c.email2, "
                        + "  c.email3, "
                        + "  c.insc_estadual_rg, "
                        + "  c.insc_municipal, "
                        + "  c.observacao, "
                        + "  c.uf "

                        + "  FROM cliente c ;";

        Vector vals = new Vector();

        Map mapa = new HashMap();

        mapa.put("auto", "c.auto");
        mapa.put("razao_social", "c.razao_social"); // indice 1
        mapa.put("cpf_cnpj", "c.cpf_cnpj");
        mapa.put("tel_cont1", "c.tel_cont1");
        mapa.put("tel_cont2", "c.tel_cont2");
        mapa.put("tel_cont3", "c.tel_cont3");
        mapa.put("nome_fantasia", "c.nome_fantasia");
        mapa.put("cep", "c.cep");
        mapa.put("tipo_logradouro", "c.tipo_logradouro");
        mapa.put("logradouro", "c.logradouro");
        mapa.put("complemento", "c.complemento");
        mapa.put("bairro", "c.bairro");
        mapa.put("cidade", "c.cidade");
        mapa.put("email1", "c.email1");
        mapa.put("email2", "c.email2");
        mapa.put("email3", "c.email3");
        mapa.put("insc_estadual_rg", "c.insc_estadual_rg");
        mapa.put("insc_municipal", "c.insc_municipal");
        mapa.put("observacao", "c.observacao");
        mapa.put("uf", "c.uf");

        if (filteredColumns.size() > 0) {

            System.out.println("Entrou no 1 IF");

            FilterWhereClause[] filter = (FilterWhereClause[]) filteredColumns.get("c.razao_social");
            sql += " WHERE c.razao_social " + filter[0].getOperator() + "?";

            vals.add(filter[0].getValue());


        }

/* if (currentSortedColumns.size() > 0) {

            System.out.println("Entrou no 2 IF");

            //sql += " ORDER BY " + mapa.get(currentSortedColumns.get(0).toString() + " " + currentSortedVersusColumns.get(0));
        }

*/
System.out.println(“Executando o Statement”);

        System.out.println(sql);
      
        stmt = conn.prepareStatement(sql);

        System.out.println("Executou Statement");
        
        for (int i = 0; i < vals.size(); i++) {

            System.out.println("Entrou no FOR");

            stmt.setObject(i + 1, vals.get(i));
        }

        ResultSet rset = stmt.executeQuery();

        // imprime o result set
        System.out.println("Passsou pelo rset");

        ArrayList list = new ArrayList();
        CadCliVO vo = null;
        while (rset.next()) {

            vo = new CadCliVO();

            // SETA O CAMPO AUTO DE CLIENRTE VO

            System.out.println("Entrou no while");

            vo.setAuto(rset.getInt(1));
            
            vo.setRazao_social(rset.getString(2));
            vo.setCpf_cnpj(rset.getString(3));
            vo.setTel_cont1(rset.getString(4));
            vo.setTel_cont2(rset.getString(5));
            vo.setTel_cont3(rset.getString(6));
            vo.setNome_fantasia(rset.getString(7));
            vo.setCep(rset.getString(8));

            vo.setTipo_logradouro(rset.getInt(9));

            vo.setLogradouro(rset.getString(10));
            vo.setComplemento(rset.getString(11));
            vo.setBairro(rset.getString(12));
            vo.setCidade(rset.getString(13));

            vo.setEmail1(rset.getString(14));
            vo.setEmail2(rset.getString(15));
            vo.setEmail3(rset.getString(16));
            vo.setInsc_estadual_rg(rset.getString(17));
            vo.setInsc_municipal(rset.getString(18));
            vo.setObservacao(rset.getString(19));

            vo.setUf(rset.getInt(20));

            list.add(vo);
        }
        return new VOListResponse(list, false, list.size());
    } catch (SQLException ex) {
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            stmt.close();
        } catch (SQLException ex1) {
            System.out.print("Erro: " + ex1);
        }
    }

}

// apagar o registro
public Response deleteRecord(ArrayList persistentObjects) throws Exception {

    PreparedStatement stmt = null;


    try {

        stmt = conn.prepareStatement("delete from CLIENTE where auto=?");

        for (int i = 0; i < persistentObjects.size(); i++) {

            CadCliVO vo = (CadCliVO) persistentObjects.get(i);
            stmt.setString(1, vo.getAuto().toString());
            stmt.execute();

        }
        return new VOResponse(true);

    } catch (SQLException ex) {
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            stmt.close();
            conn.commit();
        } catch (SQLException ex1) {
        }
    }
}

}
[/code]

Ele imprime isso:

[code]run:
Conectando com o banco de dados . . .

  • Conexão realizada com sucesso
    The resource ‘closemnemonic’ is not defined.
    The resource ‘drag’ is not defined.
    The resource ‘Autonumeração’ is not defined.
    The resource ‘Razão Social’ is not defined.
    The resource ‘CPF/CNPJ’ is not defined.
    The resource ‘Tel. 1’ is not defined.
    The resource ‘Tel. 2’ is not defined.
    The resource ‘Tel. 3’ is not defined.
    The resource ‘Nome Fantasia’ is not defined.
    The resource ‘CEP’ is not defined.
    The resource ‘Tipo Lagradouro’ is not defined.
    The resource ‘Logradouro’ is not defined.
    The resource ‘Complemento’ is not defined.
    The resource ‘Bairro’ is not defined.
    The resource ‘Cidade’ is not defined.
    The resource ‘E-Mail 1’ is not defined.
    The resource ‘E-Mail 2’ is not defined.
    The resource ‘E-Mail 3’ is not defined.
    The resource ‘Insc. Estad. / RG’ is not defined.
    The resource ‘Insc. Municipal’ is not defined.
    The resource ‘Observação’ is not defined.
    The resource ‘UF’ is not defined.
    The resource ‘sorting conditions’ is not defined.
    Entrou no cliente Facade, criou um cadCliController
    Entrou no load data
    Entrou no try
    Executando o Statement
    SELECT c.auto, c.razao_social, c.cpf_cnpj, c.tel_cont1, c.tel_cont2, c.tel_cont3, c.nome_fantasia, c.cep, c.tipo_logradouro, c.logradouro, c.complemento, c.bairro, c.cidade, c.email1, c.email2, c.email3, c.insc_estadual_rg, c.insc_municipal, c.observacao, c.uf FROM cliente c ;


Mon Mar 19 11:24:18 BRT 2012 [ERROR]
in org.openswing.swing.table.client.Grids.loadData():
Error while fetching data.
java.lang.NullPointerException
at br.com.controllers.CadCliController.loadData(CadCliController.java:189)
at org.openswing.swing.table.client.Grids.loadData(Grids.java:1794)
at org.openswing.swing.table.client.Grids.access$800(Grids.java:58)
at org.openswing.swing.table.client.Grids$LoadDataThread.run(Grids.java:4064)


The resource ‘ok’ is not defined.
The resource ‘drag’ is not defined.
The resource ‘Autonumeração’ is not defined.
The resource ‘Razão Social’ is not defined.
The resource ‘CPF/CNPJ’ is not defined.
The resource ‘Tel. 1’ is not defined.
The resource ‘Tel. 2’ is not defined.
The resource ‘Tel. 3’ is not defined.
The resource ‘Nome Fantasia’ is not defined.
The resource ‘CEP’ is not defined.
The resource ‘Tipo Lagradouro’ is not defined.
The resource ‘Logradouro’ is not defined.
The resource ‘Complemento’ is not defined.
The resource ‘Bairro’ is not defined.
The resource ‘Cidade’ is not defined.
The resource ‘E-Mail 1’ is not defined.
The resource ‘E-Mail 2’ is not defined.
The resource ‘E-Mail 3’ is not defined.
The resource ‘Insc. Estad. / RG’ is not defined.
The resource ‘Insc. Municipal’ is not defined.
The resource ‘Observação’ is not defined.
The resource ‘UF’ is not defined.
The resource ‘sorting conditions’ is not defined.
Entrou no cliente Facade, criou um cadCliController
Entrou no load data
Entrou no try
Executando o Statement
SELECT c.auto, c.razao_social, c.cpf_cnpj, c.tel_cont1, c.tel_cont2, c.tel_cont3, c.nome_fantasia, c.cep, c.tipo_logradouro, c.logradouro, c.complemento, c.bairro, c.cidade, c.email1, c.email2, c.email3, c.insc_estadual_rg, c.insc_municipal, c.observacao, c.uf FROM cliente c ;


Mon Mar 19 11:26:41 BRT 2012 [ERROR]
in org.openswing.swing.table.client.Grids.loadData():
Error while fetching data.
java.lang.NullPointerException
at br.com.controllers.CadCliController.loadData(CadCliController.java:189)
at org.openswing.swing.table.client.Grids.loadData(Grids.java:1794)
at org.openswing.swing.table.client.Grids.access$800(Grids.java:58)
at org.openswing.swing.table.client.Grids$LoadDataThread.run(Grids.java:4064)


The resource ‘ok’ is not defined.
[/code]

Alguem tem ideia do que é ?

Oq tem nessa linha?
at br.com.controllers.CadCliController.loadData(CadCliController.java:189)

Esse cara “stmt” está null. Esse é seu erro. Vc está inicializando ele corretamente?

Assim:


PreparedStatement stmt = null;

Meio confuso? ajudei em alguma coisa?