Return-Path: Delivered-To: apmail-geronimo-dev-archive@www.apache.org Received: (qmail 16514 invoked from network); 22 Jan 2010 18:07:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Jan 2010 18:07:31 -0000 Received: (qmail 41789 invoked by uid 500); 22 Jan 2010 18:07:31 -0000 Delivered-To: apmail-geronimo-dev-archive@geronimo.apache.org Received: (qmail 41703 invoked by uid 500); 22 Jan 2010 18:07:31 -0000 Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: dev@geronimo.apache.org List-Id: Delivered-To: mailing list dev@geronimo.apache.org Received: (qmail 41695 invoked by uid 99); 22 Jan 2010 18:07:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jan 2010 18:07:31 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.136.44.54] (HELO smtp109.prem.mail.sp1.yahoo.com) (98.136.44.54) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 22 Jan 2010 18:07:22 +0000 Received: (qmail 77751 invoked from network); 22 Jan 2010 18:07:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Yahoo-SMTP:X-Yahoo-Newman-Property:Message-Id:From:To:In-Reply-To:Content-Type:Mime-Version:Subject:Date:References:X-Mailer; b=qystqwfitub0Tdp4rHST3zBIyr/aP2SYKItei91iZIBgPhNP2F/5fSPC3gLerLyCNYkTguVI10Pu9nX7ZoK6zXLpNTPCVRBxHST/eEEkmSYJLfwXlEwKxA5WHgmYjiw3J90GTOY/gaKVjFw9VBMCesDIwwVC0/a62aOncFdiHtQ= ; Received: from 076-076-148-215.pdx.net (david_jencks@76.76.148.215 with plain) by smtp109.prem.mail.sp1.yahoo.com with SMTP; 22 Jan 2010 10:06:58 -0800 PST X-Yahoo-SMTP: .9oIUzyswBANsYgUm_5uPui0skTnzGJXJQ-- X-Yahoo-Newman-Property: ymail-3 Message-Id: <64F1D7E1-7E3D-401C-9B51-CD97F488BB1B@yahoo.com> From: David Jencks To: dev@geronimo.apache.org In-Reply-To: <326CB758-FD06-486E-894B-4A0AD9E42A1A@yahoo.com> Content-Type: multipart/alternative; boundary=Apple-Mail-34-261092124 Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: Informix XA data source configuration for IFX_LOCK_MODE_WAIT Date: Fri, 22 Jan 2010 10:06:57 -0800 References: <27148795.post@talk.nabble.com> <326CB758-FD06-486E-894B-4A0AD9E42A1A@yahoo.com> X-Mailer: Apple Mail (2.936) --Apple-Mail-34-261092124 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Following the more careful examination in TQL-19 I applied the supplied patch which changed the case of the new property and added an ra.xml entry for it. thanks david jencks On Jan 13, 2010, at 11:55 AM, David Jencks wrote: > I added this to the tranql wrapper and pushed a new snapshot to the > codehaus snapshot repo. > > http://snapshots.repository.codehaus.org/org/tranql/tranql-connector-informix-xa/1.2-SNAPSHOT/ > > Can you verify that this works, that the time unit is seconds, and > look around to see if there are other properties we should allow > setting on the XADatasource? > > many thanks > david jencks > > On Jan 13, 2010, at 10:14 AM, Shanmu wrote: > >> Hello everyone, We are using Geronimo 2.1.4 with informix XA driver >> version 3.0.0 JC3. The application we build has a process which >> runs in the geronimo containner every 2 minutes and updates lots of >> tables. in foreground we a web application where users can access >> screen and update and retrieve from the same tables. Our >> architecture is like this JSP/Struts 2 --> EJB 3.0 with CMT--> DAO >> using hibernate uses data source configured in geronimo server--> >> informix DB We have configured the data source using the informix >> provided drivers and the informix Tran QL connectors. We are >> currently facing a problem where we are getting locking issues >> frequently when the user and batch process collides. The error is >> "Could not do a physical-order read to fetch next row.SQL Error: >> -107, SQLState: IX000" The solution provided was to increase the >> IFX_LOCK_MODE_WAIT to some reasonable time so that the process >> waits for the predefined time before it throws the error. Default >> value for this is configured as zero in IFXDatasource. By default >> data source configured using the informix XA option does not have >> any option to configure this parameter. Neither the hibernate has >> any configuration for this, as it is using the data source created >> in application server. On analyzing the source code we noticed that >> there is a component org.tranql.connector.informix.XAMCF part of >> tran QL adapter which creates and configures the data source, >> public XAMCF() { super(new IfxXADataSource(), new >> NoExceptionsAreFatalSorter()); password = ""; ds = >> (IfxXADataSource)xaDataSource; } This IFXData source doesn not have >> the option of lock mode wait setup, which can be done using the >> method "setIfxIFX_LOCK_MODE_WAIT". My questions are: 1. Is there >> any option where in we can configure the IFX_LOCK_MODE_WAIT >> parameter? 2. If not is there any patch with this enhancement done. >> Thanks in advance Best Regards Shanmu >> View this message in context: Informix XA data source configuration >> for IFX_LOCK_MODE_WAIT >> Sent from the Apache Geronimo - Dev mailing list archive at >> Nabble.com. > --Apple-Mail-34-261092124 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Following the more careful = examination in  =20 TQL-19  =
thanks
david = jencks

