You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Bing Qiao <qi...@gmail.com> on 2005/08/02 11:26:13 UTC

Temporary table causing problems?

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.