RE: ORM/Hibernate generator issue
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" 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 tags in
> person.cfc
>
>
>
> hopefully I'm just missing something obvious to someone else.
>
>
>
> Any help appreciated here.
>
>
>
> Thanks
>
>
>
> ---INDEX.CFM
>
>
>
>
>
> query="sheet" headerrow="1" />
>
>
>
>
>
>
>
>obj = EntityNew("person");
>
>
>
>obj.setPersonFname(sheet["personFname"][sheet.currentRow]);
>
>obj.setPersonLname(sheet["personLname"][sheet.currentRow]);
>
>
>
>entitySave(obj);
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---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
Re: ORM/Hibernate generator issue
Try setting generator="native" instead.
On Dec 3, 2011 9:10 PM, "Bobby Hartsfield" 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 tags in
> person.cfc
>
>
>
> hopefully I'm just missing something obvious to someone else.
>
>
>
> Any help appreciated here.
>
>
>
> Thanks
>
>
>
> ---INDEX.CFM
>
>
>
>
>
> query="sheet" headerrow="1" />
>
>
>
>
>
>
>
>obj = EntityNew("person");
>
>
>
>obj.setPersonFname(sheet["personFname"][sheet.currentRow]);
>
>obj.setPersonLname(sheet["personLname"][sheet.currentRow]);
>
>
>
>entitySave(obj);
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---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
ORM/Hibernate generator issue
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 tags in
person.cfc
hopefully I'm just missing something obvious to someone else.
Any help appreciated here.
Thanks
---INDEX.CFM
obj = EntityNew("person");
obj.setPersonFname(sheet["personFname"][sheet.currentRow]);
obj.setPersonLname(sheet["personLname"][sheet.currentRow]);
entitySave(obj);
---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:348944
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
