Oracle Native Encryption with Oracle Thin JDBC driver
Looking for some guidance on steps that need to be taken to implement Oracle Native Encryption with the Oracle Thin JDBC driver. Any help would be appreciated.
Forum Discussion
@bojanvelevski - Yes, integers. The database version is old, it can’t generate itself so it must be passed to it via snap logic by any method.
Well, it’s a bit tricky, but manageable. You can take the highest id (I’m presuming it’s an id field) with a select call to the database, and use that value to calculate the following ids, by including the snap.in.totalCount method.
To calculate the ID, use the following expression in a mapper:
$value_from_db + snap.in.totalCount
The Oracle instance is set up correctly and we’re able to connect securely using the Oracle native client (from another third party tool), but need information on how to configure the Oracle account for a secure connection.
