Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Temp Table problem with PreparedStatement

 
Vikram Varma
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am creating a prepared statement as:
ps = connection.prepareStatement(sqlString,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

This works fine in most cases. One of our table has a colum of lenght 16000 bytes VarChar. When I use the above preparedStatement to select that colum I get the error:
DB2 SQL Error: SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00E7009A;200;TABLESPACE IN TEMP DATABASE, DRIVER=3.50.152

I found that the problem is with the two parameters(TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE). If I prepare the statement as ps = connection.prepareStatement(sqlString), I dont get any problem while selecting that huge colum.

My question is is there any was that I can increase the size of the temporary table while creating the Prepared Statemnt.


Thanks!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic