ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bing Qiao <qiaob...@gmail.com>
Subject Temporary table causing problems?
Date Tue, 02 Aug 2005 09:26:13 GMT
This problem seems to only exist after 2.0.9b.550

I use queryForList to retrieve dataset from a stored procedure.
Everything gos well except I can't use temporary table when using the
2.1 version of ibatis. Code like the follows will cause trouble:

select top 10 * into #payments
from paymenttable

...

select * from #payments

...

drop table #payments

Everything is alright for 2.0.9b.550 and 2.0.9.496.

Mime
View raw message