1. Explore
  2. »
  3. Oracle JDBC Driver

Oracle JDBC Driver errors

The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases—SQL databases and other tabular data sources, such as spreadsheets or flat files

http://www.oracle.com/technetwork/database/application-development/jdbc/overview/index.html
Solution coverage:
Summary coverage:

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. DatabaseError.throwSqlException() has thrown a SQLException
    No solution
  3. T4CTTIoer.processError() has thrown a SQLException
    No solution
Error patternsPackagesClassesMethodsExceptions
DescriptionException TypeEntry MethodWeb pages

Generic SQL Exception

java.sql.SQLException
oracle.jdbc.driver.DatabaseError.throwSqlException
2209Web pages
1Solution
SQLExceptionDatabaseError.throwSqlException()2209

DatabaseError.throwSqlException() has thrown a SQLException

java.sql.SQLException
1 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
1084Web pages
SQLExceptionDatabaseError.throwSqlException()1084

T4CTTIoer.processError() has thrown a SQLException

java.sql.SQLException
1 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
1053Web pages
SQLExceptionT4CTTIoer.processError()1053

T4CTTIoer.processError() has thrown a SQLException

java.sql.SQLException
2 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
1041Web pages
SQLExceptionT4CTTIoer.processError()1041

T4C8Oall.receive() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.T4C8Oall.receive
927Web pages
SQLExceptionT4C8Oall.receive()927

DatabaseError.throwSqlException() has thrown a SQLException

java.sql.SQLException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
773Web pages
SQLExceptionDatabaseError.throwSqlException()773

T4CPreparedStatement.doOall8() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.T4CPreparedStatement.doOall8
614Web pages
SQLExceptionT4CPreparedStatement.doOall8()614

Incorrect Syntax in SQL statement

java.sql.SQLSyntaxErrorException
oracle.jdbc.driver.T4CTTIoer.processError
525Web pages
1Solution
SQLSyntaxErrorExceptionT4CTTIoer.processError()525

T4CTTIoer.processError() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
1 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
509Web pages
SQLSyntaxErrorExceptionT4CTTIoer.processError()509

T4C8Oall.processError() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
2 frames hidden
oracle.jdbc.driver.T4C8Oall.processError
478Web pages
SQLSyntaxErrorExceptionT4C8Oall.processError()478

T4CTTIfun.receive() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
3 frames hidden
oracle.jdbc.driver.T4CTTIfun.receive
471Web pages
SQLSyntaxErrorExceptionT4CTTIfun.receive()471

T4CTTIfun.doRPC() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
4 frames hidden
oracle.jdbc.driver.T4CTTIfun.doRPC
463Web pages
SQLSyntaxErrorExceptionT4CTTIfun.doRPC()463

T4C8Oall.doOALL() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
5 frames hidden
oracle.jdbc.driver.T4C8Oall.doOALL
455Web pages
SQLSyntaxErrorExceptionT4C8Oall.doOALL()455

Generic SQL Exception

java.sql.SQLException
oracle.jdbc.driver.T4CTTIoer.processError
447Web pages
1Solution
SQLExceptionT4CTTIoer.processError()447

Generic SQL Exception

java.sql.SQLException
oracle.jdbc.driver.SQLStateMapping.newSQLException
439Web pages
1Solution
SQLExceptionSQLStateMapping.newSQLException()439

T4CTTIoer.processError() has thrown a SQLException

java.sql.SQLException
1 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
433Web pages
SQLExceptionT4CTTIoer.processError()433

DatabaseError.newSQLException() has thrown a SQLException

java.sql.SQLException
1 frames hidden
oracle.jdbc.driver.DatabaseError.newSQLException
423Web pages
SQLExceptionDatabaseError.newSQLException()423

DatabaseError.throwSqlException() has thrown a SQLException

java.sql.SQLException
2 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
409Web pages
SQLExceptionDatabaseError.throwSqlException()409

OracleStatement.executeNonQuery() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.OracleStatement.executeNonQuery
355Web pages
SQLExceptionOracleStatement.executeNonQuery()355

OracleStatement.doExecuteOther() has thrown a SQLException

java.sql.SQLException
6 frames hidden
oracle.jdbc.driver.OracleStatement.doExecuteOther
353Web pages
SQLExceptionOracleStatement.doExecuteOther()353

T4CPreparedStatement.doOall8() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
6 frames hidden
oracle.jdbc.driver.T4CPreparedStatement.doOall8
301Web pages
SQLSyntaxErrorExceptionT4CPreparedStatement.doOall8()301

OracleStatement.doExecuteWithTimeout() has thrown a SQLException

java.sql.SQLException
7 frames hidden
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
300Web pages
SQLExceptionOracleStatement.doExecuteWithTimeout()300

T4CConnection.logon() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.T4CConnection.logon
290Web pages
SQLExceptionT4CConnection.logon()290

T4C8Oall.processError() has thrown a SQLException

