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.wrappedconnectionj...@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
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user