java.sql.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)

Oracle Community | imatua | 8 years ago
  1. 0

    Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKS

    Oracle Community | 8 years ago | imatua
    java.sql.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)
  2. 0

    Empty lines in javax.persistence.sql-load-script-source lead to exceptions

    Eclipse Bugzilla | 4 years ago | sherry.hill
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x9,236. Plaintext connection attempt to an SSL enabled server? Error Code: 40000 Call: Query: DataModifyQuery(sql="")
  3. 0

    [GLASSFISH-19847] JPA2.1: A PROTOCOL Data Stream Syntax Error - Java.net JIRA

    java.net | 1 year ago
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x9,236. Plaintext connection attempt to an SSL enabled server? Error Code: 40000 Call: Query: DataModifyQuery(sql="")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [GLASSFISH-19847] JPA2.1: A PROTOCOL Data Stream Syntax Error - Java.net JIRA

    java.net | 1 year ago
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x9,236. Plaintext connection attempt to an SSL enabled server? Error Code: 40000 Call: Query: DataModifyQuery(sql="")
  6. 0

    Bug 403936 – Empty lines in javax.persistence.sql-load-script-source lead to exceptions

    eclipse.org | 1 year ago
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x9,236. Plaintext connection attempt to an SSL enabled server? Error Code: 40000 Call: Query: DataModifyQuery(sql="")

    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. java.sql.SQLNonTransientConnectionException

      A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)

      at oracle.toplink.essentials.threetier.ServerSession.executeCall()
    2. oracle.toplink.essentials
      ServerSession.executeCall
      1. oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)
      1 frame