12:07 p.m.
Thanks Peter.
Sorry i totally forgot to post the version. JBoss4.2.2.GA with messaging 1.4.0.SP3.
|
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!--
| Hypersonic persistence deployment descriptor.
|
| DO NOT USE HYPERSONIC IN PRODUCTION or in a clustered environment- Hypersonic
does not have transaction isolation
|
| $Id: hsqldb-persistence-service.xml 3339 2007-11-16 20:48:08Z
clebert.suconic(a)jboss.com $
| -->
|
| <server>
|
| <!-- Persistence Manager MBean configuration
| ======================================= -->
|
| <mbean
code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService"
| name="jboss.messaging:service=PersistenceManager"
| xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">
|
| <depends>jboss.jca:service=DataSourceBinding,name=JBossDS</depends>
|
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
|
| <!-- The datasource to use for the persistence manager -->
|
| <attribute name="DataSource">java:/JBossDS</attribute>
|
| <!-- If true will attempt to create tables and indexes on every start-up
-->
|
| <attribute name="CreateTablesOnStartup">true</attribute>
|
| <!-- If true then will use JDBC batch updates -->
|
| <attribute name="UsingBatchUpdates">false</attribute>
|
| <!-- The maximum number of parameters to include in a prepared statement
-->
|
| <attribute name="MaxParams">500</attribute>
| </mbean>
|
| <!-- Messaging Post Office MBean configuration
| ========================================= -->
|
| <mbean code="org.jboss.messaging.core.jmx.MessagingPostOfficeService"
| name="jboss.messaging:service=PostOffice"
| xmbean-dd="xmdesc/MessagingPostOffice-xmbean.xml">
|
| <depends
optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
|
| <depends>jboss.jca:service=DataSourceBinding,name=JBossDS</depends>
|
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
|
| <!-- The name of the post office -->
|
| <attribute name="PostOfficeName">JMS post
office</attribute>
|
| <!-- The datasource used by the post office to access it's binding
information -->
|
| <attribute name="DataSource">java:/JBossDS</attribute>
|
| <!-- If true will attempt to create tables and indexes on every start-up
-->
|
| <attribute name="CreateTablesOnStartup">true</attribute>
|
| <!-- This post office is NON CLUSTERED - do not use clustering with
Hypersonic!! -->
|
| <attribute name="Clustered">false</attribute>
| </mbean>
|
| <!-- Messaging JMS User Manager MBean config
| ======================================= -->
|
| <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"
| name="jboss.messaging:service=JMSUserManager"
| xmbean-dd="xmdesc/JMSUserManager-xmbean.xml">
|
| <depends>jboss.jca:service=DataSourceBinding,name=JBossDS</depends>
|
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
|
| <attribute name="DataSource">java:/JBossDS</attribute>
|
| <attribute name="CreateTablesOnStartup">true</attribute>
|
| <attribute name="SqlProperties"><![CDATA[
| POPULATE.TABLES.1 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('guest',
'guest')
| POPULATE.TABLES.2 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('j2ee',
'j2ee')
| POPULATE.TABLES.3 = INSERT INTO JBM_USER (USER_ID, PASSWD, CLIENTID) VALUES
('john', 'needle', 'DurableSubscriberExample')
| POPULATE.TABLES.4 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody',
'nobody')
| POPULATE.TABLES.5 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('dynsub',
'dynsub')
| POPULATE.TABLES.6 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('guest','guest')
| POPULATE.TABLES.7 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('j2ee','guest')
| POPULATE.TABLES.8 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('john','guest')
| POPULATE.TABLES.9 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('subscriber','john')
| POPULATE.TABLES.10 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('publisher','john')
| POPULATE.TABLES.11 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('publisher','dynsub')
| POPULATE.TABLES.12 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('durpublisher','john')
| POPULATE.TABLES.13 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('durpublisher','dynsub')
| POPULATE.TABLES.14 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES
('noacc','nobody')
| ]]></attribute>
| </mbean>
|
| </server>
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4188232#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...