Not connecting to MySQL Database

amol.likhite

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

narayan

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.likhite

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

Venky

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.likhite

Thanx.. It works

Thank u once again

Amol

pradeek

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.

anna1bhosale

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);

monicas

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)