Posted by
Hao Jiang-4 on
Oct 26, 2005; 10:47pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-need-help-entity-tp136219p136222.html
Thanks Si, in log file I found
7090 [ GenericDelegator.java:178:WARN ] [FieldNameRW] Column name USER
of entity LicenseFile is a reserved word.
7091 [ GenericDelegator.java:178:WARN ] [FieldNameRW] Column name
NUMBER of entity LicenseFile is a reserved word.
7091 [ GenericDelegator.java:178:WARN ] [FieldNameRW] Column name
VERSION of entity LicenseFile is a reserved word.
7091 [ GenericDelegator.java:178:WARN ] [FieldNameRW] Column name
INTERVAL of entity LicenseFile is a reserved word.
maybe that's why the table can't be created (ofbiz or postgresql issue?)
However, I just finished another try.
I create the table "LicenseFile" with only one column: id, this time I
get the table
Then I add some new columns in it, include "user", "number" which above
show us are reserved words
Then I get the table with "number" but no "user"
So I guess "user" is the word shouldn't be the column name
Hao
On Wed, 2005-10-26 at 14:23 -0700, Si Chen wrote:
> Did you log file say anything? When you start up ofbiz the database
> operations are shown in the log file along with response messages. Si
>
> Hao Jiang wrote:
>
> >Hi, are there certain words that can't be used as entity name?
> >
> >After I changed the name from XXFile to XXRecord, I have the table now
> >
> >Or it's just a matter of postgresql
> >
> >Hao
> >
> >On Wed, 2005-10-26 at 10:03 -0600, Hao Jiang wrote:
> >
> >
> >>Hello, I need some help here
> >>
> >>I tried to create a new entity(DB table), I'm using Postgresql 8.0.3
> >>
> >>I believe I did everything right, in a web form I use auto-attributes
> >>from this entity, I get all the fields, in java code I create and insert
> >>new entries into this entity, the service returns success.
> >>
> >>However, I can't find this table in database! I have created several new
> >>entities before, and this is the first time I had this problem.
> >>
> >>What could possibly be wrong?
> >>
> >>Thanks
> >>
> >>Hao
> >>
> >>
> >>
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>
[hidden email]
> >>
http://lists.ofbiz.org/mailman/listinfo/users> >>
> >>
> >>
> >
> >
> >
> >_______________________________________________
> >Users mailing list
> >
[hidden email]
> >
http://lists.ofbiz.org/mailman/listinfo/users> >
> >
> >
>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users>
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users