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] of the global resource. |
ORA-17868: Unknown host specified. |
Unable to connect to the database. |
Check [Host name] of the global resource. |
ORA-12541: Cannot connect. |
Unable to connect to the database. |
Check [Host name] or [Port number] of the global resource. |
java.sql.SQLSyntaxErrorException |
ORA-00942: The table or the view "<table or view name>" does not exist. |
Either the table or the view does not exist or the table or view name might not be enclosed with quotation marks. |
Specify the table or the view that exists in [Table name].
Also 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. |