Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (nike.apache.org: domain of ncjfranken@gmail.com designates
 74.125.83.42 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=subject:from:to:in-reply-to:references:content-type:date:message-id
         :mime-version:x-mailer:content-transfer-encoding;
        b=Lt0IPuldiV744wzgrUj7CqmK+rUgWrWqqi07dXjKAo7Bo81m0lB+bIFafl7VdawlcE
         aDyqIIE/TzdcAdG1yacj7Cc9WjW6GmUcTpZjTNDQHMyik8rgfvvf1lcCoIlwZMGC34nT
         at8q6o1DELU2Nm6iTy/YsU5lzJW3ZT1g+yFe0=
Subject: Re: AW: I need to pick your brains....
From: Neil Franken <ncjfranken@gmail.com>
To: user@geronimo.apache.org
In-Reply-To: <01E7E8E50C98824E9045DFD5FFC859D4CEA3245E@SBSRV.ot.local>
References: <AANLkTikJrAGbOyayevz3tMTkTrHo91Ss1ygQc=zfTUpg@mail.gmail.com>
	 <2468FBAA-2432-42EA-96AA-AD42B1221A8D@gmail.com>
	 <1298962406.19171.6.camel@namphibian>
	 <04B3D1E3-D856-44D3-AA47-EB77F0561AA0@yahoo.com>
	 <01E7E8E50C98824E9045DFD5FFC859D4CEA3245E@SBSRV.ot.local>
Content-Type: text/plain; charset="UTF-8"
Date: Tue, 01 Mar 2011 11:31:28 +0200
Message-ID: <1298971888.19171.45.camel@namphibian>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

Hi Micheal.

Well maybe you can help me then. The only stumbling block I have with
EclipseLink is the fact that whenever I update/delete data and I do a
em.flush it complains about it not being in a transaction. Now my
persistence.xml file is setup  as follows:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
	<persistence-unit name="cnectdDAL" transaction-type="JTA">

<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
		<jta-data-source>jdbc/cnectd</jta-data-source>
		<class>com.cnectd.dal.MimeType</class> 
		<class>com.cnectd.dal.MimeTypePK</class>
	<exclude-unlisted-classes>false</exclude-unlisted-classes>
		
	</persistence-unit>
</persistence>

This means I am running Container Managed Transactions. So why would it
complain about it not being in a transaction? I have googled this error
and cannot find anything to help me.

I did deploy the eclipselink.jar file to geronimo via the admin console.

Any ideas?

Regards
Neil


On Tue, 2011-03-01 at 09:54 +0100, Michael Simons wrote:
> Hi Neil,
> 
> We faced a similar situation like you a little time ago. We used a JDO-Implementation but there's no AppSrv supporting it. So we had to port to JPA. After some evaluation (and some severe problems with OpenJPA) we decided to use Geronimo with EclipseLink. So far it works quite well. So IMHO you don't need to port code from EL to OpenJPA but just use EL within Geronimo. 
> You say, that you need "to reduce the load on the MySQL servers". We also used a lot of time to reduce the load on the database server as well as on the AppSrv. IMHO you should still take plain old SQL/JDBC into account, as sometimes this might be the best choice to reduce load and improve performance.
> 
> Kind Regards, Michael
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: David Jencks [mailto:david_jencks@yahoo.com] 
> Gesendet: Dienstag, 1. März 2011 09:32
> An: user@geronimo.apache.org
> Betreff: Re: I need to pick your brains....
> 
> Hi Neil,
> 
> As far as I know openJPA and EclipseLink are both really good JPA implementations.  I wasn't aware that either one provided data caching without add on products, but I'm not an expert in either product.  In geronimo you are probably more likely to be able to find help using openjpa because the geronimo developers know it better and openjpa is another apache project.  Other than that guess I don't have much advice on a choice.
> 
> thanks
> david jencks
> 
> On Feb 28, 2011, at 10:53 PM, Neil Franken wrote:
> 
> > Hi All
> > 
> > I need some help to make up my mind about what technologies to use in my
> > project. Now there is going to be some rather newbie questions in here
> > but I need some input from people that work with the technology.
> > 
> > Here is my problem. We are doing a project that requires us to use JPA.
> > Now I need the JPA to be able to cache data to reduce the load on the
> > MySQL servers. So over the last couple of days I have been doing a lot
> > of porting of code from a Glassfish v3 and eclipselink project to
> > Geronimo. 
> > 
> > However going through the documentation I had a look a OpenJPA as well.
> > It seems that openJPA is also a very good product.... so my main
> > question is.
> > 
> > Which one is better to use in Geronimo.I know OpenJPA is allready
> > available in Geronimo and from what I can find on the internet it seems
> > to be a viable alternative to EclipseLink.
> > 
> > So can anyone here shed some light on the choice I have to make? Seems
> > like Java programmers in South Africa just use JDBC so finding someone
> > to have a decent discussion about JPA/ORM Frameworks leads nowhere fast.
> > 
> > Regards
> > Neil
> > 
>