i have made some changes to product table. when i try to create product i get following error
The Following Errors Occurred: ERROR: Could not complete the Create an Product [file:/home/vinod/Desktop/ofbiz2/applications/product/script/org/ofbiz/product/product/ProductServices.xml#createProduct] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:Product][brandName,null()][chargeShipping,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-06-21 16:45:37.411(java.sql.Timestamp)][createdStamp,2007-06-21 16:45:37.416(java.sql.Timestamp)][createdTxStamp,2007-06-21 16:45:37.334(java.sql.Timestamp)][description,null()][internalName,dsadsa(java.lang.String)][introductionDate,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-06-21 16:45:37.411(java.sql.Timestamp)][lastUpdatedStamp,2007-06-21 16:45:37.416(java.sql.Timestamp)][lastUpdatedTxStamp,2007-06-21 16:45:37.334(java.sql.Timestamp)][leadTime,null()][listPrice,null()][productId,dsad(java.lang.String)][productTypeId,CABLE(java.lang.String)][returnable,null()][salesDiscWhenNotAvail,null()][salesDiscontinuationDate,null()][standardDealerCost,null()][supportDiscontinuationDate,null()][taxDutyCode,null()][taxable,null()][upc,null()][weight,null()][weightUomId,null()] (while inserting: [GenericEntity:Product][brandName,null()][chargeShipping,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-06-21 16:45:37.411(java.sql.Timestamp)][createdStamp,2007-06-21 16:45:37.416(java.sql.Timestamp)][createdTxStamp,2007-06-21 16:45:37.334(java.sql.Timestamp)][description,null()][internalName,dsadsa(java.lang.String)][introductionDate,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-06-21 16:45:37.411(java.sql.Timestamp)][lastUpdatedStamp,2007-06-21 16:45:37.416(java.sql.Timestamp)][lastUpdatedTxStamp,2007-06-21 16:45:37.334(java.sql.Timestamp)][leadTime,null()][listPrice,null()][productId,dsad(java.lang.String)][productTypeId,CABLE(java.lang.String)][returnable,null()][salesDiscWhenNotAvail,null()][salesDiscontinuationDate,null()][standardDealerCost,null()][supportDiscontinuationDate,null()][taxDutyCode,null()][taxable,null()][upc,null()][weight,null()][weightUomId,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID, UPC, FACILITY_ID, INTRODUCTION_DATE, SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE, SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, DESCRIPTION, LEAD_TIME, STANDARD_DEALER_COST, LIST_PRICE, WEIGHT_UOM_ID, WEIGHT, RETURNABLE, TAXABLE, TAX_DUTY_CODE, CHARGE_SHIPPING, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Unable to create PreparedStatement!)))] -- View this message in context: http://www.nabble.com/sql-error-tf3958095.html#a11231091 Sent from the OFBiz - User mailing list archive at Nabble.com.
