Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 74347 invoked from network); 6 Mar 2005 16:19:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 6 Mar 2005 16:19:26 -0000 Received: (qmail 69952 invoked by uid 500); 6 Mar 2005 16:19:25 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 69754 invoked by uid 500); 6 Mar 2005 16:19:25 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Delivered-To: moderator for ibatis-user-java@incubator.apache.org Received: (qmail 10688 invoked by uid 99); 5 Mar 2005 07:02:27 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,HTML_60_70,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Message-ID: <002801c52151$2c818340$34183c0a@scs> From: "Xiao Qing Lai" To: Subject: Is it a bug of ibatis or mine? - Connection time out when querying Date: Sat, 5 Mar 2005 15:01:37 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C52194.3A9B4D60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-OriginalArrivalTime: 05 Mar 2005 07:01:38.0190 (UTC) FILETIME=[2D0E32E0:01C52151] X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C52194.3A9B4D60 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable hi, These days our project offten hits an error when querying. I'm sorry = that I dont have the stacktrace becoz it only occurs under our client's environment. The troubled query is the same as others. Just a simple query from a = table and a view. If SELECT NAME, ENTITY, ID FROM TABLE1 WHERE ID =3D 1, it's okey. While SELECT NAME, ENTITY, ID, BADBOY FROM TABLE1 WHERE ID =3D 1, i.e., = one more column is included, then the query will throw a connection time out = exception. But the query with BADBOY runs well in SQL Plus.=20 The type of BADBOY column is varchar(2), contains only a short string. And this error never occurs under dev env.=20 The envrionment is: Windows 2003 server, Weblogic 8.1 sp2, Oracle 9i, = iBATIS 2.0.7.459 Thanks and Regards, Xiao Qing Lai ------=_NextPart_000_0025_01C52194.3A9B4D60 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

hi,

These days our project offten hits an = error when=20 querying. I'm sorry that I dont have

the stacktrace becoz it only occurs = under our=20 client's environment.

The troubled query is the same as = others. Just a=20 simple query from a table and a view.

If SELECT NAME, ENTITY, ID FROM TABLE1 = WHERE ID =3D=20 1, it's okey.

While SELECT NAME, ENTITY,=20 ID, BADBOY FROM TABLE1 WHERE ID =3D 1, i.e., = one=20 more

column is included, then the query will = throw a=20 connection time out exception.

But the query with BADBOY runs well in = SQL Plus.=20

The type of BADBOY column = is varchar(2),=20 contains only a short string.

And this error never occurs under dev = env.=20

The envrionment is: Windows 2003 = server, Weblogic=20 8.1 sp2, Oracle 9i, iBATIS 2.0.7.459

Thanks and
Regards,

Xiao Qing Lai

------=_NextPart_000_0025_01C52194.3A9B4D60--