cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Yocum <>
Subject Re: Setting Default Values for Entities
Date Sat, 22 Dec 2007 23:00:54 GMT
Hi Andrus,
  My problem is stemming from not being able to get the defaults set in the first place. 
When I make a new object and do not set any of the objects properties I get an insert something
like this going on....
  INSERT INTO tablename(property1, property2, property3) VALUES(NULL, NULL, NULL)
  of course Cayenne uses 'bind'.
  what I would like is for the insert to be like this...
  INSERT INTO tablename() VALUES()
  or this also would work...
  INSERT INTO tablename(property1,property2,property3) VALUES(DEFAULT, DEFAULT, DEFAULT)
  DEFAULT is a key word in MySQL that sets the field to the columns default value.
  So, I am basically trying to figure out how to have Cayenne either substitute DEFAULT for
all NULLs, omit the property on INSERT if it is NULL, or my plan for a work around was to
retrieve the default value metadata from the MySQL server and then set all the fields to their
default values using a util method like this ( this is mostly pseudocode )
  public DataObject SetDefaultsForDataObject(DataObject obj)
       Results = Execute("SHOW columns FROM obj.tablename");
             field = Results.get("Field");
             default = Results.get("Default");
       return obj;
  Is there anyway to not put the properties in the INSERT statement if they are NULL, that
is how MySQL knows to do the default unless you specify DEFAULT keyword.
  Any additional help on this would be very appreciated!
  Thanks again,

Andrus Adamchik <> wrote:
  Syncing DB defaults with entities is indeed a painful exercise as JDBC 
provides no callback mechanism to let the app know which defaults were 
set. Here is one more brute force mechanism to achieve that - 
invalidate all newly inserted objects. E.g., using 3.0 API:

List newObjects = context.newObjects();
context.performGenericQuery(new RefreshQuery(newObjects));


On Dec 22, 2007, at 11:57 PM, Aristedes Maniatis wrote:

> On 23/12/2007, at 5:30 AM, Adam Yocum wrote:
>> 'SHOW columns FROM tablename'
> This might be a good starting point:
> Ari Maniatis
> -------------------------->
> ish
> Level 1, 30 Wilson Street Newtown 2042 Australia
> phone +61 2 9550 5001 fax +61 2 9550 4001
> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Never miss a thing.   Make Yahoo your homepage.
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message