S:Envelope xmlns:S=“http://schemas.xmlsoap.org/soap/envelope/”>
<S:Body>
<S:Fault xmlns:ns4=“http://www.w3.org/2003/05/soap-envelope”>
S:Server
java.lang.NullPointerException
</S:Fault>
</S:Body>
</S:Envelope>
Código Fonte
@WebService(serviceName = “WsCalibra”)
public class WsCalibra {
CallableStatement consultar;
CallableStatement insert;
private Statement stmt;
private ResultSet rs;
String sql;
String Mensagem;
@WebMethod(operationName = "WsConsultar")
public boolean WsConsultar(@WebParam(name = "Carreta1") String Carreta1, @WebParam(name = "Tipo") String Tipo, @WebParam(name = "CalibragemCarreta") int CalibragemCarreta) throws SQLException {
Connection conexao = null;
CtrlCalibra ctrlcalibra = new CtrlCalibra();
Calibra pneu = new Calibra();
ArrayList<Calibra>lista=new ArrayList<Calibra>();
try {
if (ConectarBD()) {
consultar = conexao.prepareCall("dbo.mtlConsulta");
stmt = conexao.createStatement();
sql = ("SELECT log_08Checklist.Carreta1, Tipo, log_08Checklist.CaligragemCarreta FROM MasterLink_CadastroGeral.dbo.CadCarreta INNER JOIN MasterLink_ControleDeLogistica.dbo.log_08Checklist ON MasterLink_CadastroGeral.dbo.CadCarreta.Carreta1 = log_08Checklist.Carreta1 WHERE"
+ "((CadCarreta.Carreta1 = @Carreta1) OR (@Carreta1 IS NULL)) AND "
+ "((Tipo LIKE '%' + @Tipo + '%') OR (@Tipo IS NULL))");
rs = stmt.executeQuery(sql);
while (rs.next()) {
consultar.setString(1, pneu.getCarreta1());
consultar.setString(2, pneu.getTipo());
consultar.setInt(1, pneu.getCalibragemCarreta());
lista.add(pneu);
System.out.println("Carreta : " + Carreta1);
System.out.println("Tipo : " + Tipo);
System.out.println("Calibragem : " + CalibragemCarreta);
}
stmt.execute(sql);
}
} catch (SQLException ex) {
setMensagem("Error de Sintaxe" + ex.getMessage());
}
return ctrlcalibra.ConsultarDados(pneu);
}