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
