Posts by sal

sal · mORMot 1

Hi,

Thanks for information,

Can you please provide reference or example of restful DB access

regards
Sal

sal · mORMot 1

Hi,

I was interpritting the http messages betwwen delphi ORM client server example.

i found that its exchanging json messages where in client json requests contains SQL query and server json response contains SQL response.

1. can you please explain me the significance of session id in POST header and how it is generated
2. if we simulate the same json request from any client (C#, Java) , and send to delphi mORMot server , are we guranteed to get same reponse.

I am avoiding AJAX because we are thick client module.

regards
Sal

sal · mORMot 1

Hi,

Thanks for response

We tried moORMot framework from C# and Java client consuming delphi services through JSON , this is typical webservice implementation. which works fine for us

But now we are struck with ORM component of mORMot , where our database is oracle running in server machine. mORMot framework is also running on same server machine.

we need to develop client (Data Grid) in C# or Java which should reflect key tables of Oracle. all operations(update, delete, insert) on the client table (datagrid) should be reflected in oracle tables.

Can you please suggest how difficult is to implement this requirement and if any references

regards
Sal

sal · mORMot 1

Hi,

I am intersted mORMot ORM component to my project , with regard to this i have following queries

1. can i have java and C#.Net client interacting with delphi ORM server. if yes is there any reference implementation of this ?
2. is there any basic grid based example for delphi client to interact with mORMot server ?

regards
Sal

sal · mORMot 1

Do you mean , I need to use GotoNextJSONObjectOrArray() to do parsing of below JSON string . do you have any sample code for reference.

May be i am lost in initialization part or may be I am doing something wrong basically.

regards
Sal

sal · mORMot 1

Hi,

Sorry if it was confusing , I didn't ask for client side .

Client is sending below JSON string to Server .

string jsondata =
{
"Airport" : {
"Location" : "LAX" ,
"Terminal" : ["terminalA", "terminalB", "terminalC"] ,
"Gate" : ["gate1", "gate2", "gate3", "gate4", "gate5" ],
"BHS" : "Siemens" ,
"DCS" : "Altiea"
},
"Airline" : {
"CX" : ["B777", "B737", "A380", "A320" ],
"QR" : ["A319", "A380", "B787" ],
"ET" : "380",
"SQ" : "A320"
},
"GroundHandler" : ["Swissport","SATS","Wings","TollData"]
}

Now server receives the JSON string successfully . after receiving I want to break (parse) the received JSON string into individual components(strings) as below. with JSONDecode , JSONToObject functions , I am not able to parse the JSON string successfully , so I wanted to know if mORMoT Framework supports complex JSON parsing or do we need to use other JSON parsing libraries (eg TinyJSON, SuperObject etc) . if mORMot framework supports complex JSON object parsing, I appreciate if you could provide link to an example.

string Airport := '{
"Location" : "LAX" ,
"Terminal" : ["terminalA", "terminalB", "terminalC"] ,
"Gate" : ["gate1", "gate2", "gate3", "gate4", "gate5" ],
"BHS" : "Siemens" ,
"DCS" : "Altiea"
}'

string Airline := '{
"CX" : ["B777", "B737", "A380", "A320" ],
"QR" : ["A319", "A380", "B787" ],
"ET" : "380",
"SQ" : "A320" }

string groundhandler = '["Swissport","SATS","Wings","TollData"] '

Hope you understood the probem.

regards
Sal

sal · mORMot 1

Hi,

I am able to receive following JSON string from client , I want to parse into individual elements in 2 levels.

string jsondata =
{
"Airport" : {
"Location" : "LAX" ,
"Terminal" : ["terminalA", "terminalB", "terminalC"] ,
"Gate" : ["gate1", "gate2", "gate3", "gate4", "gate5" ],
"BHS" : "Siemens" ,
"DCS" : "Altiea"
},
"Airline" : {
"CX" : ["B777", "B737", "A380", "A320" ],
"QR" : ["A319", "A380", "B787" ],
"ET" : "380",
"SQ" : "A320"
},
"GroundHandler" : ["Swissport","SATS","Wings","TollData"]
}

