Re: Using entity engine to export non-ofbiz tables

Posted by David E. Jones on
URL: http://ofbiz.116.s1.nabble.com/Using-entity-engine-to-export-non-ofbiz-tables-tp140210p140211.html


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