Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Dynamic Database Connections
14-Jun-2017, 09:46 AM
Post: #1
Dynamic Database Connections
Hi
Our users have requested that some information from another system, on different SQL servers, be displayed within our WM forms. Based on the client, this could be on one of a number of SQL servers. We already maintain a cross-reference table, but is there a way within WM to dynamically select the connection to be used when the client selection changes.

thanks
Find all posts by this user
Quote this message in a reply
14-Jun-2017, 11:09 AM
Post: #2
RE: Dynamic Database Connections
Hi kidder,

You can set up any number of database connections in WebMaker, but the connection details for each one do need to be known when the project is published.

If you have a manageable number of database connections then you could set these all up in your project, either directly in WebMaker, or by using different JNDI resources.
Although each SQL Statement action must use a specific connection, you could set up multiple rules in your controller, each one performing the appropriate query against a different database. By using rule conditions you could determine which one gets used based on the current client information passed in etc.

If this is not a possible solution for you then you may need to use some custom code unfortunately. In this case, one option would be to write a Java Method which would handle dynamically connecting to the appropriate database and performing the required query. This would obviously require more work to implement though.

If you need any more details on these options please let me know.

Regards,
Gerard
Find all posts by this user
Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  dynamic date constraints in editable table Sherman 4 3,836 06-Jun-2014 03:03 PM
Last Post: Sherman
  problem with editable row and database driven dropdown menu benkillin 1 3,816 04-Sep-2013 10:28 AM
Last Post: Steve
Question Force the Workitem Cache to refresh from database Hawk 3 4,162 27-Aug-2013 12:18 PM
Last Post: Hawk
  dynamic subrecord sets benkillin 5 4,421 25-Jul-2013 11:42 AM
Last Post: Abdul
  delete database connection anand 1 2,837 24-Aug-2011 09:06 AM
Last Post: Gerard
  Is the auto-generated database commit rule correct? Taeho.BPM 1 2,140 03-Mar-2011 05:05 PM
Last Post: Gerard

Forum Jump:


User(s) browsing this thread: 1 Guest(s)