From derby-dev-return-92521-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Thu Dec 29 00:08:50 2011 Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BF2859C9D for ; Thu, 29 Dec 2011 00:08:50 +0000 (UTC) Received: (qmail 8826 invoked by uid 500); 29 Dec 2011 00:08:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 8796 invoked by uid 500); 29 Dec 2011 00:08:50 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 8789 invoked by uid 99); 29 Dec 2011 00:08:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Dec 2011 00:08:50 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [213.199.154.204] (HELO AM1EHSOBE001.bigfish.com) (213.199.154.204) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Dec 2011 00:08:42 +0000 Received: from mail111-am1-R.bigfish.com (10.3.201.245) by AM1EHSOBE001.bigfish.com (10.3.204.21) with Microsoft SMTP Server id 14.1.225.23; Thu, 29 Dec 2011 00:07:58 +0000 Received: from mail111-am1 (localhost [127.0.0.1]) by mail111-am1-R.bigfish.com (Postfix) with ESMTP id 00CE1C01C4 for ; Thu, 29 Dec 2011 00:08:15 +0000 (UTC) X-SpamScore: 0 X-BigFish: VPS0(zzc85fhzz1202hzz8275bh8275dhz2dh2a8h668h839h) X-Forefront-Antispam-Report: CIP:74.62.37.82;KIP:(null);UIP:(null);IPV:NLI;H:CPHUB1.canoga.com;RD:rrcs-74-62-37-82.west.biz.rr.com;EFVD:NLI X-FB-SS: 13, Received: from mail111-am1 (localhost.localdomain [127.0.0.1]) by mail111-am1 (MessageSwitch) id 1325117294446754_9709; Thu, 29 Dec 2011 00:08:14 +0000 (UTC) Received: from AM1EHSMHS012.bigfish.com (unknown [10.3.201.251]) by mail111-am1.bigfish.com (Postfix) with ESMTP id 696DF300042 for ; Thu, 29 Dec 2011 00:08:14 +0000 (UTC) Received: from CPHUB1.canoga.com (74.62.37.82) by AM1EHSMHS012.bigfish.com (10.3.207.112) with Microsoft SMTP Server (TLS) id 14.1.225.23; Thu, 29 Dec 2011 00:07:57 +0000 Received: from CPHUB2.canoga.com (172.16.1.94) by CPHUB1.canoga.com (172.16.1.93) with Microsoft SMTP Server (TLS) id 8.2.213.0; Wed, 28 Dec 2011 16:09:50 -0800 Received: from vserver1.canoga.com ([169.254.2.87]) by CPHUB2.canoga.com ([172.16.1.94]) with mapi; Wed, 28 Dec 2011 16:09:50 -0800 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Wed, 28 Dec 2011 16:08:14 -0800 Subject: Where can I find information on how to turn on tracing Thread-Topic: Where can I find information on how to turn on tracing Thread-Index: AczFvfVNxXf0cvgkSoGl9SYQjrqo8g== Message-ID: <97EB699F861AD841B5908C7CA9C9565601CC3A395B89@VSERVER1.canoga.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US X-TM-AS-Product-Ver: SMEX-8.0.0.1307-6.500.1024-18610.005 X-TM-AS-Result: No--16.472000-0.000000-31 X-TM-AS-User-Approved-Sender: Yes X-TM-AS-User-Blocked-Sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C9565601CC3A395B89VSERVER1can_" MIME-Version: 1.0 X-OriginatorOrg: canoga.com --_000_97EB699F861AD841B5908C7CA9C9565601CC3A395B89VSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am pursuing a bug where when the Network Client receives a Lock Timeout e= xception in PreparedStatement.java: public int executeUpdate() throws SQLException { try { synchronized (connection_) { if (agent_.loggingEnabled()) { agent_.logWriter_.traceEntry(this, "executeUpdate"); } int updateValue =3D executeUpdateX(); if (agent_.loggingEnabled()) { agent_.logWriter_.traceExit(this, "executeUpdate", upda= teValue); } return updateValue; } } catch ( SqlException se ) { checkStatementValidity(se); throw se.getSQLException(); } } I see "se" being the correct exception, but it then goes on to call: Sqlca.java: private String getMessage(int messageNumber) throws SqlException { // should this be traced to see if we are calling a stored proc? if (cachedMessages !=3D null && cachedMessages[messageNumber] !=3D = null) { return cachedMessages[messageNumber]; } if (connection_ =3D=3D null || connection_.isClosedX() || returnTok= ensOnlyInMessageText_) { return getUnformattedMessage(messageNumber); } CallableStatement cs =3D null; synchronized (connection_) { try { cs =3D connection_.prepareMessageProc("call SYSIBM.SQLCAMES= SAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); String errmc =3D null; String sqlState =3D null; if (sqlErrmcMessages_ !=3D null) { errmc =3D sqlErrmcMessages_[messageNumber]; sqlState =3D sqlStates_[messageNumber]; } This code fails with an error indicating that there is no current connectio= n. It is as if something has closed the connection in between. I want to = enable as much tracing as I can so that maybe I can find this thing. I am = not sure if it is a problem on the server end of the DRDA connection or the= client side. I see tracing in the code but I don't know how to turn this one. Just poin= t me where to read about it and I will do the rest. Thanks. Brett --_000_97EB699F861AD841B5908C7CA9C9565601CC3A395B89VSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am pursuing a = bug where when the Network Client receives a Lock Timeout exception in

 

