it works when i put the private --> static <---long tempKey , is it right
to do that in the SequenceManagerNativeImpl?
thanks
Remi
----- Original Message -----
From: "Rémi Bars" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 10:43 AM
Subject: Re: Identity
> sorry it works fine now i have found a old code in my ojb....
>
> Remi
> ----- Original Message -----
> From: "Rémi Bars" <[EMAIL PROTECTED]>
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 10, 2004 10:41 AM
> Subject: Re: Identity
>
>
> > Hello
> >
> > i have a bug on rc5, i got the same in rc4 (see beelow) but whith some
> > changes it has worked. I have try to put the same code in rc5 and i get
> the
> > following error. I m a on sybase with rc5 and i use identity columns
> >
> > rg.odmg.LockNotGrantedException: Can not lock
> >
>
[EMAIL PROTECTED]
> > for WRITE
> > at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source
> >
> > thanks
> >
> > remi
> >
> >
> > ----- Original Message -----
> > From: "Rémi Bars" <[EMAIL PROTECTED]>
> > To: "OJB Users List" <[EMAIL PROTECTED]>
> > Sent: Thursday, November 27, 2003 5:45 PM
> > Subject: Re: Identity
> >
> >
> > > ok thanks it works fine now
> > >
> > > Remi
> > >
> > > ----- Original Message -----
> > > From: "Armin Waibel" <[EMAIL PROTECTED]>
> > > To: "OJB Users List" <[EMAIL PROTECTED]>
> > > Sent: Thursday, November 27, 2003 5:31 PM
> > > Subject: Re: Identity
> > >
> > >
> > > > Hi,
> > > >
> > > > I think this is a bug in SequenceManagerNativeImpl.
> > > > This should be fixed with current CVS.
> > > > A workaround for rc4 could be a replacement of
> > > >
> > > > protected long getUniqueLong(FieldDescriptor field) throws
> > > > SequenceManagerException
> > > > {
> > > > return -1;
> > > > }
> > > >
> > > > with
> > > >
> > > > private long tempKey = -1;
> > > >
> > > > protected long getUniqueLong(FieldDescriptor field) throws
> > > > SequenceManagerException
> > > > {
> > > > /*
> > > > workaround for locking problems of new objects
> > > > We need unique 'dummy keys' for new objects before storing
> > > > */
> > > > return --tempKey;
> > > > }
> > > >
> > > > We need a different temporary key for each requested
> > > > key. This key will be replaced by the Identity value
> > > > after the object was written to DB.
> > > >
> > > > HTH
> > > > regards,
> > > > Armin
> > > >
> > > > Rémi Bars wrote:
> > > >
> > > > > hi,
> > > > >
> > > > > i have try to put this in my code
> > > > >
> > > > > public String getLastInsertIdentityQuery(String tableName)
> > > > > {
> > > > > return "select @@identity"; (i need wait for an upgrade on
> > > sybase
> > > > > and test select last_insert_id() )
> > > > > }
> > > > >
> > > > >
> > > > >
> > > > > it works fine for the first record when i try to insert a second
> > record
> > > i
> > > > > get :
> > > > >
> > > > > org.odmg.LockNotGrantedException: Can not lock
> > > > > [EMAIL PROTECTED] for WRITE
> > > > >
> > > > > at
> org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:279)
> > > > >
> > > > > what does it means? (sometimes it works.....when i m a on
debugger)
> > > > >
> > > > > remi
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Rémi Bars" <[EMAIL PROTECTED]>
> > > > > To: "OJB Users List" <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, November 27, 2003 10:02 AM
> > > > > Subject: Re: Identity
> > > > >
> > > > >
> > > > >
> > > > >>i m using sybase
> > > > >>
> > > > >>where can i find the platformů implementation?
> > > > >>
> > > > >>----- Original Message -----
> > > > >>From: "Armin Waibel" <[EMAIL PROTECTED]>
> > > > >>To: "OJB Users List" <[EMAIL PROTECTED]>
> > > > >>Sent: Thursday, November 27, 2003 9:59 AM
> > > > >>Subject: Re: Identity
> > > > >>
> > > > >>
> > > > >>
> > > > >>>which DB do you use?
> > > > >>>the platform implementation class have to
> > > > >>>override
> > > > >>>
> > > > >>>public String getLastInsertIdentityQuery(String tableName)
> > > > >>>{
> > > > >>> // return the sql string to query last inserted Identity
value
> > > > >>>}
> > > > >>>
> > > > >>>regards,
> > > > >>>Armin
> > > > >>>
> > > > >>>Rémi Bars wrote:
> > > > >>>
> > > > >>>
> > > > >>>>hi,
> > > > >>>>
> > > > >>>>i have done the change and all my records are in the database.
But
> > now
> > > > >
> > > > > i
> > > > >
> > > > >>get
> > > > >>
> > > > >>>>this error :
> > > > >>>>
> > > > >>>>what does it mean?
> > > > >>>>
> > > > >>>>thanks !
> > > > >>>>
> > > > >>>>remi
> > > > >>>>
> > > > >>>>org.apache.ojb.broker.util.sequence.SequenceManagerException:
> > > > >>>>java.lang.UnsupportedOperationException: This feature is not
> > supported
> > > > >>
> > > > >>by
> > > > >>
> > > > >>>>this implementation
> > > > >>>>
> > > > >>>> at
> > > > >>>>
> > > > >>
> > > > >
> > >
> >
>
org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.getLastInsert(
> > > > >
> > > > >>>>Unknown Source)
> > > > >>>>
> > > > >>>> at
> > > > >>>>
> > > > >>
> > > > >
> > >
> >
>
org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.afterStore(Unk
> > > > >
> > > > >>>>nown Source)
> > > > >>>>
> > > > >>>> at
> > > > >>>>
> > > > >>
> > > > >
> > >
> >
>
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker
> > > > >
> > > > >>>>Impl.java:1985)
> > > > >>>>
> > > > >>>> at
> > > > >>>>
> > > > >>
> > > > >
> > >
> >
>
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
> > > > >
> > > > >>>>.java:1891)
> > > > >>>>
> > > > >>>> at
> > > > >>>>
> > > > >>
> > > > >
> > >
> >
>
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
> > > > >
> > > > >>>>.java:1849)
> > > > >>>>
> > > > >>>> at
> > > > >
> > > > >
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
> > > > >
> > > > >>>>Source)
> > > > >>>>
> > > > >>>> at
> > > > >
> > > > >
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
> > > > >
> > > > >>>>Source)
> > > > >>>>
> > > > >>>> at org.apache.ojb.odmg.states.StateNewDirty.commit(Unknown
> Source)
> > > > >>>>
> > > > >>>> at
> > org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(Unknown
> > > > >>>>Source)
> > > > >>>>
> > > > >>>> at org.apache.ojb.odmg.ObjectEnvelopeTable.commit(Unknown
Source)
> > > > >>>>
> > > > >>>> at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(Unknown
> > > > >>
> > > > >>Source)
> > > > >>
> > > > >>>> at org.apache.ojb.odmg.TransactionImpl.prepare(Unknown Source)
> > > > >>>>
> > > > >>>> at org.apache.ojb.odmg.TransactionImpl.commit(Unknown Source)
> > > > >>>>
> > > > >>>>
> > > > >>>>----- Original Message -----
> > > > >>>>From: "Armin Waibel" <[EMAIL PROTECTED]>
> > > > >>>>To: "OJB Users List" <[EMAIL PROTECTED]>
> > > > >>>>Sent: Wednesday, November 26, 2003 6:24 PM
> > > > >>>>Subject: Re: Identity
> > > > >>>>
> > > > >>>>
> > > > >>>>
> > > > >>>>
> > > > >>>>>doh! Seems I'm tired or dumb ;-)
> > > > >>>>>I mean autoincrement="true"
> > > > >>>>>Or did you implement your owm sequence manager?
> > > > >>>>>
> > > > >>>>>abashed,
> > > > >>>>>Armin
> > > > >>>>>
> > > > >>>>>Armin Waibel wrote:
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>>Hi,
> > > > >>>>>>
> > > > >>>>>>assume you are using SequenceManagerNativeImpl?
> > > > >>>>>>Please set primarykey="true"
> > > > >>>>>>Which OJB version?
> > > > >>>>>>
> > > > >>>>>>regards
> > > > >>>>>>Armin
> > > > >>>>>>
> > > > >>>>>>Rémi Bars wrote:
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>>>Hi all,
> > > > >>>>>>>
> > > > >>>>>>>i m trying to use identity on sybase with the odmg api. I don
t
> > > > >>>>>>>understand
> > > > >>>>>>>why only one object is insert in my table, when i try to add
a
> > > > >
> > > > > second
> > > > >
> > > > >>>>>>>object
> > > > >>>>>>>i get no error but no record too.
> > > > >>>>>>>
> > > > >>>>>>>have u an idea?
> > > > >>>>>>>
> > > > >>>>>>>thanks for ur help!
> > > > >>>>>>>
> > > > >>>>>>>here is my repository
> > > > >>>>>>>
> > > > >>>>>>><class-descriptor class='Structure' table='Structure' >
> > > > >>>>>>> <field-descriptor
> > > > >>>>>>> name="id"
> > > > >>>>>>> column="id"
> > > > >>>>>>> jdbc-type="numeric"
> > > > >>>>>>> primarykey="true"
> > > > >>>>>>> autoincrement="false"
> > > > >>>>>>> access="readonly"
> > > > >>>>>>> />
> > > > >>>>>>> <field-descriptor name='_Nom' column='nom'
> > > > >>>>>>>jdbc-type='VARCHAR'/>
> > > > >>>>>>></class-descriptor>
> > > > >>>>>>>
> > > > >>>>>>>here is my table
> > > > >>>>>>>CREATE TABLE Structure (
> > > > >>>>>>>
> > > > >>>>>>>id numeric(4,0) identity not null,
> > > > >>>>>>>
> > > > >>>>>>>nom VARCHAR(50) NULL )
> > > > >>>>>>>
> > > > >>>>>>>
> > > > >>>
> > > >
> >
>>>>>---------------------------------------------------------------------
> > > > >>>>>
> > > > >>>>>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>>>>>>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>>>>>>
> > > > >>>>>>>
> > > > >>>>>>>
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>>
> > > >
> > >
> >
>
>>>>>>---------------------------------------------------------------------
> > > > >>>>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>>>>>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>
> > > >
> >
>>>>>---------------------------------------------------------------------
> > > > >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>>>>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>>>>
> > > > >>>>>
> > > > >>>>
> > > > >>>>
> > > > >>>>
> > > >
> >
>>>>---------------------------------------------------------------------
> > > > >>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>>>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>>>
> > > > >>>>
> > > > >>>>
> > > > >>>
> > > > >>>
> > > > >>>
> > > >
> >>>---------------------------------------------------------------------
> > > > >>>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>>
> > > > >>>
> > > > >>
> > > > >>
> > > >
> >>---------------------------------------------------------------------
> > > > >>To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >>For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > > >
> > > >
> > ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > >
> > > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
