Than you James~^^ I still have one more question, if I disable createTablesOnStartup which means MQ will not create DB table for the first time (obviously in my test), so I need to create table by manually? If so, is there any addon program for us to alter table if any changes in table schema?
And I still wonder another better way thant could I move this warning by logger configure??? After all, what I want to do is to prevent users to get confused with it but relying on MQ default settings. Sincerely, Jean James.Strachan wrote: > > On 26/03/2008, JS75 <[EMAIL PROTECTED]> wrote: >> >> Dear All: >> >> I use MQ 4.1 to replace my internal queue, and I'd like it to be >> persisitent >> by SQL 2005. >> Every thing goes well~!! >> >> Only one thing, I found warning like this ... >> [java] 2008-03-26 15:36:25.390 WARN >> [main] org.apache.activemq.store.jdbc.JDBCPersistenceAdapter - >> Cannot create tables due to: >> com.microsoft.sqlserver.jdbc.SQLServerException: >> COMMIT TRANSACTION 要求沒有對應的 BEGIN TRANSACTION。 >> >> I know it is only a warning, but it confuses users. >> Is there any way to get rid of it by cinfiguration or fix code ?? > > Try disabling the auto-creation of the tables via the > createTablesOnStartup property on the JDBCPersistenceAdapter > > -- > James > ------- > http://macstrac.blogspot.com/ > > Open Source Integration > http://open.iona.com > > -- View this message in context: http://www.nabble.com/COMMIT-TRANSACTION-%E8%A6%81%E6%B1%82%E6%B2%92%E6%9C%89%E5%B0%8D%E6%87%89%E7%9A%84-BEGIN-TRANSACTION-tp16297078s2354p16321406.html Sent from the ActiveMQ - User mailing list archive at Nabble.com.
