sql error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

sql error

Pal Infocom Technologies-2
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!)))]