Java Development Tools

Hi,

I am running update/insert query on my EO. When running through application module directly data is properly inserting into database but when I run the same from VO using JSFF it fails. It gives me few exception like below. All I can figure out is some value is not getting proper while inserting through VO. How do we debug query. *Is there any way to print SQL statement before this.getDBTransaction().commit();, that will give me what query is getting fired and what values are sending into query*


oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Update": SQL Statement "BEGIN UPDATE DATA_INPUT DataInputEO SET START_DATE=:1 WHERE ID=:2 RETURNING IS_ACTIVE INTO :3; END;".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:587)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8337)
at org.cap.oppe.subscriber.model.entity.dataInput.DataInputEOImpl.doDML(DataInputEOImpl.java:325)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6619)
at org.cap.oppe.subscriber.model.entity.dataInput.DataInputEOImpl.postChanges(DataInputEOImpl.java:338)

Caused by: java.sql.SQLException: Invalid column type
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:150)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:399)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:581)