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" <[EMAIL PROTECTED]>
To: <[email protected]>
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 <[EMAIL PROTECTED]> 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
