[infinispan-issues] [JBoss JIRA] (ISPN-4061) JPA Cache Store fails on Oracle, Postgres and MsSQL

[Vojtech Juranek (JIRA)]

Vojtech Juranek created ISPN-4061:
-------------------------------------

             Summary: JPA Cache Store fails on Oracle, Postgres and MsSQL
                 Key: ISPN-4061
                 URL: https://issues.jboss.org/browse/ISPN-4061
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
            Reporter: Vojtech Juranek
            Assignee: Dan Berindei


Current snapshot version of JPA Cache Store fails on Oracle (see [failed tests|https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/infinispan-jpa-tests-dballoc-vjuranek/15/testngreports/] with stack traces), Postgres ([failed tests|https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/infinispan-jpa-tests-dballoc-vjuranek/16/testngreports/]) and MsSQL ([failed tests|https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/infinispan-jpa-tests-dballoc-vjuranek/17/testngreports/]).

While in case of Oracle and Postgres the problem is probably in {{\_\_ispn_metadata__}} table, in case of MsSQL problem is in "User" entity, as User is reserved name in MySQL. In case of MySQL I'm not completely sure if it's bug or if it should be handled by user, but IMHO it should be considered as a bug, as JPA/Hibernate should provide DB agnostic interface and handle such cases.

Besides that {{VARBINARY}} type used in {{\_\_ispn_metadata__}} is not available in Postgres.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira