Comments

• narayan Administrators

  April 2009

  Have you looked at _getDB? Please let us know what you have tried and where you have got stuck so that we can provide specific answers.
• Samsirsameer Members

  April 2009

  var db = _getDB("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@192.168.161.5:1521:oracle", "chicago7", "chicago7");
  var $rs = db.select("select serial_number from device where ping_rate=1000); //it will return the device whose ping rate is 1000 milliseconds
  _assertEqual("abc", $rs[0]["PING_RATE"]); //verifying whether the retrieved device name is "abc" or not
  
  Please let me know the what is the driver that needs to be placed in Sahi and where exactly i need to place it.
  
  Thanks
  Samsirsameer.
• pankaj.nith Members

  April 2009

  Hi,
  
  search for classes12.jar in your oracle installation. It will be in ../jdbc/lib/ folder of your oracle client installation. You can either use the same path in your sahi.bat or you can copy this jar file in sahi/extlib/
  then edit your sahi.bat to add:
  -classpath ../extlib/classes12.jar;
  My sahi.bat looks like this:

  SET MOZ_NO_REMOTE=1
  java -classpath <my oracle path>/jdbc/lib/classes12.jar;../lib/sahi.jar net.sf.sahi.Proxy
  

  change<my oracle path> to whereever you put your file
  
  Regards,
  Pankaj
• Samsirsameer Members

  April 2009

  Hi,
  I ahve copied the classes.12.jar file in to C/sahi/extlib/ directoty and edited the classpath.
  
  My class path looks like
  SET EXT_CLASS_PATH=;
  REM eg. SET EXT_CLASS_PATH=%EXT_CLASS_PATH%;..\extlib\db\mysql-connector-java-5.0.4-bin.jar
  SET SAHI_CLASS_PATH=..\lib\sahi.jar;..\extlib\rhino\js.jar;..\extlib\apc\commons-codec-1.3.jar
  REM SET MOZ_NO_REMOTE=1
  java -classpath %EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy
  java -classpath c:\sahi\extlib\10.2.0.3\classes12.jar;../lib/sahi.jar net.sf.sahi.Proxy
  
  
  I used the following SCRipt,
  Script:
  function database() {
  try {
  var db = _getDB("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@192.168.161.5:1521:oracle", "chicago7", "chicago7");
  2 var $rs = db.select("select ping_rate,backup_enabled from device where serial_number='SP_531_Serial'"); //it will return the device whose ping rate is 1000 milliseconds
  3 _assertEqual("5000", $rs[0]["PING_RATE"]); //verifying whether the retrieved device name is "abc" or not
  4 _assertEqual("0", $rs[0]["backup_enabled"]); //verifying whether the retrieved device name is "abc" or not
  5
  6 _debugToFile("TCS:LOGIN006 PING RATE and BACKUP IS VERIFIED PASSED", "C:\sahi\SAHIPROJECT\Logs\Log.txt");
  }
  
  catch(e) {
  _debugToFile("TCS:LOGIN006 PING RATE and BACKUP IS Incorrect PASSED", "C:\sahi\SAHIPROJECT\Logs\Log.txt");
  }
  }
  
  Actual Result: JSERROR:SyntaxError: Syntax error
  
  Expected Result: The script should pass
  
  
  Please help me in this regards
  
  
  
  Thanks,
  Samsirsameer.
• Samsirsameer Members

  April 2009

  Hi All,
  
  Please reply....
• narayan Administrators

  April 2009

  Have a look at http://sahi.co.in/w/adding-jars-to-sahis-classpath.
• tharukesh Members

  February 2011 edited February 2011

  hi narayan,
  
  I sucessfully completed the configuration part and i run the script, but i will not ensure wheather it is intracted with Database, becasue i checked the condition with both positive and negative approach but i got the same result(pass) for both. please guid me how to ensure the database.
  
  I am using sql server 2005 in my company.