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.connectionfact...@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.connectionfact...@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.connectionfact...@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#4240108 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240108 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
