cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mr.abanjo <mr.aba...@gmail.com>
Subject Autogenerated column by DB
Date Mon, 23 Jul 2007 09:23:53 GMT
Hi,
sometimes, i must insert or update records in a table that has
auto-generated column (es: MS Access --> counter)
When i need to save data, first i check if i already have an object that
matck the key that come from user (maybe he has insert it manually, or maybe
is auto-generated.. so i have a null value from the form):

      dtOb = DataObjectUtils.objectForPK(dataContext, entity, compoundKey);

If the key is not specified by user, the "compoundKey" is null, and the code
above return also a null DataObject.

Now i know that is the time to create a new record:

    dtOb = dataContext.createAndRegisterNewObject(entity);

then, i insert all required values:
   dtOb.writeProperty(....)

 ... BUT NOT the auto-generated column.

When i perform a commit, Cayenne return me an error, because in the
generated INSERT query, is still present the auto-generated column, and the
value assigned is NULL.

How i can tell to cayenne to ignore the column, in way that the generated
INSERT query doesn't contains it?
There are other ways to manage this kind of operation?

Thanks
D.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message