ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: Temporary table causing problems?
Date Tue, 02 Aug 2005 09:27:03 GMT
Did you try to escape the # using ##?

Niels

-----Original Message-----
From: Bing Qiao [mailto:qiaobing@gmail.com] 
Sent: dinsdag 2 augustus 2005 11:26
To: user-java@ibatis.apache.org
Subject: 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.

Mime
View raw message