[jboss-jira] [JBoss JIRA] Commented: (JBMESSAGING-1480) Specify Lock datarow on Sybase create tables

[Clebert Suconic (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBMESSAGING-1480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12445607#action_12445607 ] 

Clebert Suconic commented on JBMESSAGING-1480:
----------------------------------------------

It looks like we will need to provide two versions of the file. One for the basic Sybase, and another for the Enterprise Sybase?

It would be better to minimize the number of versions though.

> Specify Lock datarow on Sybase create tables
> --------------------------------------------
>
>                 Key: JBMESSAGING-1480
>                 URL: https://jira.jboss.org/jira/browse/JBMESSAGING-1480
>             Project: JBoss Messaging
>          Issue Type: Feature Request
>    Affects Versions:  1.4.0.SP3.CP04
>            Reporter: Clebert Suconic
>            Assignee: Howard Gao
>             Fix For: 1.4.0.SP3.CP05, 1.4.3.GA
>
>
> Some users were complaining about dead locks on sybase with JBossMessaging.
> That trully is a config issue on sybase, but to avoid that maybe we should specify the lock schema at create table level, as shown on this doc.
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20021_1251/html/locking/X33666.htm

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira