You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by JS75 <je...@aboveE.com> on 2008/03/26 08:50:25 UTC
COMMIT TRANSACTION 要求沒有對應的 BEGIN TRANSACTION
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 ??
Sincerely,
Jean
--
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-tp16297078s2354p16297078.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Could I get user name and password of JDBC connection in config
file
Posted by JS75 <je...@aboveE.com>.
Dear All:
After checking out all API all day, I still has no idea how to get user name
and password of JDBC connection in config file.
Do I need to user ConnectionContext or ConnectionInfo classes??
How could I get these info from BrokerService???
Please help me to figure it out~
Sincerely,
Jean
JS75 wrote:
>
> 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 <je...@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-tp16297078s2354p16323598.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: COMMIT TRANSACTION 要求沒有對應的 BEGIN TRANSACTION
Posted by JS75 <je...@aboveE.com>.
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 <je...@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.
Re: COMMIT TRANSACTION 要求沒有對應的 BEGIN TRANSACTION
Posted by James Strachan <ja...@gmail.com>.
On 26/03/2008, JS75 <je...@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