Re: Identity

Armin Waibel Tue, 10 Feb 2004 03:01:00 -0800

Hi Remin,

R�mi Bars wrote:

it works when i put the private --> static <---long tempKey ,  is it right
to do that in the  SequenceManagerNativeImpl?

hmm, seems the temp key has to be unique arcoss different threads. If you don't do that what's the problem, do you end with an LockNotGrantedException?

regards,
Armin

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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Identity

Reply via email to