MySqlSyncDescriptionBuilder method GetDescriptionForTable cannot find table that exists
Posted: Fri 18 Jul 2014 12:31
I have a MySQL database that runs on CentOS 6.4 and the database and table names are "Case Sensitive". I have a database called "DASHBOARD_PROD" and when I specify the database in the connectstring as "DASHBOARD_PROD" and I use the method:
to get the description for table "DASHBOARD_PROD.NB_ADDITIONAL_NOTES", the method throws an exception that states the table does not exist." I turned on the MySQL database traces and found out that the method above uses the MySQL commands:
SHOW KEYS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod WHERE Column_name LIKE '%'
SHOW COLUMNS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod LIKE '%'
As you can see, the database name was converted to lowercase in the SHOW command and since the database names are case sensitive, it does not find the table. This prevents me from provisioning scopes in my database.
Is there any way to prevent that method from converting the database name from the connectstring to lowercase?
Code: Select all
MySqlConnection conn = new MySqlConnection("server=server1;User id=userid;
Password=password;Database=[b]DASHBOARD_PROD[/b]");
MySqlSyncDescriptionBuilder.GetDescriptionForTable("NB_ADDITIONAL_NOTES" conn);
SHOW KEYS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod WHERE Column_name LIKE '%'
SHOW COLUMNS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod LIKE '%'
As you can see, the database name was converted to lowercase in the SHOW command and since the database names are case sensitive, it does not find the table. This prevents me from provisioning scopes in my database.
Is there any way to prevent that method from converting the database name from the connectstring to lowercase?