Renamed All as Default, removed other configs.
Logging level is INFO.
SQLJDBC4.jar is in $JBOSS_HOME/server/default/lib
mssql-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
| <datasources>
| <local-tx-datasource>
| <jndi-name>DefaultDS</jndi-name>
|
<connection-url>jdbc:sqlserver://devdb.conncoll.edu:1433</connection-url>
|
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
| <databaseName>JBoss</databaseName>
| <user-name>xxxxx</user-name>
| <password>*****</password>
| <check-valid-connection-sql>SELECT 1 FROM
sysobjects</check-valid-connection-sql>
| <metadata>
| <type-mapping>MS SQLSERVER2000</type-mapping>
| </metadata>
| </local-tx-datasource>
| </datasources>
Relevant portion of mssql-persistence-service.xml
<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=DefaultDS</depends>
|
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
|
| <!-- The datasource to use for the persistence manager -->
|
| <attribute name="DataSource">java:/DefaultDS</attribute>
|
| <!-- If true will attempt to create tables and indexes on every start-up
-->
|
| <attribute name="CreateTablesOnStartup">true</attribute>
|
| <!-- If true then we will automatically detect and reject duplicate messages
sent during failover -->
|
| <attribute name="DetectDuplicates">true</attribute>
|
| <!-- The size of the id cache to use when detecting duplicate messages
-->
|
| <attribute name="IDCacheSize">500</attribute>
|
Relevant Log entries showing registration of DefaultDS Jndi and start of Messaging
15:44:57,896 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name
'java:DefaultDS'
| 15:44:59,954 INFO [ServerPeer] JBoss Messaging 1.4.3.GA server [0] started
| 15:45:00,115 INFO [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000,
pageSize=2000, downCacheSize=2000
| 15:45:00,195 INFO [ConnectionFactory] Connector
bisocket://cameldev1.conncoll.edu:4457 has leasing enabled, lease period 10000
milliseconds
| 15:45:00,195 INFO [ConnectionFactory]
org.jboss.jms.server.connectionfactory.ConnectionFactory@3c750372 started
| 15:45:00,197 INFO [ConnectionFactoryJNDIMapper] supportsFailover attribute is true on
connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
but post office is non clustered. So connection factory will *not* support failover
| 15:45:00,197 INFO [ConnectionFactoryJNDIMapper] supportsLoadBalancing attribute is
true on connection factory:
jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is
non clustered. So connection factory will *not* support load balancing
| 15:45:00,206 INFO [ConnectionFactory] Connector
bisocket://cameldev1.conncoll.edu:4457 has leasing enabled, lease period 10000
milliseconds
| 15:45:00,206 INFO [ConnectionFactory]
org.jboss.jms.server.connectionfactory.ConnectionFactory@78ab10ed started
| 15:45:00,209 INFO [ConnectionFactory] Connector
bisocket://cameldev1.conncoll.edu:4457 has leasing enabled, lease period 10000
milliseconds
| 15:45:00,209 INFO [ConnectionFactory]
org.jboss.jms.server.connectionfactory.ConnectionFactory@d44d2cc started
| 15:45:00,223 INFO [QueueService] Queue[/queue/DLQ] started, fullSize=200000,
pageSize=2000, downCacheSize=2000
| 15:45:00,229 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name
'java:JmsXA'
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240108#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...