Re: Identity

Armin Waibel Tue, 10 Feb 2004 02:48:15 -0800

puh! glad to hear that!

regards,
Armin

Rémi Bars wrote:

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]

Re: Identity

Reply via email to