[infinispan-issues] [JBoss JIRA] (ISPN-4229) The JDBC Cache store should not require the schema name configuration

[Nicolas Filotto (JIRA)]

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

Nicolas Filotto commented on ISPN-4229:
---------------------------------------

Well it depends on what you have into the database and how the database manage the schemas. 
If you have only one schema that contains the tables of your cache store it is not an issue it will work properly on all db. 
If you use database like MySQL or PGSQL that scope all the commands to the current schema, you won't meet any issue even if you have several schemas that contain the tables of your cache store.
You will meet an issue on DB like Oracle for example, if you have several schemas that contain the tables of your cache store especially if the user account used  has enough rights to access to several schemas, because tableExists will return true but in fact you don't have anything in the current schema so it will fail later when we will add some data.
                
> The JDBC Cache store should not require the schema name configuration
> ---------------------------------------------------------------------
>
>                 Key: ISPN-4229
>                 URL: https://issues.jboss.org/browse/ISPN-4229
>             Project: Infinispan
>          Issue Type: Feature Request
>            Reporter: Mircea Markus
>            Assignee: Mircea Markus
>


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