On Jan 13, 2010, = at 11:55 AM, David Jencks wrote:

I added this to the tranql = wrapper and pushed a new snapshot to the codehaus snapshot = repo.

http://snapshots.repository.codehaus.org/org= /tranql/tranql-connector-informix-xa/1.2-SNAPSHOT/

<= div>Can you verify that this works, that the time unit is seconds, and = look around to see if there are other properties we should allow setting = on the XADatasource?

many = thanks
david jencks

On Jan 13, 2010, = at 10:14 AM, Shanmu wrote:

Hello = everyone, We are using Geronimo 2.1.4 with informix XA driver version = 3.0.0 JC3. The application we build has a process which runs in the = geronimo containner every 2 minutes and updates lots of tables. in = foreground we a web application where users can access screen and update = and retrieve from the same tables. Our architecture is like this = JSP/Struts 2 --> EJB 3.0 with CMT--> DAO using hibernate uses data = source configured in geronimo server--> informix DB We have = configured the data source using the informix provided drivers and the = informix Tran QL connectors. We are currently facing a problem where we = are getting locking issues frequently when the user and batch process = collides. The error is "Could not do a physical-order read to fetch next = row.SQL Error: -107, SQLState: IX000" The solution provided was to = increase the IFX_LOCK_MODE_WAIT to some reasonable time so that the = process waits for the predefined time before it throws the error. = Default value for this is configured as zero in IFXDatasource. By = default data source configured using the informix XA option does not = have any option to configure this parameter. Neither the hibernate has = any configuration for this, as it is using the data source created in = application server. On analyzing the source code we noticed that there = is a component org.tranql.connector.informix.XAMCF part of tran QL = adapter which creates and configures the data source, public XAMCF() = { super(new IfxXADataSource(), new = NoExceptionsAreFatalSorter()); password =3D ""; ds =3D = (IfxXADataSource)xaDataSource; } This IFXData source doesn not have = the option of lock mode wait setup, which can be done using the method = "setIfxIFX_LOCK_MODE_WAIT". My questions are: 1. Is there any option = where in we can configure the IFX_LOCK_MODE_WAIT parameter? 2. If not is = there any patch with this enhancement done. Thanks in advance Best = Regards Shanmu
View this message = in context: Informix XA data source = configuration for IFX_LOCK_MODE_WAIT
Sent from the Apache = Geronimo - Dev mailing list archive at = Nabble.com.


= --Apple-Mail-34-261092124--