[IGNITE-5303] WebConsole configuration wizard doesn't properly handle multiple RDBMS

• Type: Task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.1
• Assignee: Alexey Kuznetsov
• Reporter: Denis A. Magda
• Created: 26/May/17 23:05
• Updated: 14/Jun/17 04:19
• Resolved: 09/Jun/17 08:08

Description

Imagine a use case when cache_A needs to persist data in database_A while cache_B has to be connected with database_B as a part of a single application.

WebConsole allows importing a schema from both databases but:

• in a final Spring XML configuration there will be only one data source bean defined.
• both cache_A and cache_B will use the data source of a database that was used last for the schema importing.

This is what we need to do:

• Spring XML and Java configurations must include data source beans for every database that was used for the schema importing.
• security.properties file must contain a connection URL and credentials for every database.
• we need to support databases of different and similar vendors. For instance, both database_A and database_B can be MySQL ones or database_B can be based on PostgreSQL.