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

[Vojtech Juranek (JIRA)]

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

Vojtech Juranek updated ISPN-4061:
----------------------------------

    Description: 
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.

  was:
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.


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