Hi to everybody. I'm working with OfBiz using a Oracle DB instead of Derby. I've got some problems selling digital goods. Looking in the logfile I found a first error on the FINANCIALS_IMPORT_PRODUCT_INVENTORY table name (see the quoting): in Oracle the max identifier's length is 30 char. How can I solve this problem?
Thanks in advance for any helps. [ DatabaseUtil.java:353:ERROR] Could not create table [ECOMMERCE.FINANCIALS_IMPORT_PRODUCT_INVENTORY]: SQL Exception while executing the following: CREATE TABLE ECOMMERCE.FINANCIALS_IMPORT_PRODUCT_INVENTORY (PRODUCT_ID VARCHAR2(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, PRODUCT_NAME VARCHAR2(255) CHARACTER SET latin1 COLLATE latin1_general_cs, AVAILABLE_TO_PROMISE NUMBER(18,6), ON_HAND NUMBER(18,6), INVENTORY_VALUE NUMBER(18,2), PROCESSED_TIMESTAMP TIMESTAMP, LAST_UPDATED_STAMP TIMESTAMP, LAST_UPDATED_TX_STAMP TIMESTAMP, CREATED_STAMP TIMESTAMP, CREATED_TX_STAMP TIMESTAMP, CONSTRAINT PK_FINANCIALS_IMPORT_PRODUCT_I PRIMARY KEY (PRODUCT_ID)) CHARACTER SET latin1 COLLATE latin1_general_cs Error was: java.sql.SQLException: ORA-00972: identifier is too long -- View this message in context: http://www.nabble.com/identifier-is-too-long-tf2636842.html#a7359710 Sent from the OFBiz - Dev mailing list archive at Nabble.com.
