Are you sure it was identical? Particularly around CONSTRAINT PK_CDRDATA PRIMARY KEY ())
--- Ruth Hoffman <[EMAIL PROTECTED]> wrote: > Hi Chris: > Just tried that and I still get the identical error. > If it makes any > difference, I've tried this with both Derby & > Postgres - with the same > results. I'm wondering if it is possible to do this? > If not, its ok, I > can work around it. But it would be nice to know and > document if it is a > restriction. > > Thanks again for you suggestions. > Ruth > > Chris Howe wrote: > > >try changing "use-pk-contraint-names" to false in > your > >datasource information. > > > >ie in > ><datasource name="localderbyodbc" > >helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > >schema-name="OFBIZ" > >field-type-name="derby" > >check-on-start="true" > >add-missing-on-start="true" > >use-pk-constraint-names="false"> <!-- Right here > --> > >... > ></datasource> > > > >--- Ruth Hoffman <[EMAIL PROTECTED]> wrote: > > > > > > > >>Hi Chis: > >>I did not try that - due to my ignorance of how to > >>read an xsd. However, > >>I just tried it and I get the following error > (from > >>the error log) while > >>OFBiz attempts to create the new entity, on > startup: > >> > >> Getting Table Info From Database > >> 17327 (main) [ > DatabaseUtil.java:356:WARN > >>] Entity [cdrdata] > >> has no table in the database > >> 17377 (main) [ > >>DatabaseUtil.java:364:ERROR] Could not create > >> table [public.CDRDATA]: SQL Exception while > >>executing the following: > >> CREATE TABLE public.CDRDATA (CALL_SN SERIAL, > >>CORRELATION_ID INT4, > >> ....[left some of the field defs out]... > >>MATCHED_FLAG CHAR(1), > >> CONSTRAINT PK_CDRDATA PRIMARY KEY ()) > >> Error was: java.sql.SQLException: ERROR: > syntax > >>error at or near ")" > >> > >>This is the same error I was getting when I had no > >>prim-key element. The > >>only thing that makes this go "away" is to set one > >>of the fields to a > >>primary key field. Since I'm trying to mimic a > real > >>life database table > >>that has no primary key, (mostly for off-line > >>testing of my > >>application), it would be desirable not to have a > >>primary key field. I'm > >>just wondering if I forgot to set something else - > >>somewhere else? > >> > >>Thanks for your suggestion. I learned something > new > >>and I think I'll go > >>back and try to understand how the xsd can help me > >>troubleshoot future > >>problems. > >> > >>Regards, > >>Ruth > >> > >> > >>Chris Howe wrote: > >> > >> > >> > >>>Did you try defining it as an empty prim-key > group? > >>> > >>>ie <prim-key field=""/> > >>> > >>>As far as the entitymodel.xsd, "prim-key" is a > >>>required element and the attribute "field" is > >>> > >>> > >>required > >> > >> > >>>--- Ruth Hoffman <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>> > >>> > >>> > >>>>Hello All: > >>>>Is this possible: can I create an entity without > a > >>>>primary key? > >>>> > >>>>TIA > >>>>Ruth > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >>> > >>> > > > > > > > > >
