B4J Question jRDC2 and #SQL COMMANDS

Alberto Michelis · Apr 20, 2017

Hi,
Can I add and modify #SQL COMMANDS in the config.properties files with the server running?
I mean without havong to restart it

Any way of not to use #SQL COMMANDS in the config.properties and send it directly from the client?

Thanks

EnriqueGonzalez · Apr 20, 2017

Can I add and modify #SQL COMMANDS in the config.properties files with the server running?

Yes! just move the file from file.dirassets to file.dirapp (or any other directory)

Any way of not to use #SQL COMMANDS in the config.properties and send it directly from the client?

Yes but this way is more secure, anyway you will be in the need to modify heavily the JRDC module.

Alberto Michelis · Apr 20, 2017

May be I dont fully understand how it works.
You are talking as like the java server is intalled and running in the Android phone.
I suppouse the java server must run in the windows server that holds the MsSql data server
Am I wrong?

EnriqueGonzalez · Apr 20, 2017

I suppouse the java server must run in the windows server that holds the MsSql data server

Thats correct, JRDC Server is exclusively for Computer and cannot ran on android (linux and Mac Os are good too)

You are talking as like the java server is intalled and running in the Android phone.

No. File.dirapp and File.direAssets exists too for B4J

Harris · Apr 20, 2017

Alberto Michelis said:
Can I add and modify #SQL COMMANDS in the config.properties files with the server running?

#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

Erel · Apr 21, 2017

Note that the Debug property was removed in jRDC2. It will reload the configuration file automatically when you run jRDC2 in debug mode.
You can put it in the Files folder. It will still be updated.

Alberto Michelis · Apr 21, 2017

I am confused.
I have only a Files folder under jRDC, no dirApp or dir Assets
I understand that to reload the config without having to recompile each time its enought to have it compiled in Debug mode?

Alberto Michelis · Apr 21, 2017

Enrique Gonzalez R said:
Yes but this way is more secure, anyway you will be in the need to modify heavily the JRDC module.

How can I do it? I dont care to be more secure but the
possibility of change the queries from the app.
In my case there are queries generates in run time, with complex filters, etc.

EnriqueGonzalez · Apr 21, 2017

@Alberto Michelis

Attached you will find a modified JRDC2, i did not test it but should be okey.

You should use it like this:

B4X:

'Inserted query in the DBCommand
    Type DBCommand (Name As String,query As String, Parameters() As Object)

    Dim dbc As DBCommand
    dbc.Initialize
    dbc.Name = "Query"
    dbc.query = $"
        SELECT * FROM customers WHERE id = ?
    "$
   
    dbc.Parameters = Array As String(1)
   
    'This part only shows how to capture the information, you can modify it for your needs. 
    Dim req As DBRequestManager = CreateRequest
    Dim j As HttpJob = CreateRequest.ExecuteQuery(dbc,0,"")
    Wait For(j) JobDone(j As HttpJob)
    If j.Success Then
        req.HandleJobAsync(j, "req")
        Wait For (req) req_Result(res As DBResult)
        'work with result
        req.PrintTable(res)
    Else
        Log("ERROR: " & j.ErrorMessage)
    End If
    j.Release

Alberto Michelis · Apr 21, 2017

Tks, will test it

B4J Question jRDC2 and #SQL COMMANDS

Alberto Michelis

Well-Known Member

EnriqueGonzalez

Well-Known Member

Alberto Michelis

Well-Known Member

EnriqueGonzalez

Well-Known Member

Harris

Expert

Erel

B4X founder

Alberto Michelis

Well-Known Member

Alberto Michelis

Well-Known Member

EnriqueGonzalez

Well-Known Member

Attachments

Alberto Michelis

Well-Known Member

Similar Threads

B4J Question jRDC2 and #SQL COMMANDS

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Expert

B4X founder

Well-Known Member

Well-Known Member

Well-Known Member

Attachments

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency