[DDLUTILS-276] Impossible to use one DataSource to read/update 2 database models from the same DB server.

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.0, 1.1
• Component/s: Core - MySql
• Environment: Ubuntu 10.02, 64 bit, MySQL 5
• Assignee: Thomas Dudziak
• Reporter: Masker71
• Created: 27/Feb/12 02:08
• Updated: 27/Feb/12 02:08

Description

My jdbc URL does not contain catalog (database) name:
jdbc:mysql://localhost:3306?autoReconnect=true&zeroDateTimeBehavior=convertToNull&characterEncoding=UTF8

DBs test1 and test2 are located on the same server.

I tried different hacks to make it working with the same DataSource.
But it keeps throwing exception saying that database not selected, even though I am sending database name AND catalog.
I am not sure why would you need two, but neither of them is switching current database anyway (at least not for MySQL).

Database test1 = platform.readModelFromDatabase( "test1" );
Database test2 = platform.readModelFromDatabase( "test2" );

These two lines are not working also:
Database test1 = platform.readModelFromDatabase( "test1", "test1", false, false );
Database test2 = platform.readModelFromDatabase( "test2", "test2", false, false );