AnsweredAssumed Answered

[Q] Error sql.SetDataSourceTag

Question asked by Keri Taylor on Mar 11, 2011
Latest reply on Mar 31, 2014 by DaniPerez
I am getting an error while running GEL

ERROR 2011-03-11 15:05:08,226 [main] sql.SetDataSourceTag Could not load driver class: java.lang.ClassNotFoundException:
com.ca.clarity.jdbc.sqlserver.SQLServerDriver


Database Operations
GEL can connect to one or more databases, and it is not limited to CA Clarity PPM databases. Both Oracle and SQL Server are supported. See the following examples.

Most connection problems stem from either login errors or JDBC issues. The following example shows a JDBC error.

E:\Clarity\XOG\bin>gel -script gelsqlexample.xml
ERROR 2005-08-31 16:45:40,549 [main] sql.SetDataSourceTag Could not load driver class:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver…

If you see an error like this, find the necessary JDBC classes and copy them to the GEL classpath.

Note that the GEL engine does not search the environment path for these files. GEL only looks in the lib folder (and the CA Clarity PPM server classpath, if it has been installed on the local computer). For Oracle, ojdbc14.jar should be copied to the lib folder. For SQLServer, Microsoft’s JDBC drivers must be made available to the GEL engine. Copy the files msbase.jar, mssqlserver.jar, and msutil.jar to the lib directory (after you have installed the latest JDBC driver from Microsoft, or copy the files from CA Clarity PPM.

[Q] where are these files located? (Copy the files msbase.jar, mssqlserver.jar, and msutil.jar )

thanks

Keri

Outcomes