Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 14855 invoked from network); 26 Mar 2008 11:29:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Mar 2008 11:29:12 -0000 Received: (qmail 70490 invoked by uid 500); 26 Mar 2008 11:29:10 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 70467 invoked by uid 500); 26 Mar 2008 11:29:10 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 70458 invoked by uid 99); 26 Mar 2008 11:29:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Mar 2008 04:29:10 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of james.strachan@gmail.com designates 64.233.170.186 as permitted sender) Received: from [64.233.170.186] (HELO rn-out-0910.google.com) (64.233.170.186) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Mar 2008 11:28:29 +0000 Received: by rn-out-0910.google.com with SMTP id j40so2109753rnf.4 for ; Wed, 26 Mar 2008 04:28:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=7bG/pFZ+gZhC01gVWFzFNbKGeCgFswALs2DEdaS70oI=; b=iZHkV1PcjOTEh/1EEEaC7o58MVBpBIcX9sHPAsbsLr56yO0hPnxI+6l6NlcFlQ7lZivPcnDWUWLxvbm/QbLpRVNbzmXe8oCX6rSiPXGdawDcGkGhG88fyiJZr5w9ChUEEu9x7mB6im/YBiWxhNw0sIo3nJJWbkV8MPzYwYjjA+E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=c7/DxDGv6WOExbFUSfJochU+y+Z2vY9uVmdjcmUparupDyoYlLPL3hVKsP4A7ireL0XL3X8s2Wtm1t3VtQk4PcewNKNKz4V5Aw/rqVUJtLIPhD2HxAe6TN6TjlH52u3NmBVu7lInsFH8/ucq+SIPSZrGWzWJ1o/5G27GYM8IU0A= Received: by 10.150.205.13 with SMTP id c13mr4729152ybg.135.1206530920597; Wed, 26 Mar 2008 04:28:40 -0700 (PDT) Received: by 10.150.148.20 with HTTP; Wed, 26 Mar 2008 04:28:40 -0700 (PDT) Message-ID: Date: Wed, 26 Mar 2008 11:28:40 +0000 From: "James Strachan" To: users@activemq.apache.org Subject: =?ISO-2022-JP?B?UmU6IENPTU1JVCBUUkFOU0FDVElPTiAbJEJNVxsoQg==?= =?ISO-2022-JP?B?GyRCNWFdc00tVXRYZkUqGyhCIEJFR0lOIFRSQU5TQUNUSU9O?= In-Reply-To: <16297078.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <16297078.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org On 26/03/2008, JS75 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