sql error

[amit charaya <of...@palinfocom.net>]

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.