Reopening this issues for 2.0 branch.
Currently there is a regression for Oracle type support.
I perform tests on 2.0.4 and 2.0.3 versions... on both there was standard Java types for CLOB and Timestamp.
But in trunk (feature 2.0.5) it returns Oracle specific types.
It was changed in tasks:
CAY-672 Change the logic to get the Java class from ResultSetMetadata
CAY-1052 Invalid cast on NUMERICs with scale of 0 using Postgres JDBC 8.2+
So there is two ways:
Add TypeMappings for all Oracle types to 2.0 like it was done in this issue...
or add new type mapping logic like in