SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 10:00 AM
| ||||
| ||||
 Strange exception ?? Greatings. We are developint an application using struts on linux. We run a db2 server (v8.1) on linux. When trying to access using JDBC drivers I am getting this error. com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031 at com.ibm.db2.jcc.b.ce.e(ce.java:1093) at com.ibm.db2.jcc.a.bd.o(bd.java:564) at com.ibm.db2.jcc.a.bd.g(bd.java:129) at com.ibm.db2.jcc.a.bd.a(bd.java:40) at com.ibm.db2.jcc.a.r.a(r.java:31) It only happens when running a large number of sql statements in one hit. I have got no idea what this problem is or even what it means and Ihave not been able to find any documentation to point me in the right direction. The function that we run is passed a sql string, creates a statement from a connection then exectutes the statement and returns a recordset and does this over and over again. I dont think I am doing anything wrong here as it has worked wihtout issues up until now. The only difference is that instead of executing a couple of statements we are now doing dozens at a time. Help or pointers would be apprciated. Ben      |
|
02-26-2008, 10:01 AM
| |||
| |||
| Re: Strange exception ?? So nobody has seen anything like this? *Sigh* I have spent hours trying to work out what is going on. Ben Benjamin Stewart wrote: > Greatings. We are developint an application using struts on linux. We > run a db2 server (v8.1) on linux. When trying to access using JDBC > drivers I am getting this error. > > com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031 > at com.ibm.db2.jcc.b.ce.e(ce.java:1093) > at com.ibm.db2.jcc.a.bd.o(bd.java:564) > at com.ibm.db2.jcc.a.bd.g(bd.java:129) > at com.ibm.db2.jcc.a.bd.a(bd.java:40) > at com.ibm.db2.jcc.a.r.a(r.java:31) > > It only happens when running a large number of sql statements in one > hit. I have got no idea what this problem is or even what it means and > Ihave not been able to find any documentation to point me in the right > direction. > > The function that we run is passed a sql string, creates a statement > from a connection then exectutes the statement and returns a recordset > and does this over and over again. I dont think I am doing anything > wrong here as it has worked wihtout issues up until now. > > The only difference is that instead of executing a couple of statements > we are now doing dozens at a time. > > Help or pointers would be apprciated. > > Ben > |
|
02-26-2008, 10:02 AM
| ||||
| ||||
| Re: Strange exception ?? Ben Stewart <bstewart@waterwerks.com.au> wrote: > So nobody has seen anything like this? *Sigh* I have spent hours trying > to work out what is going on. Did you take a CLI trace no see what's going on between the DB2 server and your client's CLI/Java interface? -- Knut Stolze Information Integration IBM Germany / University of Jena |
 |
« StaticSQL
|
Finding grand total »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:16 PM.
