The AS400 schema/library you are using does not have journalling turned on - but the AS400 JDBC driver needs it turned on. See
http://www-03.ibm.com/servers/enable/site/java/jdbc/jdbcfaq.html#B20 In short : for simplicity, you should create the AS400 library using either of theses SQL statements CREATE COLLECTION or CREATE SCHEMA, but not the CL command CRTLIB. It is possible to enable journalling on the underlying files in a normal AS400 Library, but it's really hard work - it's really best to just do it the easy way. Cheers, Charles. -----Original Message----- From: ABOU LINA [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 12:32 To: [EMAIL PROTECTED]; ojb-user@db.apache.org Subject: Urgent issue : OJB_HL_SEQ not valid for operation Hi, ojb can't generate a sequence number for insert.... !!! i got this msg error whene deploying the war under AS400 and Websphere 6.0 : SQL failure while insert object data for class org.apache.ojb.broker.util.sequence.HighLowSequence, PK of the given object is [ tableName=global - default sequence name fieldName=deprecatedColumn], object was [EMAIL PROTECTED] - default sequence name,fieldName=deprecatedColumn,grabSize=5,version=1,maxKey=10005,currentKey =10000], exception message is [[SQL7008] Table OJB_HL_SEQ for DB2ADMIN *not valid for operation*], SQL code [55019] thx ___________________________________________________________ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]