Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6972

Delay for getting derby connection (Connection Reset and Waiting for a connection)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: None
    • Component/s: Network Server
    • Labels:
      None
    • Urgency:
      Urgent

      Description

      Hi Team,
      This is regarding a derby connection issue in network mode.
      We are using Apache derby in network mode. Below are the version we are using for client server communication,
      Client Jar Version : derbyclient-10.13.1.1.jar
      Server Version : * Apache Derby Network Server - 10.11.1.1*
      We are facing three types of connection issue while getting database connection from our java application.
      1. A communications error has been detected: Connection reset
      2. Waiting for a connection with a long period of time.
      3. Error connecting to server 127.0.0.1 on port 1,527 with message connect timed out.

      At the same time if we are checking the derby.log in derby server, we found below exceptions,

      Fri Oct 20 17:19:30 EDT 2017 Thread[DRDAConnThread_107,5,main] (DATABASE = null), (DRDAID = null), Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 0; Error Code Value = 3. Plaintext connection attempt from an SSL enabled client?
      Fri Oct 20 17:19:30 EDT 2017 : Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 0; Error Code Value = 3. Plaintext connection attempt from an SSL enabled client?
      org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 0; Error Code Value = 3. Plaintext connection attempt from an SSL enabled client?
      at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
      at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.exchangeServerAttributes(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.sessionInitialState(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)

      We have no idea about the above Exceptions why it is coming while getting connection in java client application.

      Could you please help us to identify the exact reason for the above problem.

      Thanks & Regards,
      Sridhar Jena

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sjena Sridhar Jena
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: