In my application i am trying to fetch around 200 records in resultset. But server hangs after executing the query. see below code:
It prints "Start query" and hangs after it. When i execute this query in winsql i am getting 230 records only. I am using Jboss 4.2 with DB2 8.x. I am not sure why it is not able to handle such less no of records.
1) remove the semicolon at the end of the statement 2) test the statement in a DB client 3) if you want to read columns by number, request the column names explicitly, don't use '*' 4) report exceptions, don't just use 'printStackTrace()'
Joined: Oct 06, 2007
Thanks David, but even after trying everything told by you i am not able to get the application working. The server log doesn't print anything after starting executing executeQuery(). Is it related to JNDI connection pooling or Jboss 4.2 issue ? Any kind of help will be appreciable.