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