»»»»

oracle.jdbc.driver.DatabaseError.throwSqlException errorsOracle JDBC Driver

Top patterns

  1. Generic SQL Exception

    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.
  2. Provide Username and Password via GetConnection method

    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.

  3. DatabaseError.throwSqlException() has thrown a DebugUtility
    No solution
Error patternsExceptions
DescriptionException TypeEntry MethodWeb pages

Generic SQL Exception

java.sql.SQLException
oracle.jdbc.driver.DatabaseError.throwSqlException
2190Web pages
1Solution
SQLExceptionDatabaseError.throwSqlException2190

Provide Username and Password via GetConnection method

java.sql.SQLRecoverableException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
44Web pages
1Solution
SQLRecoverableExceptionDatabaseError.throwSqlException44

DatabaseError.throwSqlException() has thrown a DebugUtility

oracle.wh.util.DebugUtility
oracle.jdbc.driver.DatabaseError.throwSqlException
11Web pages
DebugUtilityDatabaseError.throwSqlException11

DatabaseError.throwSqlException() has thrown an UncategorizedSQLException

org.springframework.jdbc.UncategorizedSQLException
oracle.jdbc.driver.DatabaseError.throwSqlException
9Web pages
UncategorizedSQLExceptionDatabaseError.throwSqlException9

DatabaseError.throwSqlException() has thrown a WsException

com.ibm.ws.exception.WsException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
3Web pages
WsExceptionDatabaseError.throwSqlException3

DatabaseError.throwSqlException() has thrown an EJBException

javax.ejb.EJBException
oracle.jdbc.driver.DatabaseError.throwSqlException
3Web pages
EJBExceptionDatabaseError.throwSqlException3

DatabaseError.throwSqlException() has thrown a SQLWorkReposException

com.sunopsis.dwg.SQLWorkReposException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
3Web pages
SQLWorkReposExceptionDatabaseError.throwSqlException3

DatabaseError.throwSqlException() has thrown a DatabaseException

java.sql.SQLException
oracle.jdbc.driver.DatabaseError.throwSqlException
2Web pages
DatabaseExceptionDatabaseError.throwSqlException2

DatabaseError.throwSqlException() has thrown a CannotCreateTransactionException

org.springframework.transaction.CannotCreateTransactionException
oracle.jdbc.driver.DatabaseError.throwSqlException
2Web pages
CannotCreateTransactionExceptionDatabaseError.throwSqlException2

DatabaseError.throwSqlException() has thrown a Throwable

java.lang.Throwable
1 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
2Web pages
ThrowableDatabaseError.throwSqlException2

DatabaseError.throwSqlException() has thrown a ServletException

javax.servlet.ServletException
oracle.jdbc.driver.DatabaseError.throwSqlException
2Web pages
ServletExceptionDatabaseError.throwSqlException2

DatabaseError.throwSqlException() has thrown a SQLMasterReposException

com.sunopsis.dwg.SQLMasterReposException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
2Web pages
SQLMasterReposExceptionDatabaseError.throwSqlException2

DatabaseError.throwSqlException() has thrown an UnexpectedDBException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
1Web pages
UnexpectedDBExceptionDatabaseError.throwSqlException1
Nothing to list here.