activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JS75 <jean...@aboveE.com>
Subject Could I get user name and password of JDBC connection in config file
Date Thu, 27 Mar 2008 10:01:43 GMT

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 <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-tp16297078s2354p16323598.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message