Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. DatabaseError.throwSqlException() has thrown a SQLException
    Oracle JDBC Driver
    135
    12
    30
  2. Generic SQL Exception
    Oracle JDBC Driver
    215
    29
    85

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was:121.100.100.1:1521:mydb
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:292)

Solution

Liam2 months ago

This java.sql.SQLException is generated from the "DatabaseError.throwSqlException" method. This SQL Exception could happen for many various reasons. For the particular reason that this Database Error is generated, will be indicated by the text following the "java.sql.SQLException:". Therefore this SQLException covers many different causes of the database problems.

Here are a few examples of this exception, the different cause of the problems, and the possible solutions:

Exception message: The Network Adapter could not establish the connection

  • verify the URL is correct, for example: "jdbc:oracle:thin:@hostname:port:sid"
  • check the hostname is correct, IP address is correct (if IP address is used)
  • check port is correct.
  • the SID is correct.
  • database is running on the hostname server, and verify port is listening
  • check the server firewall setting to allow the database port traffic

Exception message: setString can only process strings of less than 32766 characters

  • limitation on the characters length of the strings, thus the length must be reduced.

Exception message: cannot insert NULL into ("FWDS_AT02"."BATCH_JOB_EXECUTION"."START_TIME")

  • check if this BATCH_JOB_EXECUTION.START_TIME column is nullable on your database and set it to nullable if not.

External results for this pattern (10)

  1. zhou chuminvia Sakai JIRA1 week ago
    ORA-00902: tipo de dato no válido
    Show stack trace
  2. zhou chuminvia Sakai JIRA1 week ago
    ORA-00902: tipo de dato no válido
    Show stack trace
  3. adorearunvia GitHub4 weeks ago
    java.sql.SQLException: Closed Statement: next
    Show stack trace
  4. adorearunvia GitHub4 weeks ago
    Closed Connection
    Show stack trace
  5. glassfishrobotvia GitHub1 month ago
    Closed Connection
    Show stack trace
  6. selvanponrajvia GitHub1 month ago
    ORA-00900: invalid SQL statement
    Show stack trace
  7. 597673via Oracle Community1 month ago
    Fail to convert to internal representation
    Show stack trace
  8. Dilbagh-Oraclevia Oracle Community1 month ago
    ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [] ORA-06512: at "APPS.WF_FWKMON", line 121
    Show stack trace
  9. vincentcpevia Oracle Community1 month ago
    Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: //localhost:1521/ORCL Error Code: 0
    Show stack trace
  10. 648181via Oracle Community2 months ago
    metric value for end-to-end tracing is too long: 172.26.146.129:66572:1215076887113:4
    Show stack trace