Re: [Firebird-net-provider] (no subject)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

<html><div style='background-color:'><DIV class=RTE>
Hi, I send the next message the last week:
--------------------------------------------------------------------------------------- I am executing the following query: &nbsp; SELECT * FROM HISTPRECONTA WHERE (FECHALTA IS NULL OR FECHALTA='') OR FECHALTA IN('20060907') AND NUMEMP=2 AND CODEMPRESA=1 &nbsp; When I do the query with SQL Manager 2005 Lite for Interbase and Firebird, it go well. But when I execute the query from this C# code, the dataset never is filled, and the program execution is locked, in other words, the method adapter.Fill(ds) never terminates adapter.SelectCommand=command; command.CommandText = "SELECT * FROM HISTPRECONTA WHERE (FECHALTA IS NULL OR FECHALTA='') OR FECHALTA IN('20060907') AND NUMEMP=2 AND CODEMPRESA=1" ds = new DataSet(); adapter.Fill(ds); //Here the program is locked and the method never returns, no exception is throwed
I'm sure that the C# code is ok, I has executed the query with other data and it goes ok.
I'm using Firebird Server 1.5 and Firebird Net Provider 1.6 ---------------------------------------------------------------------------------------
Well, in the table HISTPRECONTA there are 56 records, and the query must return 2. Before executing this query, I do the same query twice, but with NUMEMP = 0 and NUMEMP = 1, and it go ok, and execution of "adapter.Fill(ds);" is not locked. This is the C# code of the method, that is called by a foreach loop with diferents values for the parameter "codigoEmpleado":
public DataTable obtenerRegistrosHistorico(ConfiguracionBD conf, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ArrayList columnas, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string nombreTabla, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string campoEmpleado, &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int codigoEmpleado, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string campoFecha, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string fecha, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string campoEmpresa, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int codEmpresa, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDbConnection connection, 
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDbTransaction transaction)&nbsp;//transaction is passed null { &nbsp;&nbsp; &nbsp;//IDbConnection connection= factoriaConexiones.getConnection(conf); &nbsp;IDbCommand command= connection.CreateCommand(); &nbsp;command.Transaction=transaction; &nbsp;IDbDataAdapter adapter= factoriaDataAdapter.getDataAdapter(); &nbsp;DataSet ds = new DataSet();
&nbsp;&nbsp;&nbsp; &nbsp;string cols =""; &nbsp;if(columnas == null || columnas.Count== 0) &nbsp;&nbsp;cols ="*"; &nbsp;else &nbsp;&nbsp;cols = new Cadenas().convertirAString(columnas);
&nbsp;command.CommandText="SELECT MAX("+campoFecha+") FROM "+nombreTabla &nbsp;&nbsp;&nbsp;&nbsp;+" WHERE "+campoEmpleado+"="+codigoEmpleado &nbsp;&nbsp;&nbsp;&nbsp;+" AND "+campoEmpresa+"="+codEmpresa &nbsp;&nbsp;&nbsp;&nbsp;+" AND "+campoFecha+" &lt;= '"+fecha+"'"; &nbsp;&nbsp; &nbsp;try &nbsp;{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; adapter.SelectCommand=command;&nbsp; &nbsp;adapter.Fill(ds); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DataTable dtFecha = ds.Tables[0]; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string maxFecha = dtFecha.Rows[0][0].ToString(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; command.CommandText="SELECT "+cols+" FROM "+nombreTabla &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +" WHERE (FECHALTA IS NULL OR FECHALTA='') OR" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +&nbsp; campoFecha+" IN('" + 
maxFecha + "')" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +" AND "+campoEmpleado+"="+codigoEmpleado &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +" AND "+campoEmpresa+"="+codEmpresa; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ds = new DataSet(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; adapter.Fill(ds); //This is the locked query in the third called of the method &nbsp;&nbsp;&nbsp;&nbsp; //obtenerRegistrosHistorico &nbsp;} &nbsp;catch(Exception e) &nbsp;{ &nbsp;&nbsp;Excepcion ex= new Excepcion(new Exception("WMNDAC_ErrorBaseDatos",e)); &nbsp;&nbsp;ArrayList exN=new ArrayList(); &nbsp;&nbsp;ArrayList exV=new 
ArrayList(); &nbsp;&nbsp;exN.Add("conf");exV.Add(conf); &nbsp;&nbsp;exN.Add("columnas");exV.Add(columnas); &nbsp;&nbsp;exN.Add("nombreTabla");exV.Add(nombreTabla); &nbsp;&nbsp;exN.Add("campoEmpleado");exV.Add(campoEmpleado); &nbsp;&nbsp;exN.Add("codigoEmpleado");exV.Add(codigoEmpleado); &nbsp;&nbsp;exN.Add("campoFecha");exV.Add(campoFecha); &nbsp;&nbsp;exN.Add("fecha");exV.Add(fecha); &nbsp;&nbsp;exN.Add("campoEmpresa");exV.Add(campoEmpresa); &nbsp;&nbsp;exN.Add("codEmpresa");exV.Add(codEmpresa); &nbsp;&nbsp;exN.Add("connection");exV.Add(connection); &nbsp;&nbsp;exN.Add("transaction");exV.Add(transaction); &nbsp;&nbsp;ex.lanzar(this,ex.formatearParametros("OperadorBD.obtenerRegistrosHistorico",exN,exV),new WMNDACConfiguracion().HacerLogExcepciones); &nbsp;}
&nbsp;return ds.Tables[0]; }
 Column FECHALTA, can`t be NULL in the table, and it isn't necesary to apply the condition "FECHALTA IS NULL" of the query, but FECHALTA = '' is really necesary. I tell this because, if I delete the condition "(FECHALTA IS NULL OR FECHALTA='')" from the query, it goes ok in C# code. If I only delete "FECHALTA IS NULL" or ("FECHALTA = '') the query continues blocking when it is called 3 times. I don't Know what is happening. The transaction property of the object command is null. I've never used v1.7 of Firebird Net Provider. 
I'm don't know english, I'm sorry the errors in my message.
Thanks. </DIV>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px">
<HR color=#a0c6e5 SIZE=1>

<DIV></DIV>From:&nbsp;&nbsp;Carlos Guzmán Álvarez &lt;car...@mu...&gt; Reply-To:&nbsp;&nbsp;"For users and developers of the Firebird .NET providers" &lt;fir...@li...&gt; To:&nbsp;&nbsp;"For users and developers of the Firebird .NET providers" &lt;fir...@li...&gt; Subject:&nbsp;&nbsp;Re: [Firebird-net-provider] (no subject) Date:&nbsp;&nbsp;Fri, 08 Sep 2006 22:27:59 +0200 MIME-Version:&nbsp;&nbsp;1.0 Received:&nbsp;&nbsp;from lists-outbound.sourceforge.net ([66.35.250.225]) by bay0-mc11-f1.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2444); Fri, 8 Sep 2006 13:27:51 -0700 Received:&nbsp;&nbsp;from sc8-sf-list2-new.sourceforge.net (unknown [10.3.1.94])by sc8-sf-spam2.sourceforge.net (Postfix) with ESMTPid E0F8F12DBF; Fri, 8 Sep 2006 
13:27:50 -0700 (PDT) Received:&nbsp;&nbsp;from sc8-sf-mx2-b.sourceforge.net ([10.3.1.92]helo=mail.sourceforge.net)by sc8-sf-list2-new.sourceforge.net with esmtp (Exim 4.43)id 1GLmx2-0003RW-O3 for fir...@li...;Fri, 08 Sep 2006 13:27:48 -0700 Received:&nbsp;&nbsp;from smtp2.mundo-r.com ([212.51.32.187])by mail.sourceforge.net with esmtp (Exim 4.44) id 1GLmx2-0002Bf-Qifor fir...@li...;Fri, 08 Sep 2006 13:27:49 -0700 Received:&nbsp;&nbsp;from cm172154.red.mundo-r.com (HELO [213.60.172.154])([213.60.172.154])by smtp2.mundo-r.com with ESMTP; 08 Sep 2006 22:27:46 +0200 &gt;Hello: &gt; &gt; &gt; &gt; I'm sure that the C# code is ok, I have execute the query with other &gt; &gt; data and it go ok. &gt; &gt; &gt; &gt; I'm using Firebird Server 1.5 and Firebird Net Provider 1.6 &gt; 
&gt; &gt;Can you send a test case ?? What is the isolation level you are using &gt;for the transactions ( if you are using a non default one ) ?? &gt;Is the same thing happening on v1.7 of the provider ?? &gt; &gt;-- &gt;Carlos Guzmán Álvarez &gt;Vigo-Spain &gt; &gt;------------------------------------------------------------------------- &gt;Using Tomcat but need to do more? Need to support web services, security? &gt;Get stuff done quickly with pre-integrated technology to make your job easier &gt;Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo &gt;http://sel.as-us.falkag.net/sel?cmd=lnk&amp;kid=120709&amp;bid=263057&amp;dat=121642 &gt;_______________________________________________ &gt;Firebird-net-provider mailing list &gt;Fir...@li... &gt;https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </BLOCKQUOTE></div></html>

Re: [Firebird-net-provider] (no subject)

A powerful, cross platform, SQL database system

Re: [Firebird-net-provider] (no subject)