You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@apache.org> on 2014/04/21 10:01:41 UTC
[jira] [Closed] (OFBIZ-778) Confusion in entity engine if schema is
named prod (and probably other table name prefixes)
[ https://issues.apache.org/jira/browse/OFBIZ-778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacopo Cappellato closed OFBIZ-778.
-----------------------------------
> Confusion in entity engine if schema is named prod (and probably other table name prefixes)
> -------------------------------------------------------------------------------------------
>
> Key: OFBIZ-778
> URL: https://issues.apache.org/jira/browse/OFBIZ-778
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Reporter: Eriks Dobelis
> Priority: Trivial
>
> I checked out fresh version from SVN today, and started to get lines like these in console.log for all prod_* tables.
> 2007-03-05 22:05:42,156 (main) [ DatabaseUtil.java:351:WARN ] Entity [ProdCatalogCategory] has no table in the database
> 2007-03-05 22:05:42,158 (main) [ DatabaseUtil.java:359:ERROR] Could not create table [prod.PROD_CATALOG_CATEGORY]: SQL Exception while executing the following:
> CREATE TABLE prod.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID VARCHAR(20) NOT NULL, PRODUCT_CATEGORY_ID VARCHAR(20) NOT NULL, PROD_CATALOG_CATEGORY_TYPE_ID VARCHAR(20) NOT NULL, FROM_DATE TIMESTAMPTZ NOT NULL, THRU_DATE TIMESTAMPTZ, SEQUENCE_NUM NUMERIC(18,0), LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT PK_PROD_CATALOG_CATEGORY PRIMARY KEY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE))
> Error was: org.postgresql.util.PSQLException: ERROR: relation "prod_catalog_category" already exists
> Table actually exists in the database. Coincidence is that I named schema "prod", which probably is the reason for confusion for entity engine.
--
This message was sent by Atlassian JIRA
(v6.2#6252)