ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiao Qing Lai" <qing...@scs.com.sg>
Subject Re: Is it a bug of ibatis or mine? - Connection time out when querying
Date Wed, 09 Mar 2005 04:56:31 GMT
hi Douglas,
I've found out the reason. it's not becoz of ibatis.
the reason is that, the BADBOY is a column of a view, and behinde this 
column, there is a complicated sub query.
it's the sub query that makes Oracle wait for more than 1 sec.
And since our client set the oracle time out to 1 sec,  they hit the timout 
exception.
Thx
Regards
Xiao Qing Lai


----- Original Message ----- 
From: "Douglas" <douglasfsbr@yahoo.com.br>
To: <ibatis-user-java@incubator.apache.org>
Sent: Monday, March 07, 2005 6:16 AM
Subject: Re: Is it a bug of ibatis or mine? - Connection time out when 
querying


> Hi Xiao Qing Lai,
>
> Could you put your file mapping here ?
>
> Regards,
>
> Douglas
>
> --- Xiao Qing Lai <qinglai@scs.com.sg> wrote:
>> 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 = 1,
>> it's okey.
>> While SELECT NAME, ENTITY, ID, BADBOY FROM TABLE1
>> WHERE ID = 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.
>>
>> The type of BADBOY column is varchar(2), contains
>> only a short string.
>>
>> And this error never occurs under dev env.
>>
>> The envrionment is: Windows 2003 server, Weblogic
>> 8.1 sp2, Oracle 9i, iBATIS 2.0.7.459
>>
>>
>>
>>
>> Thanks and
>> Regards,
>>
>> Xiao Qing Lai
>>
>>
>
>
>
>
>
> _______________________________________________________
> Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. 
> http://br.acesso.yahoo.com/ - Internet rápida e grátis
> 



Mime
View raw message