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

[Tristan Tarrant (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tristan Tarrant updated ISPN-4061:
----------------------------------

           Status: Resolved  (was: Pull Request Sent)
         Assignee: Vojtech Juranek  (was: Dan Berindei)
    Fix Version/s: 7.0.0.Alpha2
                   7.0.0.Final
       Resolution: Done

    
> 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: Vojtech Juranek
>             Fix For: 7.0.0.Alpha2, 7.0.0.Final
>
>
> 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 MsSQL. Oracle has a problem with table starting with underscrore,   in case of Postgres {{VARBINARY}} type used in {{\_\_ispn_metadata\_\_}} is not available in. In case of MsSQL I'm not completely sure if it's bug or if it should be handled by user.

--
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