[infinispan-issues] [JBoss JIRA] (ISPN-2675) Need way to use custom create table syntax

[Thomas Fromm (JIRA)]

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

Thomas Fromm commented on ISPN-2675:
------------------------------------

I'll investigate if its possible to change default behaviour of oracle anyhow before infinispan starts. So when I finished this, that I can say if this is important or its obsolete (since custom database api is anyway in planning).
                
> Need way to use custom create table syntax
> ------------------------------------------
>
>                 Key: ISPN-2675
>                 URL: https://issues.jboss.org/browse/ISPN-2675
>             Project: Infinispan
>          Issue Type: Feature Request
>          Components: Loaders and Stores
>    Affects Versions: 5.2.0.Beta6
>            Reporter: Thomas Fromm
>            Assignee: Mircea Markus
>             Fix For: 5.2.0.Final
>
>
> Currently with oracle and LOB as column type for cache value the LOB data are tried to store inline. This is expensive and a major performance issue (for me).
> Details to this: http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_2.shtml
> So I need for the 5.2 a way to provide custom create table syntax :-|
> Maybe a workaround could that I execute ALTER TABLE statement after cache startup, but then I need to check table attributes first if alter table statement is nessessary. Provide own create table statement is much easier. 

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