[jira] Updated: (OFBIZ-1417) Native database error messages don't show in the log

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

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

Jacques Le Roux updated OFBIZ-1417:
-----------------------------------

        Fix Version/s:     (was: Release Branch 4.0)
    Affects Version/s:     (was: Release Branch 4.0)

No improvements in releases

> 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.