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:[email protected]] Gesendet: Dienstag, 1. März 2011 09:32 An: [email protected] 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 >
