18 January 2026:


This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.



Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.

Syntax Error while trying to retrive from SQL2005

abhi_8abhi_8 Members
edited November -1 in Sahi - Open Source
Hi, I am getting syntax error while retriving data form SQL server 2005.
Follwoing is my script:

var $db = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://test:1433;databasename=test;","sa","sa");
//_alert($db);

var $rs1;
_setValue($rs1, $db.select("select * from employee");

Following is the details of Sahi batch file:
SET EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\sqljdbc.jar
set SAHI_CLASS_PATH=%SAHI_HOME%\lib\sahi.jar;%SAHI_HOME%\extlib\rhino\js.jar;%SAHI_HOME%\extlib\apc\commons-codec-1.3.jar

java -classpath %SAHI_EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy "%SAHI_HOME%" "%SAHI_USERDATA_DIR_TMP%"
Tagged:

Comments

  • narayannarayan Administrators
    Use:
    var $rs1 = $db.select("select * from employee");

    Btw, where did you pick this code:
    var $rs1;
    _setValue($rs1, $db.select("select * from employee");


    Is it somewhere in Sahi's documentation? If yes, please let me know where. It is no longer correct and needs to be rectified.

    This is the correct documentation: http://sahi.co.in/w/_getdb

    Thanks,
    Narayan
  • abhi_8abhi_8 Members
    I have already tried the code given by you i.e. var $rs1 = $db.select("select * from employee"); but it was giving same syntax error. So I serachd the forum and chkecked various possibilities. I got this code in one of the unanswered post.

    I am still getting the same syntax error.
    Please help.
  • narayannarayan Administrators
    Are there any errors on the sahi command prompt? Any ClassNotFoundException's? Is your driver correctly added to the classpath?
  • abhi_8abhi_8 Members
    I am getting 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

    also java.io.FileNotFoundException: ..\certs\sahi_example_com and java.io.FileNotFoundException: ..\certs\sahi_example_com

    details of classpath:
    SET EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\sqljdbc.jar
    set SAHI_CLASS_PATH=%SAHI_HOME%\lib\sahi.jar;%SAHI_HOME%\extlib\rhino\js.jar;%SAHI_HOME%\extlib\apc\commons-codec-1.3.jar

    java -classpath %SAHI_EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy "%SAHI_HOME%" "%SAHI_USERDATA_DIR_TMP%"
  • narayannarayan Administrators
    Please change EXT_CLASS_PATH to SAHI_EXT_CLASS_PATH.

    SET EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\sqljdbc.jar

    should be

    SET SAHI_EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\sqljdbc.jar
  • abhi_8abhi_8 Members
    Its working fine..

    Thanks
This discussion has been closed.