Temp Table problem with PreparedStatement

[Vikram Varma]

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!!