Not sure where in the Wiki this should go? As Adrian indicates, (no locking in excess of) row level locking is a requirement no matter what the database. To make that more explicit, the SQL in the /docs/examples/jms/sybase-jdbc2-service.xml should probably be changed to add in the LOCK DATAROWS clauses on the following create statements:
| CREATE_MESSAGE_TABLE = CREATE TABLE dbo.JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \ | DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER NULL, TXOP CHAR(1), \ | MESSAGEBLOB IMAGE, PRIMARY KEY (MESSAGEID, DESTINATION) ) LOCK DATAROWS | | | | CREATE_TX_TABLE = CREATE TABLE dbo.JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) ) \ | LOCK DATAROWS | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3864492#3864492 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3864492 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
