Re: ORM/Hibernate generator issue

2011-12-03 Thread Matt Quackenbush

Try setting generator=native instead.
On Dec 3, 2011 9:10 PM, Bobby Hartsfield bo...@acoderslife.com wrote:


 I've finally been playing around with ORM lately and I've hit an issue that
 I'm having a hard time finding answers for on Google. Hopefully someone
 here
 knows what the deal.



 Below is a very basic person app with one component (outside of app.cfc)
 and a small index.cfm



 The error I'm seeing is:

 this id generator generates long, integer, short

 Root cause :org.hibernate.id.IdentifierGenerationException: this id
 generator generates long, integer, short



 Basically, I read a xls doc of first and last names and (attempt to) load
 it
 into a tblPeople table.



 The above error happens in inde.cfm when entitySave(obj) is triggered. I
 can
 comment out  entitySave(obj); and not get any errors.



 There are only about 3000 records in people.xls and tblPeople doesn't exist
 yet.



 It is a new, basic install of CF9 on server 2003.



 This worked earlier but I was using the old style cfcomponent / tags in
 person.cfc



 hopefully I'm just missing something obvious to someone else.



 Any help appreciated here.



 Thanks



 ---INDEX.CFM



 cfset ormReload() /

 cfspreadsheet action=read src=#expandPath('.')#\people.xls
 query=sheet headerrow=1 /



 cfloop query=sheet startrow=2

 cfscript

obj = EntityNew(person);



obj.setPersonFname(sheet[personFname][sheet.currentRow]);

obj.setPersonLname(sheet[personLname][sheet.currentRow]);



entitySave(obj);

 /cfscript

 /cfloop









 ---PERSON.CFC

 component persistent=true table=tblpeople

 {

property name=personId fieldtype=id
 generator=increment;

property name=personFname;

property name=personLname;

 }













 ---APPLICATION.CFC

 component

 {

this.name = personTest;



this.ormenabled = true;

this.datasource = peopleTest;

this.ormsettings={dbcreate=update, logsql=true};

this.ormsettings.savemapping = false;



this.clientmanagement=false;

this.sessionmanagement=true;

this.sessiontimeout=#createtimespan(0,0,1,0)#;

this.applicationtimeout=#createtimespan(0,0,1,0)#;

 }





 .:.:.:.:.:.:.:.:.:.:.:.

 Bobby Hartsfield

 http://acoderslife.com

 http://cf4em.com






 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ORM/Hibernate generator issue

2011-12-03 Thread Bobby Hartsfield

Thanks Matt. I swear I did try that earlier but I just tried it again to
make sure I didn't typo it or something earlier and it got past the error.

Today has been one long caching nightmare.

Thanks!

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Saturday, December 03, 2011 10:15 PM
To: cf-talk
Subject: Re: ORM/Hibernate generator issue


Try setting generator=native instead.
On Dec 3, 2011 9:10 PM, Bobby Hartsfield bo...@acoderslife.com wrote:


 I've finally been playing around with ORM lately and I've hit an issue
that
 I'm having a hard time finding answers for on Google. Hopefully someone
 here
 knows what the deal.



 Below is a very basic person app with one component (outside of app.cfc)
 and a small index.cfm



 The error I'm seeing is:

 this id generator generates long, integer, short

 Root cause :org.hibernate.id.IdentifierGenerationException: this id
 generator generates long, integer, short



 Basically, I read a xls doc of first and last names and (attempt to) load
 it
 into a tblPeople table.



 The above error happens in inde.cfm when entitySave(obj) is triggered. I
 can
 comment out  entitySave(obj); and not get any errors.



 There are only about 3000 records in people.xls and tblPeople doesn't
exist
 yet.



 It is a new, basic install of CF9 on server 2003.



 This worked earlier but I was using the old style cfcomponent / tags in
 person.cfc



 hopefully I'm just missing something obvious to someone else.



 Any help appreciated here.



 Thanks



 ---INDEX.CFM



 cfset ormReload() /

 cfspreadsheet action=read src=#expandPath('.')#\people.xls
 query=sheet headerrow=1 /



 cfloop query=sheet startrow=2

 cfscript

obj = EntityNew(person);



obj.setPersonFname(sheet[personFname][sheet.currentRow]);

obj.setPersonLname(sheet[personLname][sheet.currentRow]);



entitySave(obj);

 /cfscript

 /cfloop









 ---PERSON.CFC

 component persistent=true table=tblpeople

 {

property name=personId fieldtype=id
 generator=increment;

property name=personFname;

property name=personLname;

 }













 ---APPLICATION.CFC

 component

 {

this.name = personTest;



this.ormenabled = true;

this.datasource = peopleTest;

this.ormsettings={dbcreate=update, logsql=true};

this.ormsettings.savemapping = false;



this.clientmanagement=false;

this.sessionmanagement=true;

this.sessiontimeout=#createtimespan(0,0,1,0)#;

this.applicationtimeout=#createtimespan(0,0,1,0)#;

 }





 .:.:.:.:.:.:.:.:.:.:.:.

 Bobby Hartsfield

 http://acoderslife.com

 http://cf4em.com






 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348946
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm