Menu
▾
▴
[jboss-cvs] jbossmq/src/etc/server/examples/deploy postgres-jdbc2-service.xml mssql-jdbc2-service.xml oracle-jdbc2-service.xml sybase-jdbc2-service.xml mysql-jdbc2-service.xml
|
From: Adrian B. <ej...@us...> - 2004-07-15 21:05:02
|
User: ejort
Date: 04/07/15 14:04:51
Modified: src/etc/server/examples/deploy postgres-jdbc2-service.xml
mssql-jdbc2-service.xml oracle-jdbc2-service.xml
sybase-jdbc2-service.xml mysql-jdbc2-service.xml
Log:
Port the helper index from 3.2
Revision Changes Path
1.7 +2 -1 jbossmq/src/etc/server/examples/deploy/postgres-jdbc2-service.xml
Index: postgres-jdbc2-service.xml
===================================================================
RCS file: /cvsroot/jboss/jbossmq/src/etc/server/examples/deploy/postgres-jdbc2-service.xml,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- postgres-jdbc2-service.xml 9 May 2004 00:05:25 -0000 1.6
+++ postgres-jdbc2-service.xml 15 Jul 2004 21:04:50 -0000 1.7
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- $Id: postgres-jdbc2-service.xml,v 1.6 2004/05/09 00:05:25 ejort Exp $ -->
+<!-- $Id: postgres-jdbc2-service.xml,v 1.7 2004/07/15 21:04:50 ejort Exp $ -->
<server>
@@ -66,6 +66,7 @@
DELETE_TEMPORARY_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXOP='T'
DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB BYTEA, PRIMARY KEY (MESSAGEID, DESTINATION))
+ CREATE_MESSAGE_IDX_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES (TXOP, TXID)
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
CREATE_TABLES_ON_STARTUP = TRUE
</attribute>
1.6 +2 -1 jbossmq/src/etc/server/examples/deploy/mssql-jdbc2-service.xml
Index: mssql-jdbc2-service.xml
===================================================================
RCS file: /cvsroot/jboss/jbossmq/src/etc/server/examples/deploy/mssql-jdbc2-service.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- mssql-jdbc2-service.xml 9 May 2004 00:05:26 -0000 1.5
+++ mssql-jdbc2-service.xml 15 Jul 2004 21:04:50 -0000 1.6
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- $Id: mssql-jdbc2-service.xml,v 1.5 2004/05/09 00:05:26 ejort Exp $ -->
+<!-- $Id: mssql-jdbc2-service.xml,v 1.6 2004/07/15 21:04:50 ejort Exp $ -->
<server>
@@ -67,6 +67,7 @@
DELETE_TEMPORARY_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXOP='T'
DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB IMAGE, PRIMARY KEY (MESSAGEID, DESTINATION))
+ CREATE_MESSAGE_IDX_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES (TXOP, TXID)
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
CREATE_TABLES_ON_STARTUP = TRUE
</attribute>
1.6 +2 -1 jbossmq/src/etc/server/examples/deploy/oracle-jdbc2-service.xml
Index: oracle-jdbc2-service.xml
===================================================================
RCS file: /cvsroot/jboss/jbossmq/src/etc/server/examples/deploy/oracle-jdbc2-service.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- oracle-jdbc2-service.xml 9 May 2004 00:05:26 -0000 1.5
+++ oracle-jdbc2-service.xml 15 Jul 2004 21:04:50 -0000 1.6
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- $Id: oracle-jdbc2-service.xml,v 1.5 2004/05/09 00:05:26 ejort Exp $ -->
+<!-- $Id: oracle-jdbc2-service.xml,v 1.6 2004/07/15 21:04:50 ejort Exp $ -->
<server>
@@ -65,6 +65,7 @@
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )
+ CREATE_MESSAGE_IDX_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES (TXOP, TXID)
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER )
CREATE_TABLES_ON_STARTUP = TRUE
</attribute>
1.3 +22 -21 jbossmq/src/etc/server/examples/deploy/sybase-jdbc2-service.xml
Index: sybase-jdbc2-service.xml
===================================================================
RCS file: /cvsroot/jboss/jbossmq/src/etc/server/examples/deploy/sybase-jdbc2-service.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- sybase-jdbc2-service.xml 9 May 2004 00:05:26 -0000 1.2
+++ sybase-jdbc2-service.xml 15 Jul 2004 21:04:50 -0000 1.3
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- $Id: sybase-jdbc2-service.xml,v 1.2 2004/05/09 00:05:26 ejort Exp $ -->
+<!-- $Id: sybase-jdbc2-service.xml,v 1.3 2004/07/15 21:04:50 ejort Exp $ -->
<server>
@@ -50,26 +50,27 @@
name="jboss.mq:service=PersistenceManager">
<depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=jdbc/SybaseDB</depends>
<attribute name="SqlProperties">
- BLOB_TYPE=BYTES_BLOB
- INSERT_TX = INSERT INTO dbo.JMS_TRANSACTIONS (TXID) values(?)
- INSERT_MESSAGE = INSERT INTO dbo.JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)
- SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM dbo.JMS_TRANSACTIONS
- SELECT_MAX_TX = SELECT MAX(TXID) FROM dbo.JMS_MESSAGES
- SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM dbo.JMS_MESSAGES WHERE DESTINATION=?
- SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM dbo.JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
- MARK_MESSAGE = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?
- UPDATE_MESSAGE = UPDATE dbo.JMS_MESSAGES SET MESSAGEBLOB=? WHERE MESSAGEID=? AND DESTINATION=?
- UPDATE_MARKED_MESSAGES = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=?
- UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID=?
- DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM dbo.JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM dbo.JMS_TRANSACTIONS) AND TXOP=?
- DELETE_TX = DELETE FROM dbo.JMS_TRANSACTIONS WHERE TXID = ?
- DELETE_MARKED_MESSAGES = DELETE FROM dbo.JMS_MESSAGES WHERE TXID=? AND TXOP=?
- DELETE_TEMPORARY_MESSAGES = DELETE FROM dbo.JMS_MESSAGES WHERE TXOP='T'
- DELETE_MESSAGE = DELETE FROM dbo.JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
- 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) )
- CREATE_TX_TABLE = CREATE TABLE dbo.JMS_TRANSACTIONS ( TXID INTEGER )
+ BLOB_TYPE=BYTES_BLOB
+ INSERT_TX = INSERT INTO dbo.JMS_TRANSACTIONS (TXID) values(?)
+ INSERT_MESSAGE = INSERT INTO dbo.JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)
+ SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM dbo.JMS_TRANSACTIONS
+ SELECT_MAX_TX = SELECT MAX(TXID) FROM dbo.JMS_MESSAGES
+ SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM dbo.JMS_MESSAGES WHERE DESTINATION=?
+ SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM dbo.JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
+ MARK_MESSAGE = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?
+ UPDATE_MESSAGE = UPDATE dbo.JMS_MESSAGES SET MESSAGEBLOB=? WHERE MESSAGEID=? AND DESTINATION=?
+ UPDATE_MARKED_MESSAGES = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=?
+ UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE dbo.JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID=?
+ DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM dbo.JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM dbo.JMS_TRANSACTIONS) AND TXOP=?
+ DELETE_TX = DELETE FROM dbo.JMS_TRANSACTIONS WHERE TXID = ?
+ DELETE_MARKED_MESSAGES = DELETE FROM dbo.JMS_MESSAGES WHERE TXID=? AND TXOP=?
+ DELETE_TEMPORARY_MESSAGES = DELETE FROM dbo.JMS_MESSAGES WHERE TXOP='T'
+ DELETE_MESSAGE = DELETE FROM dbo.JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
+ 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) )
+ CREATE_MESSAGE_IDX_TXOP_TXID = CREATE INDEX dbo.JMS_MESSAGES_TXOP_TXID ON dbo.JMS_MESSAGES (TXOP, TXID)
+ CREATE_TX_TABLE = CREATE TABLE dbo.JMS_TRANSACTIONS ( TXID INTEGER )
</attribute>
</mbean>
</server>
1.7 +2 -1 jbossmq/src/etc/server/examples/deploy/mysql-jdbc2-service.xml
Index: mysql-jdbc2-service.xml
===================================================================
RCS file: /cvsroot/jboss/jbossmq/src/etc/server/examples/deploy/mysql-jdbc2-service.xml,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- mysql-jdbc2-service.xml 9 May 2004 00:05:26 -0000 1.6
+++ mysql-jdbc2-service.xml 15 Jul 2004 21:04:50 -0000 1.7
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- $Id: mysql-jdbc2-service.xml,v 1.6 2004/05/09 00:05:26 ejort Exp $ -->
+<!-- $Id: mysql-jdbc2-service.xml,v 1.7 2004/07/15 21:04:50 ejort Exp $ -->
<server>
@@ -66,6 +66,7 @@
DELETE_TEMPORARY_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXOP='T'
DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
+ CREATE_MESSAGE_IDX_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES (TXOP, TXID)
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
CREATE_TABLES_ON_STARTUP = TRUE
</attribute>
|