...
Scenario in Oracle Snaps | Error from the Old Oracle Driver | Error after the Oracle Driver and JOOQ upgrade |
Oracle - Insert: For the insert operation, when you enter a string value instead of an integer in a numeric column. | Error Message: SQL operation failed. Reason: Resolution: Please check for valid Snap properties and input data. | Error Message: Reason: Resolution: |
Oracle - Execute, Oracle - Insert, and Oracle - Merge: When the execute, insert, and merge operations are successful. | Status: " Message: | Status: Message: |
Oracle - Delete, Oracle - Execute, and Oracle - Update: When the delete, update, and execute operations are successful. | Status: "-2" Message: | Status: Message: |
Oracle - Insert: When the insert operation fails.
| Case 1: When you insert string in place of number data type.
| Case 1: When you insert string in place of number data type.
|
Case 2:Insert batch records into not null column type- one record specified with null value to fail and route to error view. | Case 2:The errors are the same in both drivers, but the reason is repeated twice inolder drivers. | |
Oracle - Execute and Oracle - Insert:Batch operation when Auto commit checkbox is Selected.
| Error: In the old version,when an error record occurs during a batch operation, the entire batch fails, and records are redirected to the error view. As a result, no records are inserted into the database. | Error: In the new version, if there is an error record in the batch operation, the records before the problematic one are inserted into the database, while the records after it are routed to the error view. Records are inserted into the table because the Auto-commit checkbox is selected. |
Auto Commit checkbox isDeselected | Error: In the old version,when an error record occurs during a batch operation, the entire batch fails and records are redirected to the error view. As a result, no records are inserted into the database. | Error: In the new version, if there is an error record in the batch operation, the records before the problematic one are inserted into the database, while the records after it are routed to the error view. Records are not inserted into the table because the Auto-commit checkbox is deselected |
Displays data type as | New driver displays data type as | |
Oracle - Execute: Insert operation | When you pass a spl character( ' ):
|
|
Delete_Condition contains special characters:
|
|
...
The Oracle JDBC Driver is upgraded from OJDBC6 JAR (11.2.0.4 version) to the OJDBC10 JAR (19.20.0.0 version). The OJDBC10 JAR is bundled with the Oracle Snap Pack as the default driver.
...