i am using Terdata version 13.10 and R Studio 3.2.3 (32-bit). I am trying to establish connection between both using following code. I also have all required JDBC drivers installed on system.
That exception is due to tdgssconfig.jar not being accessible on the classpath, as discussed in the Troubleshooting section of the Teradata JDBC Driver User Guide.
In your code snippet, you listed tdgssconfig.jar in the second argument of the JDBC function. That's good.
But is the tdgssconfig.jar file actually located in the directory that you specified? And are the operating system permissions set on the tdgssconfig.jar file so that the R program can access the file?
tdgssconfig.jar is located in the directory that i have specified in the code. Also, i checked that all permissions are granted on tdgssconfig.jar file so that R can access it. but i still get following error while running follwoing code:
drv = JDBC("com.teradata.jdbc.TeraDriver","C:\Users\ Public\Desktop\TeraJDBC__indep_indep.15.00.00.33\ terajdbc4.jar;C:\Users\Public\Desktop\ TeraJDBC__indep_indep.15.00.00.33\tdgssconfig.jar"
conn = dbConnect(drv,"jdbc:teradata://tddev","userid"," password")
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url), :
java.lang.NoClassDefFoundError: Could not initialize class com.teradata.tdgss.jtdgss.TdgssManager
Also, i forgot to mention earlier that when 1st time i tried establishing connection, i was able to. But next time after closing down R session, when i re-opened and re-ran above mentioned code i started getting error.
There are some extra space characters in your jar file paths:
There is a white space character before 'Tera'
Please see if this caused the problem.