[jboss-user] [JBoss Messaging] - Re: No tables no errors

[giddion]

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 at 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 at 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 at 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