...
Oracle Snaps | Scenario | Error from the Old (OJDBC6 JAR—11.2.0.4 version) JDBC Driver | Error from the new (OJDBC10 JAR —19.20.0.0 version) JDBC Driver |
When you enter a string value instead of an integer in a numeric column for the insert operation. | Error Message: Reason: Resolution: | Error Message: Reason: Resolution: | |
When the execute, insert, and merge operations are successful. | Status: " Message: | Status: Message: | |
When the delete, execute, insert, and update operations are successful. | Status: " Message: | Status: Message: | |
| When we insert null values into the not null column type. |
Reason: The reason is repeated twice with the ‘ | Reason: |
| Batch operation when the Auto commit checkbox is Selected. | Error: In the old version,the entire batch fails when an error occurs during a batch operation, and records are redirected to the error view. As a result, no records are inserted into the database. | Error: In the new version, when there is an error 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. |
Batch operation when the Auto Commit checkbox isDeselected. | Error: In the old version,when an error 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 occurs 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. | |
Oracle to SQL Server: If When you select the Create a table if not present checkbox.The Snap is unable to create a table with correct data typesa second output view for metadata. | Displays data type as | Displays data type as | |
Insert operation when you pass a spl character( ' ): | Reason: Resolution: | Error code: Reason: Resolution: | |
Delete condition contains special characters. | Reason: | Error code: Reason: |
...