P= reparedStatement.java:

 =

    public int executeUpdate() thro= ws SQLException {

   &nbs= p;    try

  &nb= sp;     {

 &nbs= p;          synchronized (conn= ection_) {

     = ;           if (agent_.lo= ggingEnabled()) {

   &nbs= p;            &= nbsp;   agent_.logWriter_.traceEntry(this, "executeUpdate&qu= ot;);

     &nbs= p;          }

         &n= bsp;      int updateValue =3D executeUpdateX();

       =          if (agent_.loggingEnabled(= )) {

      = ;            &n= bsp; agent_.logWriter_.traceExit(this, "executeUpdate", updateVal= ue);

      = ;          }

         &nb= sp;      return updateValue;

          &= nbsp; }

     &n= bsp;  }

    &nb= sp;   catch ( SqlException se ) {

            chec= kStatementValidity(se);

  &nbs= p;         throw se.getSQLException= ();

      =   }

    }=

 

I see &#= 8220;se” being the correct exception, but it then goes on to call:

 

= Sqlca.java:

 

    private String getMessage(int messageNumbe= r) throws SqlException {

  &nb= sp;     // should this be traced to see if we are calli= ng a stored proc?

   &nbs= p;    if (cachedMessages !=3D null && cachedMessages= [messageNumber] !=3D null) {

  = ;          return cachedMessag= es[messageNumber];

   &nb= sp;    }

 

        if (co= nnection_ =3D=3D null || connection_.isClosedX() || returnTokensOnlyInMessa= geText_) {

     = ;       return getUnformattedMessage(messageN= umber);

     &n= bsp;  }

 

        CallableStatement= cs =3D null;

    &n= bsp;   synchronized (connection_) {

            tr= y {

      =           cs =3D connection_.p= repareMessageProc("call SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,= ?,?,?)");

 

         &nbs= p;      String errmc =3D null;

          = ;      String sqlState =3D null;

 

  &nb= sp;            = if (sqlErrmcMessages_ !=3D null) {

&nbs= p;            &= nbsp;      errmc =3D sqlErrmcMessages_[messageNumb= er];

      = ;            &n= bsp; sqlState =3D sqlStates_[messageNumber];

           &nbs= p;    }

 =

This code fails with an error indicating that ther= e is no current connection.  It is as if something has closed the conn= ection in between.  I want to enable as much tracing as I can so that = maybe I can find this thing.  I am not sure if it is a problem on the = server end of the DRDA connection or the client side.

 

I see tracing in th= e code but I don’t know how to turn this one.  Just point me whe= re to read about it and I will do the rest.

 

Thanks.

 

Brett

= --_000_97EB699F861AD841B5908C7CA9C9565601CC3A395B89VSERVER1can_--