emacarron / mybatis

Automatically exported from code.google.com/p/mybatis
0 stars 0 forks source link

how to free temp tablespace allocated for a select stmt return parameter #186

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What version of the MyBatis are you using?
latest

Please describe the problem.  Unit tests are best!
I have a table holding text data that has been compressed into a blob field. 
I am using a stored procedure to decompress this data (using UTL_COMPRESS) from 
a blob into a clob and returning this.
the clob uses space allocated dynamically from the temp tablespace.
how do I ensure ibatis frees this allocated temp space once the data has been 
mapped into a pojo?

What is the expected output? What do you see instead?
Currently the temp tablespace fills up with the returned clobs until an 'out of 
temporary tablespace' error occurs.

Please provide any additional information below.

Original issue reported on code.google.com by colin.barker07@btinternet.com on 28 Nov 2010 at 12:07

GoogleCodeExporter commented 9 years ago
Please Colin, ask questions in the user mailing list. Thanks in advance!

Original comment by eduardo.macarron on 15 Jan 2012 at 12:26