You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Karl Eilebrecht (JIRA)" <ji...@apache.org> on 2007/05/24 15:57:16 UTC
[jira] Created: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Ofbiz SQL-Logging Extension
---------------------------
Key: OFBIZ-1030
URL: https://issues.apache.org/jira/browse/OFBIZ-1030
Project: OFBiz (The Open for Business Project)
Issue Type: New Feature
Components: framework
Affects Versions: SVN trunk
Environment: Win XP
Reporter: Karl Eilebrecht
Priority: Minor
Fix For: SVN trunk
Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
This issue is part of Key-Work Ofbiz Contribution Proposal.
http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
Based on Release: 540035
Includes: -
Required: JIRA-1029, JIRA-1017, JIRA-1016
Recommended: -
Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
DBAccessLogProcessor.java,
DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
SqlLogOutputStrategy.java, SqlLogReplacements.java,
SqlLogStatementInterceptor.java, SqlLogUtils.java,
SQLProcessor.java
Description: This patch adds enhanced logging support for all sql
statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Si Chen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Si Chen reassigned OFBIZ-1030:
------------------------------
Assignee: Si Chen
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Assignee: Si Chen
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: (was: patch9672.patch)
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: OfbizLoggingDbAccessEn.pdf
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz (The Open for Business Project)
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Joerg Herbst (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499614 ]
Joerg Herbst commented on OFBIZ-1030:
-------------------------------------
I haven't tried the patch yet, but seems to be a pretty cool feature.
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz (The Open for Business Project)
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Si Chen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Si Chen reassigned OFBIZ-1030:
------------------------------
Assignee: (was: Si Chen)
sorry everybody, I assigned the wrong issue to myself. In fact, I've not looked at this and don't have an opinion either way.
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Si Chen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570732#action_12570732 ]
Si Chen commented on OFBIZ-1030:
--------------------------------
I like this feature as well and would like to commit it into the trunk if that's okay with everybody else
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "David E. Jones (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570779#action_12570779 ]
David E. Jones commented on OFBIZ-1030:
---------------------------------------
I'm with the patch, especially in terms of what it does.
It does seem like the solution is overly complex, kind of like a logging utility that could be its own little project (small, like an Apache Commons thing). In short what concerns me with that sort of thing, while it might be great, is the maintenance going forward. It may not be a problem per se, but might the code might be neglected in ways that it wouldn't be if it were part of another project, like an Apache Commons thing.
Which is the next point... is there something in Apache Commons or somewhere similar that would do SQL logging like this?
As for OFBiz itself and a simple solution, why not just add some Debug.logVerbose settings, kind of like the stuff in GenericDAO.java on line 755, but maybe less "gated", or rather make it easier to turn those on by changing the standard logging settings in the log4j.xml file.
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Assignee: Si Chen
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: patch9672.patch
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz (The Open for Business Project)
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: OfbizLoggingDbAccessEn.pdf
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: patch9672.patch
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1030) Ofbiz SQL-Logging Extension
Posted by "Karl Eilebrecht (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Eilebrecht updated OFBIZ-1030:
-----------------------------------
Attachment: (was: OfbizLoggingDbAccessEn.pdf)
> Ofbiz SQL-Logging Extension
> ---------------------------
>
> Key: OFBIZ-1030
> URL: https://issues.apache.org/jira/browse/OFBIZ-1030
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Environment: Win XP
> Reporter: Karl Eilebrecht
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OfbizLoggingDbAccessEn.pdf, patch9672.patch
>
>
> This issue is part of Key-Work Ofbiz Contribution Proposal.
> http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal
> Based on Release: 540035
> Includes: -
> Required: JIRA-1029, JIRA-1017, JIRA-1016
> Recommended: -
> Classes: DBAccessLog.java, DBAccessLogEventFactory.java,
> DBAccessLogProcessor.java,
> DefaultSqlLogOutputStrategy.java, SqlLogNamedArgsMap.java,
> SqlLogOutputStrategy.java, SqlLogReplacements.java,
> SqlLogStatementInterceptor.java, SqlLogUtils.java,
> SQLProcessor.java
> Description: This patch adds enhanced logging support for all sql
> statements including arguments ofbiz sends to the DBMS.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.