Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates
 209.85.192.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAP=qHCu1_J52fof3X4ZHw8zWB56E7ucfp=8FFzb9yxayTD4Z0g@mail.gmail.com>
References: 
 <CA+KtLoaui76Zzq50xGm7iwJb7PpBwW=cP0O9Gr9PR1OtxaX=Dw@mail.gmail.com>
 <CAP=qHCu1_J52fof3X4ZHw8zWB56E7ucfp=8FFzb9yxayTD4Z0g@mail.gmail.com>
From: Kevin Sutter <kwsutter@gmail.com>
Date: Tue, 29 Jul 2014 11:02:35 -0500
Message-ID: 
 <CABH8er=C8fNJxD1974dNwabQ=H3A3mfnnhiBurQVqNEaYrRVmA@mail.gmail.com>
Subject: Re: MariaDB vs. MySQL
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=001a113a22ba2c6a5b04ff572cf3

--001a113a22ba2c6a5b04ff572cf3
Content-Type: text/plain; charset=UTF-8

Marc,
What jdbc drivers are you using with each database type?  And, are you
letting OpenJPA determine the DBDictionary to use or are you explicitly
declaring it in your persistence.xml?  What version of OpenJPA are you
using?

The MariaDBDictionary is an almost identical copy of the
MySQLDBDictionary.   Just to make the configuration easier.  But, I did
notice that there are some checks on the metadata version on the connection
that could affect the generation of some certain SQL...

Let us know what you find out.  Thanks.

Kevin


On Thu, Jul 24, 2014 at 8:24 PM, Rick Curtis <curtisr7@gmail.com> wrote:

> 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 <marc.logemann@gmail.com>
> wrote:
>
> > 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. Is
> > this possible at all?
> >
> > Thanks for infos.
> >
>
>
>
> --
> *Rick Curtis*
>

--001a113a22ba2c6a5b04ff572cf3--