B4J Question RDC2: Query definition mandatory in my config.properties?

[moster67]

Just wondering if it is mandatory to define my queries in the config.properties of the RDC2-server?
I tried to define the query as DBCommand.name but with no luck. Maybe I am missing something? If I need to add new queries or modify them, do I need to restart the server?

 

[Erel]

Yes, unless you make a few simple changes.

If I need to add new queries or modify them, do I need to restart the server?

In debug mode the commands file is reloaded each time:

Public Sub GetConnection As SQL
   If DebugQueries Then LoadSQLCommands(LoadConfigMap)
   Return pool.GetConnection
End Sub

You can set DebugQueries to True in release mode as well if you like.

See how LoadSqlCommands sub is implemented. You can change it as you need.