Posted this in wrong forum last time accidently

[nchristy]

Ok, this seems to be a re-occuring problem that no-one can answer. I have a swing app, that has a second thread to do long tedious retrievals so as not to tie up my gui.

I have a facade class that has a getAllProducts() method. This method implements a cache layer that looks similiar to this:

public List<Product> getAllProducts&#40;&#41; &#123;
   if&#40;allProducts == null&#41; &#123;
        allProducts = new ArrayList<Product>&#40;&#41;;
        allProducts = dao.getAllProducts&#40;&#41;;
   &#125;
   return allProducts;
&#125;

This enables me to only retrieve the products one time. Now, within my spawned thread that does long updates, I need to access these products similiar to:

                for (MarketingResponsibility resp : facade
                        .getAllMarketingResponsibility()) {
                    try {
                        products = facade.getProducts(resp);
                        reports = createReports(products);
                        runExport(fileLocation + resp.getMktgRespDesc());
                    } catch (NoDataFoundException ndfe) {/**/
                    }

                }

This is causing a lazilyinitialization error, and I don't undestand why because the session never gets closed.

    private void runExport(String location) throws NoDataFoundException{
        application.startSession();
// this is the call that spawns the new thread
        processManager.runExport(false,location);
// this does some GUI stuff while the export is running
        monitorProgress();
        facade.deleteAllPriceImpactData();
        facade.deleteAllPricesAndCostData();
        application.endSession();
    }



    public int startSession() throws TransactionException {
        try {
            log.warn("getting session");
            HibernateSession.currentSession(appContext);
            return 1;
        } catch (HibernateException he) {
            log.error("cant get session");
            throw new TransactionException();
        }
    }

    public void endSession() throws TransactionException {
        try {
            log.warn("ending session");
            HibernateSession.closeSession();
        } catch (HibernateException he) {
            log.error("cant close session");
            throw new TransactionException();
        }
    }

here is how i am handling my sessions

public class Application {
public int startSession() throws TransactionException {
      try {
            log.warn("getting session");
            HibernateSession.currentSession(appContext);
            return 1;
        } catch (HibernateException he) {
            log.error("cant get session");
            throw new TransactionException();
        }
    }

    /**
     *
     * @return boolean
     */
    public boolean isSessionOpen() {
        return HibernateSession.isSessionOpen();
    }

    /**
     *
     * @throws TransactionException
     */
    public void endSession() throws TransactionException {
        try {
            log.warn("ending session");
            HibernateSession.closeSession();
        } catch (HibernateException he) {
            log.error("cant close session");
            throw new TransactionException();
        }
    }





public class HibernateSession {

    /**
     *
     */
    public static final ThreadLocal<Session> session = new ThreadLocal<Session>&#40;&#41;;

    private static SessionFactory sessionFactory;

    /**
     * Get the current Session or create a new sesion is none exists
     *
     * @param appContext
     * @return Session
     * @throws HibernateException
     */
    public static Session currentSession&#40;ApplicationContext appContext&#41;
            throws HibernateException &#123;
        Session s = session.get&#40;&#41;;
        if &#40;s == null&#41; &#123;
            sessionFactory = &#40;SessionFactory&#41; appContext
                    .getBean&#40;"sessionFactory"&#41;;
            s = sessionFactory.openSession&#40;&#41;;
            session.set&#40;s&#41;;
            if &#40;!TransactionSynchronizationManager.getResourceMap&#40;&#41;
                    .containsKey&#40;sessionFactory&#41;&#41; &#123;
                TransactionSynchronizationManager.bindResource&#40;sessionFactory,
                        new SessionHolder&#40;s&#41;&#41;;
            &#125;
        &#125;

        return s;
    &#125;

    /**
     *
     * @return boolean
     */
    public static boolean isSessionOpen&#40;&#41; &#123;
        return &#40;session.get&#40;&#41; != null&#41;;
    &#125;

    /**
     * Close the current Session
     *
     * @throws HibernateException
     */
    public static void closeSession&#40;&#41; throws HibernateException &#123;

        Session s = session.get&#40;&#41;;
        session.set&#40;null&#41;;
        if &#40;s == null&#41;
            System.err.println&#40;"big problem"&#41;;
        if &#40;s != null&#41; &#123;

            s.flush&#40;&#41;;

            TransactionSynchronizationManager.unbindResource&#40;sessionFactory&#41;;
            SessionFactoryUtils.closeSessionIfNecessary&#40;s, sessionFactory&#41;;
        &#125;

    &#125;

&#125;

Any thoughts or suggestions would be a huge help

-Nick
http://www.nickchristy.blogspot.com

[nchristy]

problem solved. The issue was not with spring, nor hibernate, i was using SwingWorker incorrectly by placing "executable" code within a constructor rather then within the construct() method, the session was not opening correctly because of this, which was causing the Lazy exception