You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@openjpa.apache.org by Marc Logemann <ma...@gmail.com> on 2014/07/24 23:05:56 UTC

MariaDB vs. MySQL

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.

Re: MariaDB vs. MySQL

Posted by Kevin Sutter <kw...@gmail.com>.

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 <cu...@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 <ma...@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*
>

Re: MariaDB vs. MySQL

Posted by Rick Curtis <cu...@gmail.com>.

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 <ma...@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*