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.

Reply via email to