[jboss-user] [Beginner's Corner] New message: "[CachedConnectionManager] Closing a connection for you"

[Ismael Fernandez]

User development,

A new message was posted in the thread "[CachedConnectionManager] Closing a connection for you":

http://community.jboss.org/message/527861#527861

Author  : Ismael Fernandez
Profile : http://community.jboss.org/people/i.fernandezmolina

Message:
--------------------------------------------------------------
Hi, I´m new in with JBoss Seam and I have a problem. I´m trying to call a Store Procedure with a CallableStatement. All the process works well, but when a finish, I have this error:
 
*[CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6 at 16add0e*
 
I think it´s due to not close the connection, but I always close them! This is my source code:
 
*Connection conn = null;
        CallableStatement stmt = null;
        Session sesion = null;
        boolean exito = true;
        String msj = null;
        int error = 0;
        
        try{
            
            sesion = (Session) em.getDelegate();
            conn = sesion.connection();
            
            stmt = conn.prepareCall("{call PCK_SINGLE_SIGN_ON.INSERT_SSO_TRABAJADOR(" + Utilidades.setNumParamsQuery(22) + ")}");
            stmt.registerOutParameter(1, OracleTypes.INTEGER);
            stmt.registerOutParameter(2, OracleTypes.VARCHAR);
            stmt.setString(3, identificador);
            stmt.setString(4, nombre);
            stmt.setString(5, apellido1);
            stmt.setString(6, apellido2);
            stmt.setString(7, getNombreCompleto());
            stmt.setString(8, nifDni);
            stmt.setString(9, Utilidades.getFechaDMA(fNacimiento));
            stmt.setString(10, idSsoDepartamento);
            stmt.setString(11, keydel);
            stmt.setString(12, telefono);
            stmt.setString(13, extension);
            stmt.setString(14, email);
            stmt.setString(15, direccion);
            stmt.setString(16, poblacion);
            stmt.setString(17, codigoPostal);
            stmt.setString(18, telefono2);
            stmt.setString(19, idSsoPuesto);
            stmt.setInt(20, 0);
            stmt.setString(21, identity.getUsername());
            stmt.setString(22, usuario);
                    
            stmt.execute();
            
            error = stmt.getInt(1);
            msj = stmt.getString(2);*
*
*
*            stmt.close();*
*            conn.close();
            
        }catch(Exception e){
            log.info(e.getMessage());
            exito = false;
        }finally{
            log.info(error + " " + msj);
        }*
 
 
Could this error be a bug? or, is there any solution?
 
Thank´s

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/527861#527861