From users-return-31054-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org Mon Jun 11 10:11:31 2012 Return-Path: X-Original-To: apmail-activemq-users-archive@www.apache.org Delivered-To: apmail-activemq-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D146EC3CF for ; Mon, 11 Jun 2012 10:11:31 +0000 (UTC) Received: (qmail 87378 invoked by uid 500); 11 Jun 2012 10:11:31 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 87243 invoked by uid 500); 11 Jun 2012 10:11:30 -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 87211 invoked by uid 99); 11 Jun 2012 10:11:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2012 10:11:29 +0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gary.tully@gmail.com designates 209.85.216.43 as permitted sender) Received: from [209.85.216.43] (HELO mail-qa0-f43.google.com) (209.85.216.43) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2012 10:11:20 +0000 Received: by qadb33 with SMTP id b33so1893527qad.2 for ; Mon, 11 Jun 2012 03:10:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=/nreuMKk/kU2w7+HHTGc6fCUUJRp0nP04lXdL8xLGVM=; b=UU+i6x7O8HeaP2PQloj6CTyv41KIdChz2QYuPiFYvU4VcE8EqaAc1ImtehD0qtwuLS ZG0diPh5uPeKBJ5QfQ0yNVSIQt0fnBOZQdfu8IGdLc49KdKFUF0SYrVOtcxhwWo/1BNq NC9c2YaL2OomYl3tYZ6Hy7zPaFxVZZ07bHuwhGbQ4aEdj8HRw6HV6M3Th5UcIfkNL7uT bc+XPC62nwl6/dxVo+7JMsTFZGlDTHY9271bUV2MeyeDi/XmB/HGBEmv2Xyn5aJFfhqp BqFy/9txvozc+t8+OR16qssD3ph42OGGB9svizW0CFhNsdlG3SJfGUDSsGjM18xfwPAr 1gcQ== MIME-Version: 1.0 Received: by 10.229.134.197 with SMTP id k5mr6198346qct.83.1339409456842; Mon, 11 Jun 2012 03:10:56 -0700 (PDT) Received: by 10.229.237.196 with HTTP; Mon, 11 Jun 2012 03:10:56 -0700 (PDT) In-Reply-To: <1339394310645-4653146.post@n4.nabble.com> References: <1339306530647-4653140.post@n4.nabble.com> <1339331498123-4653143.post@n4.nabble.com> <1339394310645-4653146.post@n4.nabble.com> Date: Mon, 11 Jun 2012 11:10:56 +0100 Message-ID: Subject: Re: jdbc Master fails: AMQ v.5.6, Postgres v.9.1, Ubuntu From: Gary Tully To: users@activemq.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org the correct impl should be picked up based on the type of the underlying datasource. There is a mapper properties file that provides overrides. ms sql server is the only driver that currently uses the transact locker: http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/resource= s/META-INF/services/org/apache/activemq/store/jdbc/lock/microsoft_sql_serve= r_2005_jdbc_driver?view=3Dmarkup In the absence of doc, the best place to see what an individual config option does it to check the source[1] One would only use the adapter element if you want to explicitly provide the implementation, as in the auto mapping is not correct. Please open jira issues to trigger a doc enhancement so that the experience is better for the next user. [1] http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java= /org/apache/activemq/store/jdbc/ On 11 June 2012 06:58, SergueiM wrote: > metatech, thank you. > > The config piece that actually worked: > > =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 > > > Folks, > where one could read about those many options as in activemq-core.xsd? > I could not find answers in AMQ docs, nor in Fuse docs, nor in the "Activ= eMQ > in Action" book. > > For example, in my context of jdbc Master/Slave: > - when do I use database-locker as opposed to transact-database-locker? > - disabling the setQueryTimeout (as in the above setting) affects/results= in > what? > - what the "adapter" child element to jdbcPersistenceAdapter is for? > > Thank you. > > > > > > > -- > View this message in context: http://activemq.2283324.n4.nabble.com/jdbc-= Master-fails-AMQ-v-5-6-Postgres-v-9-1-Ubuntu-tp4653140p4653146.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. --=20 http://fusesource.com http://blog.garytully.com