i follw this article ,change the driver to oracle jdbc, but fail libname libTera jdbc classpath="/data-drivers/jdbc" class="oracle.jdbc.driver.OracleDriver" URL="jdbc:oracle:oci:@192.168.1.172:1521:system" user="system" password="oracle" ; have following error messages 1 %studio_hide_wrapper; 77 78 libname libTera jdbc classpath="/data-drivers/jdbc" JDBC: attempting JDBC connection: jdbc:oracle:oci:@192.168.1.172:1521:system JDBC: CLASSPATH: /data-drivers/jdbc/ /data-drivers/jdbc/ojdbc8.jar /opt/sas/viya/home/SASFoundation/lib/access/hadoop/access-hadoop-hivehelper-2.1.5.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.twitter.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.youtubeanalytics.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.facebook.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.googledrive.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.onedrive.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.googleanalytics.jar /opt/sas/viya/home/lib64/accessclients/jdbc/cdata.jdbc.odata.jar 79 class="oracle.jdbc.driver.OracleDriver" 80 URL="jdbc:oracle:oci:@192.168.1.172:1521:system" 81 user="system" 82 password=XXXXXXXX 83 ; ERROR: java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource ERROR: at java.util.concurrent.FutureTask.report(FutureTask.java:122) ERROR: at java.util.concurrent.FutureTask.get(FutureTask.java:206) ERROR: at com.sas.access.hadoop.hive.JdbcHelper.getConnection(JdbcHelper.java:835) ERROR: Caused by: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource ERROR: at oracle.jdbc.driver.BlockSource.createBlockSource(BlockSource.java:102) ERROR: at oracle.jdbc.driver.BlockSource.createBlockSource(BlockSource.java:94) ERROR: at oracle.jdbc.driver.PhysicalConnection.setBlockSource(PhysicalConnection.java:881) ERROR: at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:951) ERROR: at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:928) ERROR: at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:250) ERROR: at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:94) ERROR: at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:732) ERROR: at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:648) ERROR: at com.sas.access.hadoop.hive.JdbcHelper$ConnectionTimeoutCheck.call(JdbcHelper.java:884) ERROR: at com.sas.access.hadoop.hive.JdbcHelper$ConnectionTimeoutCheck.call(JdbcHelper.java:866) ERROR: at java.util.concurrent.FutureTask.run(FutureTask.java:266) ERROR: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ERROR: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ERROR: at java.lang.Thread.run(Thread.java:748) ERROR: 嘗試建立連線時發生錯誤: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource ERROR: Error in the LIBNAME statement. 84 85 %studio_hide_wrapper; JDBC download from oracle ,ojdbc8.jar JDBC and UCP Downloads page (oracle.com) how fix the error ??
... View more