> Than I suppose that the problem is hsqldb, which return "ID" as column > name, also if it was created as "id", am i right?
I've never used HSQLDB, but I know Derby likes to think of its table and field names as all upper-case. Derby does not, however, appear to be case sensitive from my experience. -----Original Message----- From: Steave [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2008 9:42 AM To: [email protected] Subject: Re: errors with derby and hsqldb (i need to switch from mysql to an embedded db) 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 <[EMAIL PROTECTED]> > Oh, i meant you should probably rename DbAttribute 'id' to 'ID' in > Cayenne Modeler > > 2008/9/19, Andrey Razumovsky <[EMAIL PROTECTED]>: > > 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 <[EMAIL PROTECTED]>: > > > > > ps, no rows in Canvass have id column = null , > > > and the table reflects the ddl written in my last mail > > > > > > > > > 2008/9/18 Steave <[EMAIL PROTECTED]> > > > > > > > > > > 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 <[EMAIL PROTECTED]> > > > > > > > > > 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. > > > >> > > > > > > > > > > > > > >
