error : Closing a connection for you. Please close them yourself:

[leonardo ginting]

hi guys how could i getting this error "Closing a connection for you. Please close them yourself"

here is the full error

Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@3cf5d7d2
java.lang.Throwable: STACKTRACE
	at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:278)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:524)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
	at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)
	at id.co.compnet.dokim.transaksi.PersetujuanPengirimanMBean.simpan(PersetujuanPengirimanMBean.java:279)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:170)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
	at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
	at javax.faces.component.UICommand.broadcast(UICommand.java:387)
	at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
	at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
	at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
	at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
	at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
	at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295)
	at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393)
	at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:662)

its pointed out to my bean which is PersetujuanPengirimanMBean.java line 279
and here is my bean code

public void simpan() throws IllegalOrphanException, NonexistentEntityException, Exception {

        CompOffices office = getLogin().getOfficeId();
        Stok stok = new Stok();
        DetailPengirimanJpaController detailPengirimanCtl = new DetailPengirimanJpaController();
        pengirimanCtl = new PengirimanJpaController();
        
        //contact = contactVpApi.findContacts(getLogin().getContactId());
        except=false;
        logHelper = new Helper();
        Date createDate = new Date();
        
        EntityManager  em = null;
    //    em = (EntityManager) PersistenceManager.getInstance().getEntityManagerFactory();
        
        em =  pengirimanCtl.getEntityManager();

        em.getTransaction().begin(); // This Is Line 279
        try {
            if (flag == 1) {
                System.out.println("lokal "+pengiriman.getPengirimanid());
                if (isNoPermintaanExist()) {
                    error = true;
                    errorMessage = "Nomor Pengiriman sudah ada di Database";
                    hasilLaporan = false;
                    return;
                } else {
                    int officeType = pengiriman.getOfficeidtujuan().getOfficeType().intValue();
                    int officeIDTujuan = pengiriman.getOfficeidtujuan().getOfficeId().intValue();

                    //Update tabel inv_pengiriman
                    pengiriman.setStatus("1");
                    pengiriman.setNotransaksi(getNoTransaksi());
                    pengiriman.setDiubaholeh(getLogin().getContactId().intValue());
                    pengiriman.setTgldiubah(new Date());

                    if (officeType == 2 || officeType == 4 || officeIDTujuan == 3) // Pengiriman ke Kanwil, Subdit dan Direktorat Doklanvisfaskim
                    {
                        pengiriman.setSudahditerima("0");
                    } else {
                        pengiriman.setSudahditerima("1");
                    }

                    Pengiriman oldPengiriman = pengirimanCtl.findPengiriman(pengiriman.getPengirimanid());
//                pengirimanCtl.edit(pengiriman);
                    em.merge(pengiriman);

                    //Insert ke Log
                    logHelper.logInsert(appCode, "INV_PENGIRIMAN", "PENGIRIMANID=" + pengiriman.getPengirimanid().toString(), 3, "STATUS", logHelper.toString(oldPengiriman.getStatus()), logHelper.toString(pengiriman.getStatus()), createDate);
                    logHelper.logInsert(appCode, "INV_PENGIRIMAN", "PENGIRIMANID=" + pengiriman.getPengirimanid().toString(), 3, "NOTRANSAKSI", logHelper.toString(oldPengiriman.getNotransaksi()), logHelper.toString(pengiriman.getNotransaksi()), createDate);
                    logHelper.logInsert(appCode, "INV_PENGIRIMAN", "PENGIRIMANID=" + pengiriman.getPengirimanid().toString(), 3, "SUDAHDITERIMA", logHelper.toString(oldPengiriman.getSudahditerima()), logHelper.toString(pengiriman.getSudahditerima()), createDate);

                    //Update tabel inv_nomorseri dan insert tabel inv_riwayatnoseri
                    NomorSeriJpaController nomorSeriCtl = new NomorSeriJpaController();
                    RiwayatNoSeriJpaController riwayatNoSeriCtl = new RiwayatNoSeriJpaController();
                    for (DetailPengiriman d : detailPengirimanCtl.findPengirimanByPermintaan(pengiriman)) {
                        nomorSeriAwal = d.getNoseriawal();
                        nomorSeriAkhir = d.getNoseriakhir();

                        //Update tabel inv_stok
                        StokJpaController stokCtl = new StokJpaController();
                        stok = stokCtl.findStok(d.getDokimid(), office);
                        Long oldJumlahKirim = stok.getJumlahkirim();
                        if (stok.getJumlahkirim() == null) {
                            stok.setJumlahkirim(d.getJumlah().longValue());
                        } else {
                            stok.setJumlahkirim(stok.getJumlahkirim() + d.getJumlah().longValue());
                        }
//                    stokCtl.edit(stok);
                        em.merge(stok);

                        //Insert ke Log
                        logHelper.logInsert(appCode, "INV_STOK", "STOKID=" + stok.getStokid().toString(), 3, "JUMLAHKIRIM", logHelper.toString(oldJumlahKirim), logHelper.toString(stok.getJumlahkirim()), createDate);

                        if (d.getDokimid().getPunyanoseri().equals('1')) {
                            for (NomorSeri ns : nomorSeriCtl.findNomorSeriPengiriman(stok, nomorSeriAwal.toUpperCase(), nomorSeriAkhir.toUpperCase())) {
                                //NomorSeri nomorSeri = new NomorSeri();            
                                Integer oldStatus = ns.getStatus();
                                ns.setStatus(5);
//                            nomorSeriCtl.edit(ns);
                                em.merge(ns);
                                //Insert ke Log
                                logHelper.logInsert(appCode, "INV_NOMORSERI", "NOMORSERIID=" + ns.getNomorseriid().toString(), 3, "STATUS", logHelper.toString(oldStatus), logHelper.toString(ns.getStatus()), createDate);

                                RiwayatNoSeri riwayatNoSeri = new RiwayatNoSeri();
                                riwayatNoSeri.setDokimid(d.getDokimid());
                                riwayatNoSeri.setJenistransaksi("PENGIRIMAN");
                                riwayatNoSeri.setNoseri(ns.getNomorseri());
                                riwayatNoSeri.setNotransaksi(getNoTransaksi().toUpperCase());
                                riwayatNoSeri.setOfficeid(office);
                                riwayatNoSeri.setTanggal(new Date());
//                                riwayatNoSeriCtl.create(riwayatNoSeri);
                                em.persist(riwayatNoSeri);
                                //Insert ke Log
                                logHelper.logInsert(appCode, "INV_RIWAYATNOSERI", "RIWAYATID=" + riwayatNoSeri.getRiwayatid().toString(), 1, "RIWAYATID", "", logHelper.toString(riwayatNoSeri.getRiwayatid()), createDate);
                                logHelper.logInsert(appCode, "INV_RIWAYATNOSERI", "RIWAYATID=" + riwayatNoSeri.getRiwayatid().toString(), 1, "NOSERI", "", logHelper.toString(riwayatNoSeri.getNoseri()), createDate);

                            }
                        }
                    }
                }
            } else {
                System.out.println("LN "+pengirimanLN.getPengirimanid());
                //Update tabel inv_pengiriman
                pengirimanLN.setStatus("1");
                pengirimanLN.setSudahditerima("1");
                pengirimanLN.setNotransaksi(getNoTransaksi().toUpperCase());
                pengirimanLN.setDibuatoleh(getLogin().getContactId().intValue());
                pengirimanLN.setTgldiubah(new Date());

                PengirimanLN oldPengirimanLN = pengirimanLNCtl.findPengirimanLN(pengirimanLN.getPengirimanid());
//                pengirimanLNCtl.edit(pengirimanLN);
                em.merge(pengirimanLN);
                //Insert ke Log
                logHelper.logInsert(appCode, "INV_PENGIRIMANLN", "PENGIRIMANID=" + pengirimanLN.getPengirimanid().toString(), 3, "STATUS", logHelper.toString(oldPengirimanLN.getStatus()), logHelper.toString(pengirimanLN.getStatus()), createDate);
                logHelper.logInsert(appCode, "INV_PENGIRIMANLN", "PENGIRIMANID=" + pengirimanLN.getPengirimanid().toString(), 3, "SUDAHDITERIMA", logHelper.toString(oldPengirimanLN.getSudahditerima()), logHelper.toString(pengirimanLN.getSudahditerima()), createDate);
                logHelper.logInsert(appCode, "INV_PENGIRIMANLN", "PENGIRIMANID=" + pengirimanLN.getPengirimanid().toString(), 3, "NOTRANSAKSI", logHelper.toString(oldPengirimanLN.getNotransaksi()), logHelper.toString(pengirimanLN.getNotransaksi()), createDate);

                NomorSeriJpaController nomorSeriCtl = new NomorSeriJpaController();
                RiwayatNoSeriJpaController riwayatNoSeriCtl = new RiwayatNoSeriJpaController();
                DetailPengirimanLNJpaController detailPengirimanLNCtl = new DetailPengirimanLNJpaController();
                for (DetailPengirimanLN d : detailPengirimanLNCtl.findPengirimanLNByPermintaan(pengirimanLN)) {
//
                    StokJpaController stokCtl = new StokJpaController();
                    stok = stokCtl.findStok(d.getDokimid(), office);
                    nomorSeriAwal = d.getNoseriawal();
                    nomorSeriAkhir = d.getNoseriakhir();
                    for (NomorSeri ns : nomorSeriCtl.findNomorSeriPengiriman(stok, nomorSeriAwal.toUpperCase(), nomorSeriAkhir.toUpperCase())) {
                        //NomorSeri nomorSeri = new NomorSeri();            
                        Integer oldStatus = ns.getStatus();
                        ns.setStatus(2);
//                        nomorSeriCtl.edit(ns);
                        em.merge(ns);
                        //Insert ke Log
                        logHelper.logInsert(appCode, "INV_NOMORSERI", "NOMORSERIID=" + ns.getNomorseriid().toString(), 3, "STATUS", logHelper.toString(oldStatus), logHelper.toString(ns.getStatus()), createDate);

                        RiwayatNoSeri riwayatNoSeri = new RiwayatNoSeri();
                        riwayatNoSeri.setDokimid(d.getDokimid());
                        riwayatNoSeri.setJenistransaksi("PENGIRIMAN");
                        riwayatNoSeri.setNoseri(ns.getNomorseri().toUpperCase());
                        riwayatNoSeri.setNotransaksi(getNoTransaksi().toUpperCase());
                        riwayatNoSeri.setOfficeid(office);
                        riwayatNoSeri.setTanggal(new Date());
//                        riwayatNoSeriCtl.create(riwayatNoSeri);
                        em.persist(riwayatNoSeri);
                        //Insert ke Log
                        logHelper.logInsert(appCode, "INV_RIWAYATNOSERI", "RIWAYATID=" + riwayatNoSeri.getRiwayatid().toString(), 1, "RIWAYATID", "", logHelper.toString(riwayatNoSeri.getRiwayatid()), createDate);
                        logHelper.logInsert(appCode, "INV_RIWAYATNOSERI", "RIWAYATID=" + riwayatNoSeri.getRiwayatid().toString(), 1, "NOSERI", "", logHelper.toString(riwayatNoSeri.getNoseri()), createDate);
                    }
                }
            }
            em.flush();
            em.clear();
            em.getTransaction().commit();
            em.clear();
            System.out.println("selesai");
        } catch (Exception ex) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }

            System.out.println("error "+ex.getLocalizedMessage());
            System.out.println("error "+ex.getMessage());
            System.out.println("error "+ex.getCause());
//            throw ex;
            except=true;
            return;
        } finally {
            if (em != null) {
                em.close();
            }
        }
//   another code ...

i thought i've been close the transaction in finally but why im getting this
and it's happening when i want to insert transaction more than 200.000 row to database oracle
how could i resolve this issue please explain clearly because i'm a newbie
need your help master..

thanks in advance

regards