getting sql exception

[Pal Infocom Technologies-2]

i am trying to delete an entity using simple method that has following lines of code

<make-value entity-name="Manufacturer" map-name="parameters" value-name="newEntity"/>
       
       <remove-by-and entity-name="Manufacturer" map-name="parameters"></remove-by-and>

i am getting following exception

[     RequestHandler.java:305:ERROR] Request manfact caused an error with the following message: ERROR: Could not complete the create a manufacture [file:/home/vinod/Desktop/amit/ofbiz/hot-deploy/hello1/script/org/ofbiz/hello1/ItemServices.xml#createManufacturer] process [problem removing the Manufacturer entity by and: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM OFBIZ.MANUFACTURER WHERE (locale = 'en_US' AND MANUFACTURER = 'nokia23' AND DESCRIPTION = '23') (Unable to create PreparedStatement!))]

thanks if you can help

[David E Jones]

There is probably more detail in the log file. Could you take a look at that and if necessary send it over?

-David


amit charaya wrote:

> i am trying to delete an entity using simple method that has following lines
> of code
>
> <make-value entity-name="Manufacturer" map-name="parameters"
> value-name="newEntity"/>
>        
>        <remove-by-and entity-name="Manufacturer"
> map-name="parameters"></remove-by-and>
>
> i am getting following exception
>
> [     RequestHandler.java:305:ERROR] Request manfact caused an error with
> the following message: ERROR: Could not complete the create a manufacture
> [file:/home/vinod/Desktop/amit/ofbiz/hot-deploy/hello1/script/org/ofbiz/hello1/ItemServices.xml#createManufacturer]
> process [problem removing the Manufacturer entity by and: Generic Entity
> Exception occured in deleteByCondition (SQL Exception while executing the
> following:DELETE FROM OFBIZ.MANUFACTURER WHERE (locale = 'en_US' AND
> MANUFACTURER = 'nokia23' AND DESCRIPTION = '23') (Unable to create
> PreparedStatement!))]
>
> thanks if you can help