[ 
https://issues.apache.org/jira/browse/OFBIZ-1417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Chris Lombardi closed OFBIZ-1417.
---------------------------------

    Resolution: Duplicate

> Native database error messages don't show in the log
> ----------------------------------------------------
>
>                 Key: OFBIZ-1417
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1417
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Chris Lombardi
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> Native database error messages don't get displayed in the ofbiz log.  It 
> would be very nice if we could capture the error message for SQL errors and 
> print them in the log.  This is an example of an error message generated by 
> ofbiz:
> Results in:
> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception 
> while executing the following:
> SELECT I.PARTY_ID, I.PARTY_ID_FROM, I.STATUS_ID, I.BILLING_ACCOUNT_ID, 
> I.INVOICE_DATE, I.PAID_DATE, I.INVOICE_TYPE_ID, I.INVOICE_ID,
> SUM((COALESCE(II.QUANTITY,1) * COALESCE(II.AMOUNT,0))) FROM 
> OFBIZ.INVOICE_ITEM II INNER JOIN OFBIZ.INVOICE I ON II.INVOICE_ID = 
> I.INVOICE_ID GROUP BY I.INVOICE_ID

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to