RE: Urgent issue : OJB_HL_SEQ not valid for operation

[Charles Anthony <ch...@hpdsoftware.com>]

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:amarwane@gmail.com]
Sent: 21 March 2006 12:32
To: arminw@apache.org; 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
org.apache.ojb.broker.util.sequence.HighLowSequence@a903f6e[tableName=global
- 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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org