Not able to insert data into oracle database using teiid api, throws exception : TEIID30160 The request 1C7sZp/i3dJ6.4 has been cancelled

[kulbhushanc]

Hi,

I am using teiid admin api to perform sql operations.

I am able to insert data into MYSQL ,SQL SERVER but unable to insert data into ORACLE database in following scenario.

Scenario :

STEP 1: Insert 10 rows in table, it will be inserted in database as expected.

STEP 2: Delete 1 or more row from the table.

STEP 3: Try to insert same row which we have deleted in STEP 2, it will throw an exception

• org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request 1C7sZp/i3dJ6.4 has been cancelled

and fail to insert row into the table.

But same row will be inserted successfully to the table if I DROP the TABLE from database and re-create it.

Thanks,

Kulbhushan Chaskar.

[rareddy]

There is not much information here to go on. All the exception is saying someone cancelled the query before it is done. BTW, why would you use the Admin API to execute the SQL ? You need to you JDBC API into Teiid.

[kulbhushanc]

Yes, I am using JDBC API into Teiid.

[rareddy]

Run in DEBUG mode and need to figure out WHY the cancel is being issued, hopefully you will find long entry for that. Teiid will not issue a cancel on its own unless the connection/statement is being closed.