You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Kevin Sutter (JIRA)" <ji...@apache.org> on 2007/04/16 23:23:15 UTC
[jira] Reopened: (OPENJPA-184) use DB2 Diagnostic interface to
report extended error diagnostics on SQL Exception
[ https://issues.apache.org/jira/browse/OPENJPA-184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Sutter reopened OPENJPA-184:
----------------------------------
Assignee: David Wisneski
Sorry, I'm going to re-open this Issue. I don't see any mention of this added functionality in our OpenJPA documentation. Without documentation, the feature is not of much use. So, I think we should leave it open until it is properly documented.
> use DB2 Diagnostic interface to report extended error diagnostics on SQL Exception
> ----------------------------------------------------------------------------------
>
> Key: OPENJPA-184
> URL: https://issues.apache.org/jira/browse/OPENJPA-184
> Project: OpenJPA
> Issue Type: New Feature
> Environment: DB2 database
> Reporter: David Wisneski
> Assigned To: David Wisneski
>
> When using DB2 database and the SQLException occurs
> if the SQLException instance supports the DB2Diagnosable interface,
> extended error information from the SQLCA will be written to the SQL channel.
> The message format produced by DB2Diagnosable writer is
>
> SQLCA OUTPUT[Errp=SQLDMISR, Errd=[-2146893819, 5, 0, 0, -957, 0]]
> Errp is the name of the DB2 module that detected the error and Errd are 6 integers of diagnostic information, SQLWARN are 6 characters
> of warning flags.. Often this additional information can be used by an administrator in doing problem determination.
> This message will be appended to the persistence exception error message already created by OpenJPA
> and it will be written to SQL logging channel (if active).
> DB2Dictionary class is modified to use java reflection on the SQLException instance to determine
> if it supports DB2Diagnosble methods "getErrp" and if so
> it invokes the methods to retrieve Errp and Errd fields, formats and logs the error message.
> Reflection is used so that the DB2Dictionary does not contain any compile time or runtime
> dependency on the DB2 jdbc driver. If the DB2Diagnosable methods do not exist on the SQLException
> instance, no extended error information is logged.
> org.apache.openjpa.jdbc.sql.SQLException class is modified so in the event of an exception
> if the Dictionary is DB2, to call the Dictionary routines above.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: [jira] Reopened: (OPENJPA-184) use DB2 Diagnostic interface to report extended error diagnostics on SQL Exception
Posted by Kevin Sutter <kw...@gmail.com>.
Valid point. That's actually one of the reasons I decided to re-open these
two JIRA Issues. Supposedly, these two Issues were resolved from a coding
viewpoint, but there was no documentation updates to support the new
functionality. So, the code actually made it into the 0.9.7 release, but
there was no supporting documentation. Without documentation, does the
function even exist? :-) This lack of documentation makes documenting an
OpenJPA release more difficult since we're supposed to include "resolved"
issues in our release notes. If we did have this
"resolved-but-undocumented" choice, at least the owners of said Issues would
have one last chance to complete the documentation before the release was
cut for a [vote].
Kevin
On 4/16/07, Patrick Linskey <pl...@bea.com> wrote:
>
> Sounds fair.
>
> Ideally, we should figure out some way to mark things as
> resolved-but-undocumented in JIRA. This would be particularly useful to
> facilitate the process of building release notes that discuss issues
> that are maybe underdocumented.
>
> -Patrick
>
> > -----Original Message-----
> > From: Kevin Sutter (JIRA) [mailto:jira@apache.org]
> > Sent: Monday, April 16, 2007 2:23 PM
> > To: open-jpa-dev@incubator.apache.org
> > Subject: [jira] Reopened: (OPENJPA-184) use DB2 Diagnostic
> > interface to report extended error diagnostics on SQL Exception
> >
> >
> > [
> > https://issues.apache.org/jira/browse/OPENJPA-184?page=com.atl
> assian.jira.plugin.system.issuetabpanels:all-tabpanel ]
> >
> > Kevin Sutter reopened OPENJPA-184:
> > ----------------------------------
> >
> > Assignee: David Wisneski
> >
> > Sorry, I'm going to re-open this Issue. I don't see any
> > mention of this added functionality in our OpenJPA
> > documentation. Without documentation, the feature is not of
> > much use. So, I think we should leave it open until it is
> > properly documented.
> >
> > > use DB2 Diagnostic interface to report extended error
> > diagnostics on
> > > SQL Exception
> > >
> > ----------------------------------------------------------------------
> > > ------------
> > >
> > > Key: OPENJPA-184
> > > URL:
> > https://issues.apache.org/jira/browse/OPENJPA-184
> > > Project: OpenJPA
> > > Issue Type: New Feature
> > > Environment: DB2 database
> > > Reporter: David Wisneski
> > > Assigned To: David Wisneski
> > >
> > > When using DB2 database and the SQLException occurs if the
> > > SQLException instance supports the DB2Diagnosable
> > interface, extended
> > > error information from the SQLCA will be written to the SQL channel.
> > > The message format produced by DB2Diagnosable writer is
> > >
> > > SQLCA OUTPUT[Errp=SQLDMISR, Errd=[-2146893819, 5, 0,
> > 0, -957, 0]]
> > > Errp is the name of the DB2 module that detected the error and Errd
> > > are 6 integers of diagnostic information, SQLWARN are 6
> > characters of warning flags.. Often this additional
> > information can be used by an administrator in doing problem
> > determination.
> > > This message will be appended to the persistence exception error
> > > message already created by OpenJPA and it will be written
> > to SQL logging channel (if active).
> > > DB2Dictionary class is modified to use java reflection on the
> > > SQLException instance to determine if it supports DB2Diagnosble
> > > methods "getErrp" and if so it invokes the methods to
> > retrieve Errp and Errd fields, formats and logs the error message.
> > > Reflection is used so that the DB2Dictionary does not contain any
> > > compile time or runtime dependency on the DB2 jdbc driver. If the
> > > DB2Diagnosable methods do not exist on the SQLException
> > instance, no extended error information is logged.
> > > org.apache.openjpa.jdbc.sql.SQLException class is modified
> > so in the
> > > event of an exception if the Dictionary is DB2, to call the
> > Dictionary routines above.
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > You can reply to this email to add a comment to the issue online.
> >
> >
>
> Notice: This email message, together with any attachments, may contain
> information of BEA Systems, Inc., its subsidiaries and affiliated
> entities, that may be confidential, proprietary, copyrighted and/or
> legally privileged, and is intended solely for the use of the individual or
> entity named in this message. If you are not the intended recipient, and
> have received this message in error, please immediately return this by email
> and then delete it.
>
RE: [jira] Reopened: (OPENJPA-184) use DB2 Diagnostic interface to report extended error diagnostics on SQL Exception
Posted by Patrick Linskey <pl...@bea.com>.
Sounds fair.
Ideally, we should figure out some way to mark things as
resolved-but-undocumented in JIRA. This would be particularly useful to
facilitate the process of building release notes that discuss issues
that are maybe underdocumented.
-Patrick
> -----Original Message-----
> From: Kevin Sutter (JIRA) [mailto:jira@apache.org]
> Sent: Monday, April 16, 2007 2:23 PM
> To: open-jpa-dev@incubator.apache.org
> Subject: [jira] Reopened: (OPENJPA-184) use DB2 Diagnostic
> interface to report extended error diagnostics on SQL Exception
>
>
> [
> https://issues.apache.org/jira/browse/OPENJPA-184?page=com.atl
assian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>
> Kevin Sutter reopened OPENJPA-184:
> ----------------------------------
>
> Assignee: David Wisneski
>
> Sorry, I'm going to re-open this Issue. I don't see any
> mention of this added functionality in our OpenJPA
> documentation. Without documentation, the feature is not of
> much use. So, I think we should leave it open until it is
> properly documented.
>
> > use DB2 Diagnostic interface to report extended error
> diagnostics on
> > SQL Exception
> >
> ----------------------------------------------------------------------
> > ------------
> >
> > Key: OPENJPA-184
> > URL:
> https://issues.apache.org/jira/browse/OPENJPA-184
> > Project: OpenJPA
> > Issue Type: New Feature
> > Environment: DB2 database
> > Reporter: David Wisneski
> > Assigned To: David Wisneski
> >
> > When using DB2 database and the SQLException occurs if the
> > SQLException instance supports the DB2Diagnosable
> interface, extended
> > error information from the SQLCA will be written to the SQL channel.
> > The message format produced by DB2Diagnosable writer is
> >
> > SQLCA OUTPUT[Errp=SQLDMISR, Errd=[-2146893819, 5, 0,
> 0, -957, 0]]
> > Errp is the name of the DB2 module that detected the error and Errd
> > are 6 integers of diagnostic information, SQLWARN are 6
> characters of warning flags.. Often this additional
> information can be used by an administrator in doing problem
> determination.
> > This message will be appended to the persistence exception error
> > message already created by OpenJPA and it will be written
> to SQL logging channel (if active).
> > DB2Dictionary class is modified to use java reflection on the
> > SQLException instance to determine if it supports DB2Diagnosble
> > methods "getErrp" and if so it invokes the methods to
> retrieve Errp and Errd fields, formats and logs the error message.
> > Reflection is used so that the DB2Dictionary does not contain any
> > compile time or runtime dependency on the DB2 jdbc driver. If the
> > DB2Diagnosable methods do not exist on the SQLException
> instance, no extended error information is logged.
> > org.apache.openjpa.jdbc.sql.SQLException class is modified
> so in the
> > event of an exception if the Dictionary is DB2, to call the
> Dictionary routines above.
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its subsidiaries and affiliated entities, that may be confidential, proprietary, copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it.