Ajuda! OraCall Java executando procedures

Front-end
#1

Galera estou usando procedures porem agora estou usando conexao jndi com tomcat ai mudou muita coisa…

Esta dando diversos problemas…

Conexao

public void getConnection(){
        try{
        // Obtém a raiz da hierarquia de nomes
        InitialContext contexto = new InitialContext();
        // Obtém a origem dos dados
        DataSource ds = (DataSource)contexto.lookup("java:comp/env/jdbc/isdradsv");
        // Obtém uma conexão
        con = ds.getConnection();
        // Retorna a conexão
        }catch(Exception e){
            System.out.println("Erro na conexao " +e);
        }
        
    }

Persistencia

 try {              
        
                oraCallStmt = (OracleCallableStatement)((DelegatingCallableStatement)con.prepareCall(
                        
                 "{call svi.svi_pkg.insert_situacao_imovel(?,?,?,?)}"
            )).getDelegate();
            
            oraCallStmt.setInt(1, psituacaoImovel.getCdSituacao());
            oraCallStmt.setString(2, psituacaoImovel.getDeSituacao());
            oraCallStmt.registerOutParameter(1, OracleTypes.INTEGER);             
            oraCallStmt.registerOutParameter(3, OracleTypes.INTEGER);
            oraCallStmt.registerOutParameter(4, OracleTypes.VARCHAR);                                    
            oraCallStmt.execute();

            situacaoImovel.setCdSituacao(oraCallStmt.getInt(1));
            situacaoImovel.setPRetCodigo(oraCallStmt.getInt(3));
            situacaoImovel.setPRetMensagem(oraCallStmt.getString(4));
            
            oraCallStmt.close();
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return situacaoImovel;
    }

Erro

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

javax.servlet.ServletException: java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.DelegatingCallableStatement cannot be cast to org.apache.commons.dbcp.DelegatingCallableStatement
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause 

java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.DelegatingCallableStatement cannot be cast to org.apache.commons.dbcp.DelegatingCallableStatement
	com.isdra.imovel.service.PersistenciaSituacaoImovel.insertSituacaoImovel(PersistenciaSituacaoImovel.java:28)
	com.isdra.imovel.service.SituacaoImovelService.insertSituacaoImovel(SituacaoImovelService.java:14)
	com.isdra.svi.imovel.ManterSituacaoImovelAction.execute(ManterSituacaoImovelAction.java:37)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.

Como posso resolver isso?

#2

Resolvido…

Mudei todos os OracleCallStatement para CallStatement, e os OracleTypes para sqlTypes

#3