[Cayenne-user] Creating or loading Datamap

On Jan 21, 2011, at 5:09 PM, André Rothe wrote:

Hm, it doesn't work. I can perform a SQL query, it returns the
correct number of records, but the properties are NULL.

SelectQuery q = new SelectQuery("Projects");
List projectsTest = this.context.get("test").performQuery(q);

for (Object o : projectsTest) {
DataObject dObj = (DataObject) o;
System.out.println(dObj.readProperty("columnname"));
}

I have defined a DataContext "test" as:

DataMap map = new DataMap(mapName + " map");

DbEntity entity = new DbEntity("tablename");
map.addDbEntity(entity);

DbAttribute attr = new CharacterDbAttribute("columnname", 20, true);
entity.addAttribute(attr);

// more attributes here
// ...

ObjEntity objEntity = new ObjEntity("Projects");
objEntity.setDbEntity(entity);
objEntity.setClassName(CayenneDataObject.class.getName()); // default
map.addObjEntity(objEntity);

DataNode node = new DataNode(mapName + " node");
node.addDataMap(map);
node.setDataSource(store.getDataSource());
node.setAdapter(new AutoAdapter(store.getDataSource()));

DataDomain domain = new DataDomain(mapName + " domain");
domain.addNode(node);
domain.addMap(map);

this.context.put(mapName, domain.createDataContext());

The class CharacterDbAttribute sets the type to VARCHAR, mandatory
and length properties. The field "store" holds the data sources
(instances of PoolManager). mapName = "test".

I think, I don't need a full-defined ObjectEntity, because it is
dynamic. I set only the class name (default) and the DbEntity
instance. So where I have forgotten a call?

Thanks a lot
André

Andrus Adamchik wrote: