about database

[Selvakumar Ganesan]

Hai,
      I got an error when I create a new product after making ofbiz
compatible  with mysql database.The error is as follow

 The Following Errors Occurred:

Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service
invocation error (Could not commit transaction for service [createProduct]
call: Roll back error, could not commit transaction, was rolled back instead
because of: Error in simple-method [
[file:/E:/ofbizframe/ofbiz-latest/ofbiz-release9.04/applications/product/script/org/ofbiz/product/olap/ProductDimensionServices.xml#prepareProductDimensionData]]:
Error running the simple-method: Error in simple-method operation
[<set-nonpk-fields/>]: java.lang.IllegalArgumentException: Type id-ne not
found for entity [ProductDimension]; probably because there is no datasource
(helper) setup for the entity group that this entity is in:
[org.ofbiz.olap]<br/>null)

what should I do further.

Thanks in advance.                  regards

                                        Selvakumar Ganesan

[BJ Freeman]

look in the beginning of the log similar to this, but for mysql
2010-04-29 06:40:46,187 (main) [   GenericDelegator.java:276:INFO ]
Doing database check as requested in entityengine.xml with addMissing=true
2010-04-29 06:40:51,531 (main) [       DatabaseUtil.java:816:INFO ]
Database Product Name is Apache Derby
2010-04-29 06:40:51,546 (main) [       DatabaseUtil.java:817:INFO ]
Database Product Version is 10.5.3.0 - (802917)
2010-04-29 06:40:51,546 (main) [       DatabaseUtil.java:825:INFO ]
Database Driver Name is Apache Derby Embedded JDBC Driver
2010-04-29 06:40:51,546 (main) [       DatabaseUtil.java:826:INFO ]
Database Driver Version is 10.5.3.0 - (802917)
2010-04-29 06:40:51,546 (main) [       DatabaseUtil.java:827:INFO ]
Database Driver JDBC Version is 4.0
2010-04-29 06:40:51,546 (main) [       DatabaseUtil.java:836:INFO ]
Database Setting/Support Information (those with a * should be true):

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Selvakumar Ganesan sent the following on 5/3/2010 8:11 AM:

> Hai,
>       I got an error when I create a new product after making ofbiz
> compatible  with mysql database.The error is as follow
>
>  The Following Errors Occurred:
>
> Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service
> invocation error (Could not commit transaction for service [createProduct]
> call: Roll back error, could not commit transaction, was rolled back instead
> because of: Error in simple-method [
> [file:/E:/ofbizframe/ofbiz-latest/ofbiz-release9.04/applications/product/script/org/ofbiz/product/olap/ProductDimensionServices.xml#prepareProductDimensionData]]:
> Error running the simple-method: Error in simple-method operation
> [<set-nonpk-fields/>]: java.lang.IllegalArgumentException: Type id-ne not
> found for entity [ProductDimension]; probably because there is no datasource
> (helper) setup for the entity group that this entity is in:
> [org.ofbiz.olap]<br/>null)
>
> what should I do further.
>
> Thanks in advance.                  regards
>
>                                         Selvakumar Ganesan
>