Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <27148795.post@talk.nabble.com>
Date: Wed, 13 Jan 2010 10:14:57 -0800 (PST)
From: Shanmu <shanmu_tp@yahoo.com>
To: dev@geronimo.apache.org
Subject: Informix XA data source configuration for IFX_LOCK_MODE_WAIT
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_35516_32152019.1263406497048"

------=_Part_35516_32152019.1263406497048
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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: http://old.nabble.com/Informix-XA-data-source-configuration-for-IFX_LOCK_MODE_WAIT-tp27148795s134p27148795.html
Sent from the Apache Geronimo - Dev mailing list archive at Nabble.com.

------=_Part_35516_32152019.1263406497048
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit


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
<br><hr align="left" width="300">
View this message in context: <a href="http://old.nabble.com/Informix-XA-data-source-configuration-for-IFX_LOCK_MODE_WAIT-tp27148795s134p27148795.html">Informix XA data source configuration for IFX_LOCK_MODE_WAIT</a><br>
Sent from the <a href="http://old.nabble.com/Apache-Geronimo---Dev-f136.html">Apache Geronimo - Dev mailing list archive</a> at Nabble.com.<br>

------=_Part_35516_32152019.1263406497048--