Provide Username and Password via GetConnection method

java.sql.SQLRecoverableException
Javadoc
The subclass of {@link SQLException} thrown in situations where a previously failed operation might be able to succeed if the application performs some recovery steps and retries the entire transaction or in the case of a distributed transaction, the transaction branch. At a minimum, the recovery operation must include closing the current connection and getting a new connection.

@since 1.6

at oracle.jdbc.driver.SQLStateMapping.newSQLException
at oracle.jdbc.driver.DatabaseError.newSQLException
at oracle.jdbc.driver.DatabaseError.throwSqlException

Typical Exception Messages

  1. Io exception: The Network Adapter could not establish the connection
  2. No more data to read from socket
  3. Io exception: NL Exception was generated
  4. Io exception: Connection reset
  5. Io exception: Connection timed out
  6. Io exception: Socket closed
  7. PreparedStatementCallback; SQL [SELECT TID_PK, FK_USER, FK_ISSUE_TYPE, FK_GROUP, FK_ISSUE_STATUS, issueType.name ISSUE_TYPE, NoteMaster.Notes, grp.name GRP, issueStatus.name as ISSUE_STATUS, ECLIPSE_ID || CASE WHEN COALESCE(IS_GROUP, 'N') = 'N' THEN ' - ' || FIRST_NAME || ' ' || LAST_NAME ELSE '' END ASSIGNED_TO, USER_MASTER.ACTIVE USER_STATUS, TRUNC(SYSDATE)-TRUNC(COALESCE(issue.ASSIGNED_DATE, SYSDATE)) issue_age, to_char(ASSIGNED_DATE, 'dd-Mon-yyyy HH:MI AM') ASSIGNED_DATE FROM TICKET_ISSUE_DETAILS issue INNER JOIN ISSUE_TYPE_MASTER issueType ON FK_ISSUE_TYPE=ITM_PK INNER JOIN GROUP_MASTER grp on FK_GROUP=GM_PK INNER JOIN ISSUE_STATUS_MASTER issueStatus on FK_ISSUE_STATUS=issueStatus.ISM_PK LEFT JOIN USER_MASTER ON FK_USER=UM_PK LEFT JOIN ( SELECT FK_ISSUE, concatenate_list(CURSOR(select (COALESCE(ECLIPSE_ID, cast(CREATED_BY as varchar2(15))) || ' - ' || to_char(IND.CREATED_TIMESTAMP, 'dd-Mon-yyyy HH:MI AM') || chr(10)|| NOTES||chr(10)) AS Notes FROM ISSUE_NOTES_DETAILS IND LEFT JOIN USER_MASTER ON CREATED_BY=SSO_ID WHERE IND.FK_ISSUE=IND1.FK_ISSUE ORDER BY IND_PK DESC )) notes FROM ISSUE_NOTES_DETAILS ind1 WHERE FK_ISSUE IN (SELECT TID_PK FROM TICKET_ISSUE_DETAILS WHERE FK_TICKET = ?) GROUP BY ind1.FK_ISSUE ) NoteMaster ON TID_PK=FK_ISSUE WHERE FK_TICKET=? AND IS_DELETED='N' ORDER BY TID_PK ]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
  8. No m ore data to read from socket
  9. [B3026]: Failed to get connection to jdbc:oracle:thin:@<host:port:SID hidden for security>
  10. There were errors initializing your configuration: <openjpa-1.1.0-r422266:657916 fatal store error> org.apache.openjpa.util.StoreException: Исключение ввода/вывода: The Network Adapter could not establish the connection

Specific cases

Solution

Liam, 2 months ago

Exception message: Io exception: NL Exception was generated

The username and password cannot be supplied via the connection string URL, the correct way is as shown below:

String connectionString = "jdbc:oracle:thin:@(DESCRIPTION=(CID=ValidCID)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ValidHost)(PORT=1521)))(CONNECT_DATA=(SID =ValidSID)(SERVER = DEDICATED)))";
Connection con = DriverManager.GetConnection(connectionString, UserID, Password);

The above shown, the method "GetConnection" is used and the userID and password are input arguments to the method.

External results for this pattern (44)

  1. Unknown authorvia weblogic-tips.com4 months ago
    Io exception: NL Exception was generated
    Show stack trace
  2. Unknown authorvia blogspot.com4 months ago
  3. Unknown authorvia middlewaremagic.com4 months ago
    Io exception: NL Exception was generated
    Show stack trace
  4. Unknown authorvia blogspot.com4 months ago
    Io exception: NL Exception was generated
    Show stack trace
  5. Unknown authorvia middlewaremagic.com4 months ago
    Io exception: NL Exception was generated
    Show stack trace
  6. Unknown authorvia wordpress.com4 months ago
  7. Unknown authorvia middlewaremagic.com4 months ago
    Io exception: NL Exception was generated
    Show stack trace
  8. PreparedStatementCallback; SQL []; Io exception: Connection reset; nested exception is java.sql.SQLRecoverableException: Io exception: Connection reset
    Show stack trace
  9. Unknown authorvia adobe.com4 months ago
    Io exception: Software caused connection abort: recv failed
    Show stack trace
  10. Unknown authorvia middlewaremagic.com4 months ago
    Io exception: The Network Adapter could not establish the connection
    Show stack trace