Perfect, just what I needed.
Thanks,
Brett
On 6/26/06, David E. Jones <
[hidden email]> wrote:
>
> Just use the attribute on the entity element to turn off those auto fields (no-auto-field="true").
>
> -David
>
>
> Brett Palmer wrote:
> > I'm trying to use the entity engine to export data from Oracle to
> > Postgres. The tables are from a 3rd party application and not part of
> > the ofbiz schema. I have successfully mapped the table to the
> > appropriate ofbiz fields and successfully connected to the database.
> >
> > The problem I'm having is when I use webtools to export the data I get
> > a SQL error because the entity engine adds the following ofbiz columns
> > to the SQL query:
> >
> > LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP,
> > CREATED_TX_STAMP
> >
> >
> > Since the table is not an ofbiz entity the columns do not exist and
> > the generated query will fail. Is there a way to specify in the
> > entity model to only use those columns that are explicitly defined in
> > the definition file?
> >
> > Thanks in advance for your help.
> >
> >
> >
> > Brett
>
Locked
