Hello Mark,

That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
productiondatabase is 8.1.0 + 8.1.2 client.

I'll try it right away and come back with the answer.

Thanx for your help.
Marcel

Mark Yudkin wrote:
> Mixed client versions (fix levels)?
> "Marcel" <mr_nospam@vgelder.com> wrote in message
> news:3f82b9da$0$28892$1b62eedf@news.euronet.nl...
>
>>Hi Everyone,
>>
>>I've got a db2 problem.
>>My Java program connects to a IBM Db2 8.1.3 database.
>>
>>There's only 1 active connection to the database via JDBC type 4 driver.
>>A prepared statement is used to insert 100 to 1000 records in one
>
> sequence.
>
>>Most of the time everything works great, but sometimes an error occurs,
>>the -805 error.
>>
>>The error description says that a package is corrupt or gone, in this
>>case SYSLH205 (but it's always different). I don't know what it is or
>>why it appears. I only use an insert statement. I never throwed anything
>>away.
>>It occurs on the production and testdatabase. So I don't think that it
>>has nothing to do with the installation of the database. Or that I've to
>>bind a package.
>>
>>Has anybody a explanation why it happens? And better how it can be
>>solved (with a workarround is als good).
>>
>>Thanx in advance,
>>Marcel Rokers
>>
>>The code:
>>
>>...
>>SQLins =
>> "INSERT INTO "
>>+ Constants.DB2SCHEMA
>>+ ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
>>
>>insertStmt = db2.getConnection().prepareStatement(SQLins);
>>
>>while (...) {
>>...
>>insertStmt.setInt(1, measureID);
>>insertStmt.setTimestamp(2, time);
>>insertStmt.setFloat(3, value);
>>insertStmt.setInt(4, shiftID);
>>insertStmt.executeUpdate();
>>...
>>}
>>insertStmt.close();
>>...
>>
>>The error message that occurs:
>>
>>SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
>>NULLID.SYSLH205 0X5359534C564C3031
>>com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
>>51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
>>at com.ibm.db2.jcc.a.co.e(co.java:1361)
>>at com.ibm.db2.jcc.b.bd.o(bd.java:545)
>>at com.ibm.db2.jcc.b.bd.g(bd.java:124)
>>at com.ibm.db2.jcc.b.bd.a(bd.java:42)
>>at com.ibm.db2.jcc.b.r.a(r.java:31)
>>at com.ibm.db2.jcc.b.bp.g(bp.java:103)
>>at com.ibm.db2.jcc.a.co.g(co.java:968)
>>at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
>>at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
>>at com.ibm.db2.jcc.a.cp.K(cp.java:316)
>>at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
>>at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
>>at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
>>at
>
> com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
>
>>at
>>
>
> com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
> a:113)
>
>>at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
>>
>
>
>