SQL error 805
in [DB2]
|
From: db2group88 on 6 Nov 2006 14:49 we had this error while running the applicaiton on db2 v8.2 EE on windows, jcc driver is what we use SQL error 805 com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031, based on my experience, there is no such package exist, so what would be the main resaon behind this? thank you
From: db2group88 on 6 Nov 2006 14:51 More info, the query inside the loop are just simple select and insert statement with java class.
From: Mark A on 6 Nov 2006 15:06 db2group88 wrote: > More info, > > the query inside the loop are just simple select and insert statement > with java class. This question has been answered many times. Try Google Groups archive and search on 'NULLID.SYSLH203'
From: db2group88 on 6 Nov 2006 15:24 the MAXAPPLS is 500 and APPLHEAPSZ is 12000, i have make sure statement close properly. what else?
From: db2group88 on 6 Nov 2006 15:34
More info, i have done this java -cp "D:\program files\ibm\sqllib\java\db2jcc.jar" com.ibm.db2.jcc.DB2Binder -url jdbc:db2://test -size 80 and this db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG 5 |