Product: TIBCO Spotfire®
Error - Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect options.
While using TIBCO Data direct driver either creating a bootstrap file or while creating a new Data source, you may get the following error if EncryptioLevel is set on the database.
[tibcosoftwareinc][Oracle JDBC Driver]The connect attempt failed because the server requires Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect options.
Update the JDBC URL as follows.
jdbc:tibcosoftwareinc:oracle://Servername:portnumber;ServiceName=Servicename;DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256
You may also have to install the Java policy JAR (JCE) files from the following link if you see the error below.
http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html
==================================================================Unable to open a connection to database 'Servername:portnumber;ServiceName=Servicename;DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256' using account 'username'.; caused by: tibcosoftwareinc.jdbc.oraclebase.ddej: [tibcosoftwareinc][Oracle JDBC Driver]Failure due to insufficient maximum key length according to the installed JCE jurisdiction policy files. Please install "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy File.
=================================================================