Exception name |
Cause |
Solution |
java.sql.SQLException |
ORA-01017: invalid username/password; logon denied |
The user name or the password is incorrect. |
Check [User name] or [Password] of the global resource. |
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor |
The SID is invalid. |
Check [SID] or [URL] of the global resource. |
java.sql.SQLRecoverableException |
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor |
The service name is invalid. |
Check [SID] or [URL] of the global resource. |
The Network Adapter could not establish the connection |
Unable to connect to the database. |
Check [Host name] or [Port number] of the global resource. |
java.sql.SQLSyntaxErrorException |
ORA-00942: table or view does not exist |
The table or the view does not exist. |
Specify the table or the view that exists in [Table name]. |
ORA-00933: SQL command not properly ended |
The table or view name might not be enclosed with quotation marks. |
Check whether the table or view name specified in [Table name] is enclosed with quotation marks. |
oracle.jdbc.xa.OracleXAException |
Multiple XA global resources might be used, which refers to the same database, in a script of which transaction is enabled. |
When referring to the same database in multiple processes with Oracle XA connection, use the same global resource. |