Pattern selector

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

  1. OraclePreparedStatement.executeQuery() has thrown a SQLException
    Oracle JDBC Driver
    18
    4
    5
  2. Generic SQL Exception
    Oracle JDBC Driver
    215
    30
    85

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLException: ORA-00904: "AD\_SHORTNAME": invalid identifier
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
7 frames hidden

Solution

Liam3 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. 652478via Oracle Community1 month ago
    ORA-01729: database link name expected
    Show stack trace
  2. 807589via Oracle Community1 month ago
    invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433
    Show stack trace
  3. zhou chuminvia Sakai JIRA1 month ago
    ORA-00902: tipo de dato no válido
    Show stack trace
  4. zhou chuminvia Sakai JIRA1 month ago
    ORA-00902: tipo de dato no válido
    Show stack trace
  5. adorearunvia GitHub2 months ago
    java.sql.SQLException: Closed Statement: next
    Show stack trace
  6. adorearunvia GitHub2 months ago
    Closed Connection
    Show stack trace
  7. glassfishrobotvia GitHub2 months ago
    Closed Connection
    Show stack trace
  8. selvanponrajvia GitHub2 months ago
    ORA-00900: invalid SQL statement
    Show stack trace
  9. 597673via Oracle Community2 months ago
    Fail to convert to internal representation
    Show stack trace