Android Question RDC - Returning alias from MySQL sp is ignored

[achtrade]

Hello community

I have a MySQL SP with this sentence:

select t0.id, t0.Status as `UserStatus`, t1.Status as `PassStatus` from Users t0 inner join Pass t1 on t1.idUser = t0.id;

In the MySQL Workbench I'm getting the correct info:
--------------------------------|
|id | UserStatus | PassStatus|
|1 | A |A |
--------------------------------|
But in the JobDone sub

Dim result As DBResult = reqManager.HandleJob(Job)

result is getting this:
id=1, Status=A, null=A

It's like the alias of the select 'UserStatus' and 'PassStatus' are ignored.

How can I fix it without modify my tables?

Thanks.

 

[Erel]

Try this:
Add useOldAliasMetadataBehavior=true to the JdbcUrl string.

 

[achtrade]

like this ?:

JdbcUrl=jdbc:mysql://localhost/use15?characterEncoding=utf8?useOldAliasMetadataBehavior=true

 

[Erel]

Yes.

 

[achtrade]

thanks

 

[achtrade]

No, it didn't work. I had to change my sp to this:

select ifnull('-1', '-1') as 'id';