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.


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


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


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

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


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