shalinee

Running Gel Script from cmd -Throwing an error of driver not found

Discussion created by shalinee on Jan 10, 2012
Latest reply on Mar 28, 2012 by shalinee
Hi,


I am trying to run the Gel Script from command prompt by using the below command and it is throwing an error SQL Server driver not found.

cmd /c gel -script C:\NON_ISD_USER_LOAD_DEV\step1_sr_load.xml.

Please refer the below error.

:\Program Files\CA\Clarity\CA Clarity XOG\bin>cmd /c gel -script C:\NON_ISD_USE
R_LOAD_DEV\step1_sr_load.xml.
ERROR 2012-01-09 16:21:07,193 [main] sql.SetDataSourceTag Could not load driver
class: java.lang.ClassNotFoundException: com.ca.clarity.jdbc.sqlserver.SQLServer
Driver
java.lang.ClassNotFoundException: com.ca.clarity.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.apache.commons.jelly.tags.sql.DataSourceWrapper.setDriverClassNam
e(DataSourceWrapper.java:55)
at org.apache.commons.jelly.tags.sql.SetDataSourceTag.doTag(SetDataSourc
eTag.java:111)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:247)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:95)
at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:186)
at com.niku.union.gel.tags.ScriptTag.doTag(ScriptTag.java:20)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:247)
at com.niku.union.gel.GELClient.execute(GELClient.java:236)
at com.niku.union.gel.GELClient.invoke(GELClient.java:88)
at com.niku.union.gel.GELClient.main(GELClient.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
Internal error: file:/C:/NON_ISD_USER_LOAD_DEV/step1_sr_load.xml.:12:231: <sql:s
etDataSource> In &lt;driver&gt;, invalid driver class name: "com.ca.clarity.jdbc
.sqlserver.SQLServerDriver"


I have verified the lib folder of C/Program files/CA/Clarity/Clarity XOG/Lib, it is having all the four files of

sqljdbc.jar
sqljdbc_auth.dll
sqljdbc_xa.dll
sqljdbc4.jar

of jdbc driver as well as classes12.jar is also available in in my Java home lib folder as well as Xog lib folder. Please let me know if anybody knows the cause of error.

We are on CA Clarity R12 SP4 with SQL Server 2005

Any suggestion is much appreciated



Regards,
Shalinee Chauhan

Outcomes