getDB Problem

graziano357

Hi,
I'm using this code to connect to database:

var db = _getDB("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/Milestone", "test", "test");
var $rs= []
_set($rs, db.select("SELECT count(*) FROM products"));

The result is
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
_setGlobal('\$rs', db.select("SELECT count(*) FROM products"));
--Stopped Playback: FAILURE--

In detail I have:

_setGlobal('\$rs', db.select("SELECT count(*) FROM products")); ReferenceError: db is not defined


I'm using windows 2000, with mozilla firefox. In library sahi\extlib\db i have mysql-connector-java.jar and set .bat:
SET EXT_CLASS_PATH=;
SET EXT_CLASS_PATH=%EXT_CLASS_PATH%;..\extlib\db\mysql-connector-java.jar
SET SAHI_CLASS_PATH=..\lib\sahi.jar;..\extlib\rhino\js.jar
SET MOZ_NO_REMOTE=1
java -classpath %EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy


Can you help me?

Thanks

Graziano