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

[Nicolas Malin (Jira)]

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, Release Branch 4.0
            Reporter: Chris Lombardi
            Priority: Minor
             Fix For: SVN trunk, Release Branch 4.0


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.

[Nicolas Malin (Jira)]

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

[Nicolas Malin (Jira)]

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