Executing Stored Procedures

DonnaMoores

I have the following code:

function getDB()
{
//These parameters enable us to connect to the database directly to ensure that data has been updated as expected
    $MachineName       = "macaaa124"
    $WebServerUsername = "WebServer";
    $WebServerPassword = "password99";
    $JTDSDriver        = "net.sourceforge.jtds.jdbc.Driver";
    $JTDSURL           = "jdbc:jtds:sqlserver://" + $MachineName + ";databaseName=AnimalTracking;portNumber=1433";
    $MicrosoftDriver   = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    $MicrosoftUrl      = "jdbc:sqlserver://" + $MachineName + ";databaseName=AnimalTracking;portNumber=1433";

    return _getDB($MicrosoftDriver, $MicrosoftUrl, $WebServerUsername, $WebServerPassword);
}

function executeStoredProcedure(sql)
{
    var db = getDB();
    db.execute(sql);
}

function setTagOrderToReceived($batch)
{
    var $returnedData;
    var $sql = "EXEC OPERATOR.TAG_ORDER_RECEIVED " + $batch;
    executeStoredProcedure($sql);
}

setTagOrderToReceived("1");

This worked with version 1 of Sahi, but I cant seem to get it working with version 2 of Sahi.

Any suggestions

Thank you very much

Donna

narayan

Donna,
The code seems to be fine. Does it work with a simple select or update query?
-Narayan

DonnaMoores

The error I am now getting is as follows:

[java] JDBC URL: jdbc:sqlserver://macaaa124;databaseName=AnimalTracking;portNumber=1433
[java] Username: WebServer
[java] Password: password99
[java] SQL: EXEC OPERATOR.TAG_ORDER_SHIPPED 2
[java] com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) [java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)

It works but I would prefer not to be getting any error at all as it would be confusing

Any suggestions

Donna