activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JS75 <jean...@aboveE.com>
Subject Re: COMMIT TRANSACTION 要求沒有對應的 BEGIN TRANSACTION
Date Thu, 27 Mar 2008 03:10:47 GMT

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 is there another better way that I could 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 <jean_su@abovee.com> 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.


Mime
View raw message