Data not getting inserted into oracle with theAutoCommitEnabled not checked

[sabyasachi_mohapatra3]

Hello Experts

I have a proxy to JDBC scenario.I have 3 SQL statements and the Format is

<DeleteStatement>

<InsertStatement>

<CallStoredProcStatement>.

While excecuting with the AutoCommitEnabled box checked, the insert statement is excecuting and the data is getting updated in the oracle database..But the CallStoredProcStatement is not excecuting.

If the AutoCommitEnabled box not checked,the data is not getting updated in the database .but in RWB log all the SQL statements are getting executed successfully.

Are there any other configurations still to be made in the JDBC adapter.

[sabyasachi_mohapatra3]

ok

[Former Member]

Hi,

Why you not using single SP to handle all the queries?

BTW, have you used the parameter "logSQLStatement = true" in JDBC receiver channel? It will show in audit log what query is being executed.

Regards,

Neetesh