In repository.xml you can set the field as read-only. Works for me. HTH Gerhard
"nntp://news.gmane.org/gmane.group.name" <[EMAIL PROTECTED]> Gesendet von: news <[EMAIL PROTECTED]> 05.09.2003 17:41 Bitte antworten an "OJB Users List" An: [EMAIL PROTECTED] Kopie: [EMAIL PROTECTED] Thema: More on Identity columns in db/2 I came back to this topic again and realised that INSERT statements in OJB are always trying to send the PK column also in the query. That being the case, How do we use "SequenceManagerNativeImpl" ? The two dbs that I know (SQLServer and db/2) do not allow u to pass the value for an Identity Column in SQL statement. Am I missing some thing ? TIA akhil "Akhil Kumar" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > > > Hi, > This is a response to #OJB201... > (http://scarab.werken.com/issues/id/OJB201) > I had spent some time earlier on the approach suggested in this issue but > did not post it for the reason documented below > I thaught it'll be better that others also understand the implications (of > Identity Column based SeqMgr ) > > Platform.getLastInsertIdentity() should not be implemented as described in > the defect ! > > The db/2 scalar function 'identity_val_local() ' does not take any > parameter... > it is supposed to return the value of last identity column that was > incremented ! > The reporter of the defect has recommended using > "select identity_val_local() from <tableName> fetch first ro only" > however the above SQL has nothing to do with the <tableName>.. > > running it is as good as running: "values identity_val_local()" which does > not take any table name. > and it can make the usage of "values identity_val_local()" : potentially > dangerous: > in the following scenario: > > -Table T1 uses Identity column (and used in O-R mapping) > -A Trigger is defined for INSERTS in T1 which inserts a record in T2 (T2 > has nothing to do with OR business) > (such approaches are there in many systems e.g. automatically > calculating summaries etc) > -both T1 and T2 use Identity columns. > -OJB inserts a record in T1 which leads to another record getting added to > T2 > -"values identity_val_local()" will return the value of identity column in > T2 and not T1, as required by the native based SeqMgr. > > thanks > akhil --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]