Android Question jRDC 2.1 Error : dbrequestmanager_ser_bytestoobject

SELECT 0 AS 'StatusID', 'Login Successful' AS 'Msg' ,
                   @CompanyID AS 'Comp_ID', @BranchID AS 'Branch_ID',
                     @UserTypeID AS 'UserType_ID', @UserID AS 'User_ID',
                     @FinYear AS 'FinYear', @UserFullName AS 'User_FullName' ,
                     @BranchShortName AS 'Branch_ShortName' ,
                     @GcmID AS 'GCM_ID';

SELECT 0 AS 'StatusID', 'Login Successful' AS 'Msg' ,
                   1 AS 'Comp_ID', 1 AS 'Branch_ID',
                     1 AS 'UserType_ID', 24 AS 'User_ID',
                     2015 AS 'FinYear', 'Anser' AS 'User_FullName' ,
                     'MyBranch_01' AS 'Branch_ShortName' ,
                     'TestID' AS 'GCM_ID';

SELECT Fin_Year INTO @FinYear FROM cmn_finyear WHERE Date(Now()) BETWEEN Start_date AND End_Date;

    Dim cmd As DBCommand
cmd.Initialize
cmd.Name="login_sp"
cmd.Parameters=Array As Object(cUserName,cPassword,Starter.cDeviceId,nAppVersion)

'To verify the parameters 
Msgbox(cUserName &CRLF&   cPassword &CRLF& Starter.cDeviceId &CRLF& nAppVersion, "Test")
  
reqManager.ExecuteQuery(cmd, 0, "login")

sql.login_sp=call test_Login(?,?,?,?)

  SET @sql= 'SELECT 0 AS "StatusID", "Login Successful" AS "Msg" ,
                   @CompanyID AS "Comp_ID", @BranchID AS "Branch_ID",
                     @UserTypeID AS "UserType_ID", @UserID AS "User_ID",
                     @FinYear AS "FinYear", @UserFullName AS "User_FullName" ,
                     @BranchShortName AS "Branch_ShortName" ,
                     @GcmID AS "GCM_ID"';
                  
    PREPARE stmt FROM @sql ;
    EXECUTE stmt ;
    DEALLOCATE PREPARE stmt;

SELECT 0 , 'Login Successful'  ,
                   @CompanyID , @BranchID ,
                     @UserTypeID , @UserID ,
                     @FinYear , @UserFullName ,
                     @BranchShortName  ,
                     @GcmID ;

BEGIN

   IF cParameter = "A" THEN  /*  This will work  */
     SELECT ID AS 'IdNo', Brand_Name AS 'BrandName' FROM vehicle_brands WHERE ID = 12 ;
   ELSEIF cParameter = "B" THEN  /*  This will FAIL  */
     SELECT ID, Brand_Name INTO @nIdNo, @cBrandName FROM vehicle_brands WHERE ID = 12 ;
     SELECT @nIdNo AS 'IdNo', @cBrandName AS 'BrandName' ;
   ELSEIF cParameter = "C" THEN  /*  This will work  */
     SELECT 12 AS 'IdNo', 'Test Vehicle' AS 'BrandName' ;
   END IF;

END

CALL SP_MOB_Test('A')
CALL SP_MOB_Test('B')
CALL SP_MOB_Test('C')

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DATABASE CONFIGURATION
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://192.168.0.170/MyDbName?characterEncoding=utf8
User=MyUserName
Password=MyPassword
#Java server port
ServerPort=17179

#example of MS SQL Server configuration:
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<server address>/<database>

#SQL COMMANDS

sql.test=CALL SP_MOB_Test(?)

#Region  Activity Attributes
    #FullScreen: False
    #IncludeTitle: True
#End Region

Sub Process_Globals
    'These global variables will be declared once when the application starts.
    'These variables can be accessed from all modules.

End Sub

Sub Globals
    'These global variables will be redeclared each time the activity is created.
    'These variables can only be accessed from this module.

    Private BtnTestA, BtnTestB, BtnTestC As Button
    Private reqManager As DBRequestManager
    Type DBResult (Tag As Object, Columns As Map, Rows As List)
    Type DBCommand (Name As String, Parameters() As Object)
End Sub

Sub Activity_Create(FirstTime As Boolean)
    'Do not forget to load the layout file created with the visual designer. For example:
    Activity.LoadLayout("Test")

    If FirstTime Then
        reqManager.Initialize(Me, Starter.RdcServerIP)
    Else
        If reqManager.IsInitialized = False Then
            reqManager.Initialize(Me, Starter.RdcServerIP)
        End If
    End If

End Sub

Sub Activity_Resume

End Sub

Sub Activity_Pause (UserClosed As Boolean)

End Sub

