java.sql.SQLException: com.teradata.jdbc.TeraDriver not found
book
Article ID: 88310
calendar_today
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
When testing a Teradata connection, the below error is seen.
ErrorMsg: AwE-5001 Database Query Error Details: null java.sql.SQLException: com.teradata.jdbc.TeraDriver not found at com.appworx.server.sql.AxConnectionPool.<init>(AxConnectionPool.java:119) at com.appworx.server.sql.DBAccess.createConnectionPool(DBAccess.java:1474) at com.appworx.server.data.MasterDB.checkLoginConnection(MasterDB.java:6945) at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.uc4.be.util.InvokeUtil.invoke(InvokeUtil.java:107) at com.appworx.util.InvokeRequest.invokeMethod(InvokeRequest.java:47) at com.appworx.server.data.C.A(ClientServices.java:150) at com.appworx.server.data.C.A(ClientServices.java:132) at com.appworx.server.data.D$_A.doRun(RemoteClientSocketManager.java:170) at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:367) at java.lang.Thread.run(Unknown Source)
Environment
Applications Manager version 9.x
Resolution
This error indicates missing teradata jdbc drivers (.jar file).
Once you have downloaded and extracted the jar file(s), please place the jar file(s) in the $AW_HOME/web/classes or %AW_HOME%\web\classes directory and bounce the master.
Please refer to Teradata for more information about downloading the latest jdbc drivers.