AnsweredAssumed Answered

Datasource SQLServer

Question asked by Giuseppe_T. on Nov 19, 2010
Latest reply on Nov 20, 2010 by Patrick Cooper
Hi,
I have a problem connecting to an external sqlserver database.

When I launch a process with this Datasource in the gel script


<sql:setDataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433"







user="username"






password="password"








var="clarityDS"/>


I get the following error:



BPM-0704: An error occurred while executing custom script: org.apache.commons.jelly.JellyTagException: null:16:25: <sql:setDataSource> In &lt;driver&gt;, invalid driver class name: "com.microsoft.sqlserver.jdbc.SQLServerDriver" at org.apache.commons.jelly.tags.sql.SetDataSourceTag.doTag(SetDataSourceTag.java:116) 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.GELScript.run(GELScript.java:80) at com.niku.union.gel.GELController.invoke(GELController.java:20) at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:180) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727) at java.lang.Thread.run(Thread.java:595)


Thanks
Giuseppe

Outcomes