Re: MariaDB vs. MySQL

2014-07-24 Thread Rick Curtis
I haven't seen any MariaDB specific problems reported on this list yet... can you explain a bit better what you're observing? Thanks, Rick On Thu, Jul 24, 2014 at 4:05 PM, Marc Logemann wrote: > Hi, > > i am fighting weird issues with an openjpa application on MariaDB while all > these are non

MariaDB vs. MySQL

2014-07-24 Thread Marc Logemann
Hi, i am fighting weird issues with an openjpa application on MariaDB while all these are non existant on MySQL. Things like "fetch join" are just different or better said with openjpa 2.2.0 and MariaDB problematic in some JPQLs. I even see different SQLs being created from the same JPAQL Queries

Re: Create H2 database even before adding records

2014-07-24 Thread Kalpa Welivitigoda
It's apache-tomee-plus-1.6.0.2 I have my data source defined in context.xml and persistence.xml refers it via JNDI. I present you briefly with my setup hoping it will help you to figure out what's wrong. I'll provide you with the source code if you want further analysis. I have the Order Entity.

Re: Create H2 database even before adding records

2014-07-24 Thread Rick Curtis
Hrmm, odd. What version of TomEE are you using? On Thu, Jul 24, 2014 at 12:25 AM, Kalpa Welivitigoda wrote: > Well it worked for me for some reason which I don't know. Yes your point is > valid, it is a JPA 2.1 property and OpenJPA support JPA 2.0. > > I observed the following, > > Without any

Re: JPQL and DB2 native code

2014-07-24 Thread Guilherme Ferreira
Christophe Marcourt writes: > > Hi Kevin, > > yes I'm using temporal data from DB2 . > I'm already querying DB2 in SQL native and I had to do a "mapper" for my > entities as my DAO is a generic one. Quite tough. My problem is the > Inheritance annotation for the joined strategy. In JPA it's a