java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message (additional information may be available in the derby.log file on the server)

Apache's JIRA Issue Tracker | Dag H. Wanvik | 6 years ago
  1. 0

    Cf the attached repro: when performing the rollback after the database has been shutdown, we see this error: There was 1 error: 1) testShutdown(org.apache.derbyTesting.functionTests.tests.store.Foo)java.sql.SQLNonTransientConnectionException: Network protocol exception: actual code point, 4,692, does not match expected code point, 9,224. The connection has been terminated. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71) at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358) at org.apache.derby.client.am.Connection.rollback(Connection.java:659) at org.apache.derbyTesting.junit.BaseJDBCTestCase.rollback(BaseJDBCTestCase.java:387) at org.apache.derbyTesting.functionTests.tests.store.Foo.testShutdown(Foo.java:100) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: org.apache.derby.client.am.DisconnectException: Network protocol exception: actual code point, 4,692, does not match expected code point, 9,224. The connection has been terminated. at org.apache.derby.client.net.Reply.parseLengthAndMatchCodePoint(Reply.java:1075) at org.apache.derby.client.net.NetConnectionReply.parseSQLCARD(NetConnectionReply.java:2572) at org.apache.derby.client.net.NetConnectionReply.parseRDBRLLBCKreply(NetConnectionReply.java:219) at org.apache.derby.client.net.NetConnectionReply.readLocalRollback(NetConnectionReply.java:141) at org.apache.derby.client.net.ConnectionReply.readLocalRollback(ConnectionReply.java:48) at org.apache.derby.client.net.NetConnection.readLocalRollback_(NetConnection.java:1515) at org.apache.derby.client.am.Connection.readRollback(Connection.java:707) at org.apache.derby.client.am.Connection.flowRollback(Connection.java:690) at org.apache.derby.client.am.Connection.rollback(Connection.java:655) ... 29 more

    Apache's JIRA Issue Tracker | 6 years ago | Dag H. Wanvik
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message (additional information may be available in the derby.log file on the server)
  2. 0

    Answer a Question | WebRatio

    webratio.com | 4 months ago
    java.sql.SQLNonTransientConnectionException: Insufficient data while reading from the network - expected a minimum of 6 bytes and received only 0 bytes.  The connection has been terminated.
  3. 0

    Catch DatabaseException

    Oracle Community | 1 decade ago | 843830
    org.apache.derby.client.am.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: insufficient data. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS Error Code: -4499 Call:SELECT ID, NAME, VALUE FROM SETTING WHERE (NAME = CAST (? AS VARCHAR(32672) )) bind => [admin.password] Query:ReportQuery(test.persistence.Setting)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Apache Derby Users - issues when connecting to a database

    nabble.com | 12 months ago
    java.sql.SQLNonTransientConnectionException: The connection was refused because the database HMDATABASE was not found.
  6. 0

    apache.db.derby.user - Security restriction on a remote connection of Derby 10.1.1 - msg#00238 - Recent Discussion OSDir.com

    osdir.com | 1 year ago
    org.apache.derby.client.am.DisconnectException: java.security.PrivilegedActionException : Error opening socket to server localhost on port 1527 with message : null

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.derby.client.am.DisconnectException

      A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message (additional information may be available in the derby.log file on the server)

      at org.apache.derby.client.net.NetConnectionReply.parseCMDCHKRM()
    2. Apache Derby Client JDBC Driver
      Statement.executeQuery
      1. org.apache.derby.client.net.NetConnectionReply.parseCMDCHKRM(NetConnectionReply.java:882)
      2. org.apache.derby.client.net.NetStatementReply.parsePrepareError(NetStatementReply.java:550)
      3. org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(NetStatementReply.java:144)
      4. org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(NetStatementReply.java:53)
      5. org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(StatementReply.java:40)
      6. org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(NetStatement.java:138)
      7. org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Statement.java:1443)
      8. org.apache.derby.client.am.Statement.flowExecute(Statement.java:2117)
      9. org.apache.derby.client.am.Statement.executeQueryX(Statement.java:492)
      10. org.apache.derby.client.am.Statement.executeQuery(Statement.java:477)
      11. org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
      12. org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358)
      13. org.apache.derby.client.am.Statement.executeQuery(Statement.java:486)
      13 frames
    3. org.apache.derbyTesting
      Foo.testShutdown
      1. org.apache.derbyTesting.functionTests.tests.store.Foo.testShutdown(Foo.java:102)
      1 frame
    4. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    5. org.apache.derbyTesting
      BaseTestCase.runBare
      1. org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
      1 frame
    6. JUnit
      TestSetup.run
      1. junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
      2. junit.extensions.TestSetup$1.protect(TestSetup.java:21)
      3. junit.extensions.TestSetup.run(TestSetup.java:25)
      3 frames
    7. org.apache.derbyTesting
      BaseTestSetup.run
      1. org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      1 frame
    8. JUnit
      TestSetup.run
      1. junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
      2. junit.extensions.TestSetup$1.protect(TestSetup.java:21)
      3. junit.extensions.TestSetup.run(TestSetup.java:25)
      3 frames