Re: [eclipselink-users] Spring: Attempting to execute an operation on a

["Tim Hollosy" <hollosyt@xxxxxxxxx>]

So no luck em.isOpen returns true.

I can't get my friggin AspectJ Weaver to output anything even though I
have an aop.xml like this:

<!DOCTYPE aspectj PUBLIC
"-//AspectJ//DTD//EN" "http://www.eclipse.org/aspectj/dtd/aspectj.dtd";>
<aspectj>
    <weaver options="-debug -verbose -showWeaveInfo
-XmessageHandlerClass:org.springframework.aop.aspectj.AspectJWeaverMessageHandler">
        <include within="com.redacted.*"/>
    </weaver>
     <aspects>
        <aspect
name="org.springframework.transaction.aspectj.AnnotationTransactionAspect"/>
    </aspects>
</aspectj>


BUT, doing some more reading about weaving I see: at
http://wiki.eclipse.org/EclipseLink/Examples/JPA/Tomcat_Web_Tutorial#Limitations_to_JPA

As Tomcat is not a JEE5 compatible server, there are some limitiations to JPA.

    * No dynamic weaving (instrumentation) - static weaving of
entities is still available via EclipseLink
    * No @EJB injection of a session bean (containing the
EntityManager) is available - use the persistence factory and manager
directly
    * No @PersistenceContext injection of a container managed
persistence unit is available - use
Persistence.createEntityManagerFactory(JTA_PU_NAME)


Does that mean i can't use the @PersistenceContext annotation with
EclipseLink in Tomcat 6???

I'm confused as to weather Tomcat 6 supports LTW or not, since there
are instructions all over for getting it to weave with Spring...

I may set up an OC4J Instance and see if I have better luck, but right
now I'm confused as all get out.

./tch



On Fri, Sep 26, 2008 at 6:58 AM, Tim Hollosy <hollosyt@xxxxxxxxx> wrote:
> Mohsen,
> I didn't actually call isOpen, I instead inspected it with the
> debugger, and noticed the isOpen boolean was true. I'll try your
> obvious suggestion when I get in to the office this morning.
>
> My hunch is something odd is going on with weaving, so I'm going to
> put some weaving logging in as well.
>
>
> I guess this is just growing pains and it doesn't always help when I
> choose bleeding edge -- pure annotations & eclipselink for my first
> foray into Spring -- but I just can't stand XML, so I've made my bed
> :)
>
> Thanks
>
> ./tch
>
>
>
> On Fri, Sep 26, 2008 at 6:54 AM, Mohsen Saboorian <mohsens@xxxxxxxxx> wrote:
>> I didn't test it with EclipseLink, but with Hibernate session is
>> closed after transaction is committed, and it produces a lot of
>> frustrations with lazy loading, since you usually need to fetch a list
>> after a transaction is committed.
>>
>> Spring provides a OpenSessionInViewFilter to work around this. It
>> keeps session open durig a request life-cycle.
>>
>> How did you verified that EM is open? EM.isOpen()?
>>
>> Mohsen.
>>
>> On Thu, Sep 25, 2008 at 9:58 PM, Tim Hollosy <hollosyt@xxxxxxxxx> wrote:
>>> I'm hoping some Spring gurus can help me out, whenever I try to
>>> execute a query I get the error: Attempting to execute an operation on
>>> a closed EntityManager.
>>>
>>> I'm using Spring 2.5 + Tomcat6.
>>>
>>> The weird thing is find's work fine. I'm launching tomcat with the
>>> spring-aspects.jar for weaving. I'm new to this whole spring web stuff
>>> so I am probably missing something, but the only thing I could find
>>> online was to make sure I have the @Transactional annotations used
>>> everywhere in my DAO class, which I do.
>>>
>>> If I run in the debugger it looks like the EM is open as well, so I'm
>>> kind of stumped. I suspect some weaving shenanigans, but I'm too much
>>> of a neophyte at this right now to debug much more.
>>>
>>> Many thanks :)
>>>
>>> Here's my config:
>>>
>>> applicationcontext.xml;
>>> <context:component-scan base-package="com.redacted" />
>>>
>>>        <tx:annotation-driven mode="aspectj"/>
>>>
>>>    <bean id="transactionManager"
>>> class="org.springframework.orm.jpa.JpaTransactionManager"
>>>          p:entityManagerFactory-ref="entityManagerFactory"/>
>>>
>>>        <bean id="dataSource"
>>>                class="org.apache.commons.dbcp.BasicDataSource">
>>>                <property name="driverClassName" value="oracle.jdbc.OracleDriver" />
>>>                <property name="url"
>>> value="jdbc:oracle:thin:@redacted:1521:redacted" />
>>>                <property name="username" value="redacted" />
>>>                <property name="password" value="redacted" />
>>>        </bean>
>>>
>>>        <bean id="jpaAdapter"
>>> class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter">
>>>   <property name="databasePlatform"
>>> value="org.eclipse.persistence.platform.database.oracle.OraclePlatform"
>>> />
>>>   <property name="showSql" value="true" />
>>> </bean>
>>>
>>>
>>>  <bean id="loadTimeWeaver"
>>> class="org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver"/>
>>>
>>>  <bean id="entityManagerFactory"
>>> class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
>>>       <property name="persistenceUnitName" value="ProofOConcept"/>
>>>       <property name="dataSource" ref="dataSource"/>
>>>       <property name="jpaVendorAdapter" ref="jpaAdapter"/>
>>>       <property name="loadTimeWeaver" ref="loadTimeWeaver"/>
>>>
>>>    </bean>
>>>
>>>        <util:list id="annotatedClasses">
>>>                <value>com.redacted.*</value>
>>>        </util:list>
>>>
>>>
>>> Here's my DAO class:
>>>
>>> import java.util.List;
>>>
>>> import javax.persistence.EntityManager;
>>> import javax.persistence.PersistenceContext;
>>> import javax.persistence.Query;
>>>
>>> import org.eclipse.persistence.jpa.JpaEntityManager;
>>> import org.eclipse.persistence.jpa.JpaHelper;
>>> import org.springframework.stereotype.Repository;
>>> import org.springframework.transaction.annotation.Transactional;
>>>
>>> @Transactional
>>> @Repository
>>> public class BasicDao {
>>>
>>>        @PersistenceContext(unitName = "ProofOConcept")
>>>        private EntityManager em;
>>>
>>>        @Transactional(readOnly = true)
>>>        public <T> T find(Class<T> entityClass, Object primaryKey) {
>>>                T result = em.find(entityClass, primaryKey);
>>>
>>>                return result;
>>>        }
>>>
>>>
>>>
>>>        @Transactional(readOnly = true)
>>>        public <T> List<T> selectAll(Class<T> clazz) {
>>>                JpaEntityManager jpaEm = JpaHelper.getEntityManager(em);
>>>                Query query = jpaEm.createQuery(null, clazz);
>>>                return (List<T>) query.getResultList();
>>>        }
>>>
>>> }
>>>
>>>
>>>
>>>
>>>
>>>
>>> ./tch
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>
>