java.sql.SQLException
2 frames hidden
oracle.jdbc.driver.T4C8Oall.processError
287Web pages
SQLExceptionT4C8Oall.processError()287

T4CTTIfun.receive() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.T4CTTIfun.receive
284Web pages
SQLExceptionT4CTTIfun.receive()284

T4CTTIfun.doRPC() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.T4CTTIfun.doRPC
281Web pages
SQLExceptionT4CTTIfun.doRPC()281

T4C8Oall.doOALL() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.T4C8Oall.doOALL
280Web pages
SQLExceptionT4C8Oall.doOALL()280

PhysicalConnection.<init>() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.PhysicalConnection.<init>
274Web pages
SQLExceptionPhysicalConnection.<init>()274

T4CConnection.<init>() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.T4CConnection.<init>
271Web pages
SQLExceptionT4CConnection.<init>()271

T4CDriverExtension.getConnection() has thrown a SQLException

java.sql.SQLException
6 frames hidden
oracle.jdbc.driver.T4CDriverExtension.getConnection
267Web pages
SQLExceptionT4CDriverExtension.getConnection()267

OracleConnection.<init>() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.OracleConnection.<init>
266Web pages
SQLExceptionOracleConnection.<init>()266

OracleDriver.connect() has thrown a SQLException

java.sql.SQLException
7 frames hidden
oracle.jdbc.driver.OracleDriver.connect
265Web pages
SQLExceptionOracleDriver.connect()265

OracleDriver.getConnectionInstance() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.OracleDriver.getConnectionInstance
252Web pages
SQLExceptionOracleDriver.getConnectionInstance()252

OracleDriver.connect() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.OracleDriver.connect
247Web pages
SQLExceptionOracleDriver.connect()247

OraclePreparedStatement.executeUpdate() has thrown a SQLException

java.sql.SQLException
8 frames hidden
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
233Web pages
SQLExceptionOraclePreparedStatement.executeUpdate()233

DatabaseError.throwSqlException() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
221Web pages
SQLExceptionDatabaseError.throwSqlException()221

T4CPreparedStatement.execute_for_rows() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows
190Web pages
SQLExceptionT4CPreparedStatement.execute_for_rows()190

DatabaseError.throwSqlException() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.DatabaseError.throwSqlException
186Web pages
SQLExceptionDatabaseError.throwSqlException()186

OracleStatement.doExecuteWithTimeout() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
9 frames hidden
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
182Web pages
SQLSyntaxErrorExceptionOracleStatement.doExecuteWithTimeout()182

The Oracle XA library is not configured properly to use

oracle.jdbc.xa.OracleXAException
oracle.jdbc.xa.OracleXAResource.checkError
177Web pages
1Solution
OracleXAExceptionOracleXAResource.checkError()177

T4CTTIoer.processError() has thrown a SQLException

java.sql.SQLException
3 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
174Web pages
SQLExceptionT4CTTIoer.processError()174

OracleStatement.doExecuteWithTimeout() has thrown a SQLException

java.sql.SQLException
6 frames hidden
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
173Web pages
SQLExceptionOracleStatement.doExecuteWithTimeout()173

OraclePreparedStatement.executeInternal() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
10 frames hidden
oracle.jdbc.driver.OraclePreparedStatement.executeInternal
172Web pages
SQLSyntaxErrorExceptionOraclePreparedStatement.executeInternal()172

T4CTTIoer.processError() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.T4CTTIoer.processError
172Web pages
SQLExceptionT4CTTIoer.processError()172

T4CStatement.doOall8() has thrown a SQLException

java.sql.SQLException
4 frames hidden
oracle.jdbc.driver.T4CStatement.doOall8
171Web pages
SQLExceptionT4CStatement.doOall8()171

OraclePreparedStatement.executeQuery() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
11 frames hidden
oracle.jdbc.driver.OraclePreparedStatement.executeQuery
167Web pages
SQLSyntaxErrorExceptionOraclePreparedStatement.executeQuery()167

OraclePreparedStatementWrapper.executeQuery() has thrown a SQLSyntaxErrorException

java.sql.SQLSyntaxErrorException
12 frames hidden
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery
165Web pages
SQLSyntaxErrorExceptionOraclePreparedStatementWrapper.executeQuery()165

OraclePreparedStatement.executeInternal() has thrown a SQLException

java.sql.SQLException
7 frames hidden
oracle.jdbc.driver.OraclePreparedStatement.executeInternal
159Web pages
SQLExceptionOraclePreparedStatement.executeInternal()159

OraclePreparedStatement.executeUpdate() has thrown a SQLException

java.sql.SQLException
8 frames hidden
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
152Web pages
SQLExceptionOraclePreparedStatement.executeUpdate()152

T4CPreparedStatement.executeForRows() has thrown a SQLException

java.sql.SQLException
5 frames hidden
oracle.jdbc.driver.T4CPreparedStatement.executeForRows
150Web pages
SQLExceptionT4CPreparedStatement.executeForRows()150
Nothing to list here.
Nothing to list here.
Nothing to list here.
Nothing to list here.