Sub BtnTestA_Click
    Test("A")
End Sub

Sub BtnTestB_Click
    Test("B")
End Sub

Sub BtnTestC_Click
    Test("C")
End Sub

Sub Test(cParameter As String)

    Dim cTag As String
    cTag = "Test"&cParameter  'For Eg TestA, TestB TestC

    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name="test"
    cmd.Parameters=Array As Object(cParameter)
    ProgressDialogShow("Retrieving data")
    reqManager.ExecuteQuery(cmd, 0, cTag)

End Sub

Sub JobDone(Job As HttpJob)
    ProgressDialogHide
  If Job.Success = False Then
     Log("Error: " & Job.ErrorMessage)

  Else
    If Job.JobName = "DBRequest" Then
       reqManager.HandleJobAsync(Job, "ReqManager")
    End If
  End If
  Job.Release
End Sub

Sub ReqManager_Result(result As DBResult)
    reqManager.PrintTable(result)
    If result.Tag = "TestA" Then 'This will work fine
        ToastMessageShow("Test A Passed",False)

    Else If result.Tag = "TestB" Then 'This will error out
        ToastMessageShow("Test B Passed",False)

    Else If result.Tag = "TestC"    Then 'This will work fine
        ToastMessageShow("Test C Passed",False)

    End If
End Sub

BEGIN

   IF cParameter = "A" THEN  /*  This will work  */
     SELECT ID AS 'IdNo', Brand_Name AS 'BrandName' FROM vehicle_brands WHERE ID = 12 ;
   ELSEIF cParameter = "B" THEN  /*  This will FAIL  */
     SELECT ID, Brand_Name INTO @nIdNo, @cBrandName FROM vehicle_brands WHERE ID = 12 ;
     SELECT @nIdNo AS 'IdNo', @cBrandName AS 'BrandName' ;
   ELSEIF cParameter = "C" THEN  /*  This will work  */
     SELECT 12 AS 'IdNo', 'Test Vehicle' AS 'BrandName' ;
   END IF;

END

BEGIN

    DECLARE nIdNo INT DEFAULT 0;
    DECLARE cBrandName VARCHAR(50) DEFAULT '' ;
 
    IF cParameter = "A" THEN
        SELECT ID AS 'IdNo', Brand_Name AS 'BrandName' FROM vehicle_brands WHERE ID = 12 ;
    ELSEIF cParameter = "B" THEN
        SELECT ID, Brand_Name INTO nIdNo, cBrandName FROM vehicle_brands WHERE ID = 12 ;
        SELECT nIdNo AS 'IdNo', cBrandName AS 'BrandName' ;
    ELSEIF cParameter = "C" THEN
        SELECT 12 AS 'IdNo', 'Test Vehicle' as 'BrandName' ;
    END IF;

END

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for anser_test
CREATE DATABASE IF NOT EXISTS `anser_test` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `anser_test`;


-- Dumping structure for procedure anser_test.SP_MOB_Test
DELIMITER //
CREATE DEFINER=`root`@`%` PROCEDURE `SP_MOB_Test`(IN `cParameter` TEXT)
BEGIN
    IF cParameter = "A" THEN
        SELECT ID AS 'IdNo', Brand_Name AS 'BrandName' FROM vehicle_brands WHERE ID = 12 ;
    ELSEIF cParameter = "B" THEN
        SELECT ID, Brand_Name INTO @nIdNo, @cBrandName FROM vehicle_brands WHERE ID = 12 ;
        SELECT @nIdNo AS 'IdNo', @cBrandName AS 'BrandName' ;
    ELSEIF cParameter = "C" THEN
        SELECT 12 AS 'IdNo', 'Test Vehicle' as 'BrandName' ;
    END IF;

END//
DELIMITER ;


-- Dumping structure for table anser_test.vehicle_brands
CREATE TABLE IF NOT EXISTS `vehicle_brands` (
  `ID` int(11) DEFAULT NULL,
  `Brand_Name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table anser_test.vehicle_brands: ~4 rows (approximately)
DELETE FROM `vehicle_brands`;
/*!40000 ALTER TABLE `vehicle_brands` DISABLE KEYS */;
INSERT INTO `vehicle_brands` (`ID`, `Brand_Name`) VALUES
    (1, 'Ford'),
    (2, 'AUDI'),
    (3, 'BMW'),
    (4, 'Benz');
/*!40000 ALTER TABLE `vehicle_brands` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

sql.test=CALL SP_MOB_Test(?

** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
** Service (httputils2service) Create **
** Service (httputils2service) Start **
Class not found: b4j.example.main$_dbresult, trying: b4a.example.main$_dbresult <-- this is expected
Tag: B, Columns: 2, Rows: 1
IdNo   BrandName   
1   Ford