[prev in list] [next in list] [prev in thread] [next in thread] 

List:       activemq-users
Subject:    Could I get user name and password of JDBC connection in config
From:       JS75 <jean_su () aboveE ! com>
Date:       2008-03-27 10:01:43
Message-ID: 16323598.post () talk ! nabble ! com
[Download RAW message or body]


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.


[prev in list] [next in list] [prev in thread] [next in thread]