Comments

• amol.likhite Members

  December 2009

  Hi,
  
  Please see below code.
  function ExecuteProcedure(sql)
  {
  var $db = _getDB ("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/kubbe", "root", "silicus");
  $db.execute(sql);
  }
  
  function selectUserData()
  {
  var $returnedData;
  var $sql = "EXEC kubbe.selectuser ";
  ExecuteProcedure($sql);
  }
  
  selectUserData();
  
  But it is not working.
  
  Amol
• narayan Administrators

  December 2009

  Amol,
  
  Sahi does not currently have in built support to execute stored procedures.
  
  You can do this to execute your sp.
  

  var $driverName = "com.mysql.jdbc.Driver";
  var $jdbcurl = "jdbc:mysql://localhost:3306/kubbe";
  var $username = "root";
  var $password = "silicus";
  
  var $connection = null;
  try {
      java.lang.Class.forName($driverName);
      $connection = java.sql.DriverManager.getConnection($jdbcurl, $username, $password);
      var $callableStatement = $connection.prepareCall("{call kubbe.selectuser}");
      $callableStatement.execute();
  } catch ($e) {
      $e.printStackTrace();
  } finally {
      if ($connection != null){
          try{
              $connection.close();
          }catch($e2){
              $e2.printStackTrace();
          }
      }
  }
  
• amol.likhite Members

  December 2009

  Hi Narayan,
  
  Solutions works fine.
  Thanks for the help.
  
  Amol