IBATIS typeHandler easy SQLException summary

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

1. Column type java.sql.SQLException: is invalid.

Reason:

A. ibatis IN, OUT attribute parameters, or parameters to the typeHandler in the value data types and Oracle custom object data types do not match,

The B. call SQL statement string? Number variable number and the actual PKG sub process is inconsistent,

2. Internal java.sql.SQLException: error: Inconsistent catalog view

Reason:

The typeHandler class "createDescriptor" called Oracle custom objects, or call the wrong Oracle custom objects without authorization on the execution of the SQL user,

3. The IN or OUT parameter is missing the java.sql.SQLException: index: 1

Reason:

Ibatis IN, OUT parameters, or the parameters of typeHandler class in get's name wrong,

4. java.sql.SQLException: ORA-00907: missing right parenthesis

Reason:

SQL statements end symbols cause not right parenthesis matching,

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Troy at December 02, 2013 - 8:19 PM