• 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!!
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!