YES IT WORKS!!!!
I've modified both the SQLTemplate string and dbAttribute in Cayenne Modeler
(i've put every table and column name in uppercase, just to be sure (it also
looks more sql compliant :-) )) and now it works!!!
I also had to change a "db:id" in "db:ID" somewhere in an ordering clausule,
but it's ok :-)
Than I suppose that the problem is hsqldb, which return "ID" as column name,
also if it was created as "id", am i right?
Scott, Andrey, thank you a lot!!!!
Also thanks to all the guys who spend time to develop Cayenne and support
stupid guys with stupid questions like mine :-)
Thank you!!
ps, sorry for "Steave" name that appair when I send a mails with gmail, I
don't know why it happens and how to change this behivour.
My name is Stefano Parravicini, sorry if I forgot to inroduce me :-)
Thank you again
2008/9/19 Andrey Razumovsky <razumovsky.andre..mail.com>
> Oh, i meant you should probably rename DbAttribute 'id' to 'ID' in
> Cayenne Modeler
>
> 2008/9/19, Andrey Razumovsky <razumovsky.andre..mail.com>:
> > Hi Steave,
> >
> > ID is obviously not null following snapshot output (values={TITLE=asd,
> > ID=200}), but ID is uppercase here, so when you use dataRow.get("id")
> > it will return null. I think you must use uppercased "id", e.g.
> >
> >
> > SQLTemplate template = new SQLTemplate(CayCanvass.class, "select *
> >
> > from Canvass c where c.ID = (select MAX(c.ID) from Canvass c)");
> >
> > Still, I do not know enough about Derby and HSQL to tell for sure why
> > it happened.
> >
> > Hope that helps,
> > Andrey
> >
> > 2008/9/18, Steave <stefanonafet..mail.com>:
> >
> > > ps, no rows in Canvass have id column = null ,
> > > and the table reflects the ddl written in my last mail
> > >
> > >
> > > 2008/9/18 Steave <stefanonafet..mail.com>
> > >
> > >
> > > > For schema, do you intend the db schema?
> > > > If it is,
> > > >
> > > > well, this is the CREATE statement generated by modeler for hsqldb:
> > > >
> > > > CREATE CACHED TABLE Canvass (id BIGINT NOT NULL, title VARCHAR(150)
> NULL,
> > > > PRIMARY KEY (id)
> > > > ;
> > > >
> > > > In the modeler, both "Pk" and "Mandarory" are checked for id
> column.
> > > >
> > > >
> > > > 2008/9/18 Scott Anderson <sanderso..irvana.com>
> > > >
> > > > > Null value for 'id'.
> > > >>
> > > >> Is id set to NULL in the schema, but MANDATORY in the Cayenne map?
> I'm
> > > >> not sure if I'm interpreting the error correctly, but it sounds
> like
> > > >> Cayenne sees a NULL where it doesn't expect one.
> > > >>
> > > >
> > > >
> > >
> >
>
This archive was generated by hypermail 2.0.0 : Fri Sep 19 2008 - 09:42:55 EDT