I have written code like this to connect DB:

//Function for retrieve data from DB
function getDataFromDB(){
$Query = "select * from loan";
var $db1 = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://blrsw011:1433;databaseName=prod", "UserName", "Root123");
$res = $db1.select($Query);
var $length1 = $res.length;
return $length1;
}

$len1 = getDataFromDB();
_alert($len1);

after executing this, i am getting the following error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.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 sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at net.sf.sahi.util.ClassLoadHelper.getClass(ClassLoadHelper.java:23)
at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:99)
at net.sf.sahi.plugin.DBClient.select(DBClient.java:83)
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 org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:24
7)
at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)

at org.mozilla.javascript.gen.c3._c30(<cmd>:189)
at org.mozilla.javascript.gen.c3.call(<cmd>)
at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)

at org.mozilla.javascript.gen.c4._c2(<cmd>:25)
at org.mozilla.javascript.gen.c4.call(<cmd>)
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java
:108)
at org.mozilla.javascript.gen.c4._c0(<cmd>:30)
at org.mozilla.javascript.gen.c4.call(<cmd>)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:3
98)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:306
5)
at org.mozilla.javascript.gen.c4.call(<cmd>)
at org.mozilla.javascript.gen.c4.exec(<cmd>)
at org.mozilla.javascript.Context.evaluateString(Context.java:1104)
at net.sf.sahi.rhino.ScriptRunner.run(ScriptRunner.java:105)
at java.lang.Thread.run(Unknown Source)

Could you please help on this?

Thanks & Regards
Tulasi