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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989497#comment-12989497 ] 

RH Bugzilla Integration commented on ISPN-4061:
-----------------------------------------------

Martin Gencur <mgencur at redhat.com> changed the Status of [bug 1081398|https://bugzilla.redhat.com/show_bug.cgi?id=1081398] from NEW to VERIFIED

> 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
>      Security Level: Public(Everyone can see) 
>          Components: Loaders and Stores
>            Reporter: Vojtech Juranek
>            Assignee: Vojtech Juranek
>              Labels: 630, 630betablocker
>             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 was sent by Atlassian JIRA
(v6.2.6#6264)