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.

Not connecting to MySQL Database

amol.likhiteamol.likhite Members
edited November 2009 in Sahi - Open Source
Hi,

var db = _getDB("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/sampleDB", "root", "");
var $rs = new Array();
$rs[0] = [];
_set($rs, db.select("select * from users"));
_alert($rs[0]["login"]);

after executing the above scripts, it gives me error as db is not defined. I am trying to connect MySql Database.

in Sahi Batch file..

set SAHI_CLASS_PATH=%SAHI_HOME%\lib\sahi.jar;%SAHI_HOME%\extlib\rhino\js.jar;%SAHI_HOME%\extlib\apc\commons-codec-1.3.jar

SET EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\mysql-connector-java.jar

SET MOZ_NO_REMOTE=1

Please help me.

Amol

Comments

  • narayannarayan Administrators
    Change
    _set($rs, db.select("select * from users"));

    to

    var $rs = db.select("select * from users");

    It is advisable to use $db instead of db.
  • amol.likhiteamol.likhite Members
    Thanks for the reply.
    After setting as per the comment, now it gives me syntax error.

    var $db = _getDB("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/kubbe", "root", " ");
    var $rs = $db.select("select * from users");
    _alert($rs[0]["login"]);

    Please help

    Amol
  • VenkyVenky Members
    Edit start_sahi.bat file located at <sahi home directory>\userdata\bin and replace the line

    SET SAHI_EXT_CLASS_PATH=
    as
    SET SAHI_EXT_CLASS_PATH=%SAHI_HOME%\extlib\db\mysql-connector-java-5.0.4-bin.jar

    Please make sure, the mysql jar file is located in the above mentioned path and try changing the url "jdbc:mysql://localhost/kubbe" as "jdbc:mysql://localhost:3306/kubbe" because the default port number of mysql is 3306.

    Go to userdata's bin directory and start sahi from start_sahi.
  • amol.likhiteamol.likhite Members
    Thanx.. It works

    Thank u once again

    Amol
  • pradeekpradeek Members
    If the problem still persist bypass all the steps by putting your mysql-connector jar to your java JRE /ext/lib folder it will work.Sahi will connect to your database.
  • anna1bhosaleanna1bhosale Members
    i m using ubunto 10.10 and postgresql 8.4 but when i m trying to connect to database it giving me an error
    ERROR
    exception: java.lang.ClassNotFoundException: org.postgresql.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at net.sf.sahi.util.ClassLoadHelper.getClass(ClassLoadHelper.java:24)
    at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:95)
    at net.sf.sahi.plugin.DBClient.select(DBClient.java:79)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
    at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3330)
    at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2487)
    at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
    at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:175)
    at org.mozilla.javascript.Context.evaluateString(Context.java:1104)
    at net.sf.sahi.rhino.RhinoScriptRunner.run(RhinoScriptRunner.java:114)
    at java.lang.Thread.run(Thread.java:619) at 12 Jun, 2013 4:28:13 PM

    My Script Is....

    _setValue(_textbox("customerId"), "1");
    _setValue(_textbox("username"), "a");
    _setValue(_password("password"), "a");
    _click(_submit("Login"));
    $db=_getDB("org.postgresql.Driver","jdbc:postgresql://192.168.1.21:5432/SIDDHERPU1db","maxigems","maxigems");
    $rs=$db.select("SELECT * from SALES_QUOTATION_INFO_TABLE");
    _prompt($rs);
  • monicasmonicas Members
    I have set classpath, copied jar file still I'm not able to connect to MySQL. Can anyone please help me.. Getting the following error:
    exception: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    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.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at net.sf.sahi.util.ClassLoadHelper.getClass(ClassLoadHelper.java:10)
    at net.sf.sahi.plugin.DBClient.getConnection(DBClient.java:204)
    at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:112)
    at net.sf.sahi.plugin.DBClient.select(DBClient.java:99)
    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:126)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
    at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1479)
    at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:815)
    at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:109)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3282)
    at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:120)
    at org.mozilla.javascript.Context.evaluateString(Context.java:1219)
    at net.sf.sahi.rhino.RhinoScriptRunner.executeJS(RhinoScriptRunner.java:254)
    at net.sf.sahi.rhino.RhinoScriptRunner.run(RhinoScriptRunner.java:234)
    at java.lang.Thread.run(Unknown Source)
    (RhinoScriptRunner.run#1277)
  • monicatmonicat Members
    May I please know why the user "monicas" is Banned?!! was any notification or warning sent to monicas regarding the ban?!!
Sign In or Register to comment.