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

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...] with stack traces), Postgres ([failed tests|https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/infinispan-jpa...]) and MsSQL ([failed tests|https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/infinispan-jpa...]). 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.