_getDB

DonnaMoores

I have written a java program to use the sqljdbc driver to connect to a database. When I connect to the database using my java program my url looks like

jdbc:sqlserver://macaaa081;databaseName=AnimalTracking;portNumber=1433;instanceName=./SQLEXPRESS;

Now I know the correct parameters I am attempting to connect to a database using a Sahi script.

My script is as follows:

var $driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  var $url = "jdbc:sqlserver://";
  var $serverName = "macaaa081";
  var $databaseName = "AnimalTracking";
  var $portNumber = "1433";
  var $instanceName = "./SQLEXPRESS";
  var $userName = "Webserver";
  var $password = "Password99";
  var $jdbcurl = $url + $serverName + ";databaseName=" + $databaseName + ";portNumber=" + $portNumber + ";instanceName=" + $instanceName + ";";

    var db = _getDB($driver, $jdbcurl, $userName, $password);
    var $rs=[];
    _set($rs, db.select("SELECT * FROM operator.property_unused_tags"));
    _alert($rs);

The alert popups up containing the test "undefined" but also the command prompt from where I have started Sahi shows the following:

C:\Program Files\sahi\bin>java -jar ../lib/sahi.jar
>>>> Sahi started. Listening on port:9999
>>>> Configure your browser to use this server and port as its proxy
>>>> Browse any page and CTRL-ALT-DblClick on the page to bring up the Sahi Cont
roller
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://macaaa081;databaseName=AnimalTracking;portNumber=1433
;instanceName=./SQLEXPRESS;
Username: Webserver
Password: Password99
SQL: SELECT * FROM operator.property_unused_tags
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:26)
        at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:62)
        at net.sf.sahi.plugin.DBClient.select(DBClient.java:52)
        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 net.sf.sahi.command.CommandExecuter.execute(CommandExecuter.java:53)
        at net.sf.sahi.LocalRequestProcessor.getLocalResponse(LocalRequestProces
sor.java:42)
        at net.sf.sahi.ProxyProcessor.processLocally(ProxyProcessor.java:142)
        at net.sf.sahi.ProxyProcessor.run(ProxyProcessor.java:67)
        at java.lang.Thread.run(Unknown Source)

Also to start Sahi I use the following:

C:\PROGRA~1\sahi\bin>SET CLASSPATH=C:\Progra~1\sahi\lib\sqljdbc_1.2\enu\sqljdbc.jar
C:\Program Files\sahi\bin>SET MOZ_NO_REMOTE=1
C:\Program Files\sahi\bin>java -jar ../lib/sahi.jar

I have also tried

C:\PROGRA~1\sahi\bin>SET CLASSPATH=C:\Progra~1\sahi\lib\sqljdbc_1.2\enu\sqljdbc.jar
C:\PROGRA~1\sahi\bin>SET MOZ_NO_REMOTE=1
C:\PROGRA~1\sahi\bin>java -classpath net.sf.sahi.Proxy -jar ../lib/sahi.jar

Please can you tell me what I am doing wrong.

Many thanks
Donna Moores

narayan

Use

java -classpath C:\Progra~1\sahi\lib\sqljdbc_1.2\enu\sqljdbc.jar;../lib/sahi.jar net.sf.sahi.Proxy

Convert backslashes to forward slashes if that does not work.

-jar option ignores classpath related options in java.

DonnaMoores

Thanks for your help. That prblem has now been solved

Donna