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

2009-06-25 Thread giddion
Renamed All as Default, removed other configs.
Logging level is INFO.
SQLJDBC4.jar is in $JBOSS_HOME/server/default/lib

mssql-ds.xml

  | 
  |   
  | DefaultDS
  | 
jdbc:sqlserver://devdb.conncoll.edu:1433
  | 
com.microsoft.sqlserver.jdbc.SQLServerDriver
  | JBoss
  | x
  | *
  | SELECT 1 FROM 
sysobjects
  | 
  |  MS SQLSERVER2000
  | 
  |   
  | 

Relevant portion of mssql-persistence-service.xml
 

  | 
  |
  | 
  |
  | 
  |   jboss.jca:service=DataSourceBinding,name=DefaultDS
  | 
  |   jboss:service=TransactionManager
  | 
  |   
  | 
  |   java:/DefaultDS
  | 
  |   
  | 
  |   true
  | 
  |   
  | 
  |   true
  | 
  |   
  | 
  |   500
  | 

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=20, pageSize=2000, downCacheSize=2000
  | 15:45:00,195 INFO  [ConnectionFactory] Connector 
bisocket://cameldev1.conncoll.edu:4457 has leasing enabled, lease period 1 
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 1 
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 1 
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=20, 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
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2009-06-25 Thread giddion
Thanks, by setting log to trace I was able to figure out the MS SQL driver was 
ignoring the "databaseName" property and the tables were being dumped into 
another DB. I change the connection-url and it's working as expected now.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240128#4240128

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240128
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2009-06-25 Thread ataylor
change the log level to trace, you should see the tables being created.



View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240111#4240111

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240111
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2009-06-25 Thread ataylor
daft question, but it is the default configuration that you made the changes 
too? also have you added the correct database drivers.

also try running with a higher logging level to see if that throws up anything!

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240099#4240099

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240099
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2009-06-25 Thread giddion
yes I had actually said that in the post but had included the tags so it didn't 
display right.

Double checked the mssql-persistence-service.xml CreateTablesOnStartup is set 
to true

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240096#4240096

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240096
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2009-06-25 Thread ataylor
is 'CreateTablesOnStartup' in the persistence file set to true?

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4240094#4240094

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4240094
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user