I want to parse this JSON object in 2 levels

first level , values of : "Airport" , "Airline" , "GroundHandler" elements should be parsed into separate arrays or objects

second level , values of : "Location", "Terminal", "Gate","BHS","DCS","CX","QR","ET","SQ" should be parsed into separate set of arrays or objects

I tried with JSONDecode, JSONToObject, GetJSONField functions , but am not able to get desired results .

Can you please help with sample mechanisms to get this parsed or do I need to use any other Delphi JSON parsers to accomplish my requirement

Thanks and regards
Sal

sal · mORMot 1

Hi,

Thanks for your prompt and quick reply. I will try your sample on Java Client . can you please provide more clarity on following items

1. What you mean by DB Model in your statement "But it will depend on how your DB model is handled" , the reason is to know if there are any particular model to be used for certain kind of transaction. some reference to this topic would be really helpful to understand in detail.

2. How can I build similar JSON string as below from my Delphi client , because I find AddJsonEscape() function depends on particular template. is there any flexible mechanism to build complex JSON object or string at client side.

{
"Airport":
[
{
"Location": "LAX",
"Terminal": ["terminalA","terminalB","terminalC"],
"Gate": ["gate1","gate2","gate3","gate4","gate5"],
"BHS": "Siemens",
"DCS": "Altiea"
}
],
"Airline":
[
{
"CX": ["B777","B737","A380","A320"],
"QR": ["A319","A380","B787"],
"ET": "380",
"SQ": "A320"
}
],
"GroundHandler": ["Swissport","SATS","Wings","TollData"]
}

Thanks again for your feedback

regards
Sal

sal · mORMot 1

Hi ,

I am new MorMot Framework , was trying out with samples provides with framework., interface example works for simple data types like integers and chars. but i am lost while i am trying to transmit complex JSON objects like the once specified below

Our teams intention is to transmit Complex JSON Strings with HTTP post method from Java client, we are evaluating different high performance server side framework to meet our requirements. i thought Interface based services samples would be right sample which more or less seems to be configured for 3-tier.

Please let me know if there are any other sample which closely aligns to our above requirement, our JSON is as stated below

{   
    "Airport" :  { 
         "Location" : "LAX" , 
         "Terminal" : ["terminalA", "terminalB", "terminalC"] ,
         "Gate"      : ["gate1", "gate2", "gate3", "gate4", "gate5" ],
         "BHS"       : "Siemens" ,
         "DCS"       : "Altiea" 
    },
    "Airline" : {
        "CX" : ["B777", "B737", "A380", "A320" ],
        "QR"  : ["A319", "A380", "B787" ],
        "ET"   : "380",
        "SQ"  : "A320"
    },
    "GroundHandler" : ["Swissport","SATS","Wings","TollData"]
}

I appreciate your quick response and let me know if any info is needed.

regards
Sal

mORMot Open Source

#1 Re: mORMot 1 » integrating ORM component with Java or C# » 2013-07-20 06:13:03

#2 Re: mORMot 1 » integrating ORM component with Java or C# » 2013-07-09 10:36:25

#3 Re: mORMot 1 » integrating ORM component with Java or C# » 2013-07-09 07:40:24

#4 mORMot 1 » integrating ORM component with Java or C# » 2013-07-09 05:35:29

#5 Re: mORMot 1 » Interface example for transmitting complex JSON Object » 2013-05-20 13:37:49

#6 Re: mORMot 1 » Interface example for transmitting complex JSON Object » 2013-05-20 13:24:39

#7 Re: mORMot 1 » Interface example for transmitting complex JSON Object » 2013-05-20 09:25:07

#8 Re: mORMot 1 » Interface example for transmitting complex JSON Object » 2013-05-19 08:26:18

#9 mORMot 1 » Interface example for transmitting complex JSON Object » 2013-05-17 10:04:11

Board footer