Android Question JRDC2 Map parameters to stored procedures

[makis_best]

Hi.

I have a B4A client connected to JRDC2 server and MSSQL.
Is there any way we can pass from B4A map variables through jrdc2 to stored procedures?

Thank you.

 

[OliverA]

Do you have an example of a pure MS SQL feature you are trying to emulate via jRDC2 and maps?

 

[makis_best]

No.

That is what I want to know.
If it is possible to do.

 

[aeric]

Not sure about maps but can call stored procedures like this:

sql.sp_UpdateTable = CALL sp_UpdateTable(?, ?)

 

[makis_best]

Thanks @aeric
I already use it that way.
I want to know if I can pass maps cuz the size of value is to big to send with string

 

[Erel]

B4XSerializator can serialize maps. This means that it should be quite simple to modify the client and server custom types and add a map to DBCommand.

 

[OliverA]

I want to know if I can pass maps cuz the size of value is to big to send with string

Since jRDC2 uses parameterized queries, and the parameters that are sent to jRDC2 are serialized (via B4XSerializator), what makes you think the value is too big? Too big to sent to jRDC2? Too big for MS SQL to handle? Where does the limitation come from?

Edit: to vs too. Need more coffee...

 

[makis_best]

So need to customize jrdc2 to succeed

 

[makis_best]

Since jRDC2 uses parameterized queries, and the parameters that are sent to jRDC2 are serialized (via B4XSerializator), what makes you think the value is too big? Too big to sent to jRDC2? Too big for MS SQL to handle? Where does the limitation come from?

Edit: to vs too. Need more coffee...

To big for jRDC2 to handle

 

[OliverA]

To big for jRDC2 to handle

Now my curiosity is piqued. How big is your string? Can you provide an example of a MS SQL stored procedure that would process such a big string?

 

[makis_best]

I said I don't have.
I want to crate some.

 

[OliverA]

I said I don't have.
I want to crate some.

Then how do you know the string is too big for jRDC2?

 

[makis_best]

I know the result of my client app will be a map with very long strings
and I want to know if JRDC2 can handle that kind of maps

 

[OliverA]

B4XSerializator should. You still need to modify jRDC2 to receive the map and process it in such a way so that you can pass the info into the stored procedure. When you get this done, would be nice if you can do a write up on how you did it. Others may be intrigued in such functionality (passing B4X maps to MS SQL stored procedures)

 

[makis_best]

Thank you all for your help

 

[hatzisn]

@makis_best Why don't you use a vb.net web service directly in IIS and pass there in XML all the values in a string. I would create a json in b4a, URL encode it and send it in a string of the web service. On vb.net side, I would UrlDecode it (Uri.UnescapeDatastring), deserialize it (in a dictionary = map in b4a) and get all the values - no problem. I suppose you can do the same with the jRDC2 but I have never used it so I am not in a position to express any suggestions for it.

In vb.net there is built in way to use stored procedures with parameters.

 

[makis_best]

@makis_best Why don't you use a vb.net web service directly in IIS and pass there in XML all the values in a string. I would create a json in b4a, URL encode it and send it in a string of the web service. On vb.net side, I would UrlDecode it (Uri.UnescapeDatastring), deserialize it (in a dictionary = map in b4a) and get all the values - no problem. I suppose you can do the same with the jRDC2 but I have never used it so I am not in a position to express any suggestions for it.

In vb.net there is built in way to use stored procedures with parameters.

It is also a very good idea.
I haven't think about it cuz all the time I use JRDC2 for that kind of connections.
I check... Thanks

 

[Erel]

I don't understand anything from this strange thread.
B4J jServer (actually Jetty) has better performance than ASP .Net. Why do you make things more complicated than they should be???

 

[makis_best]

I don't want to make it complicated...
I just ask for some opinions.
My scale balance to jServer my self also.