DB Name in uppercase
I have an mySQL database wehre the DB-name is in uppercase.
I would like to query teh DB with task "SQL Query" from Base [1.3.0] Library\Operations\Databases\JDBC\SQL Query.
But it is not possible to query the database because of uppercases. If I change the database name to lowercase it works fine. I can change the database in lowercase on test-database only but not in production environment.
Is there a solution for my problem.?
Thank you for contacting HPE Forum Support.
Regarding your request, please take a look the following information:
- HPOO Version?
- Install the last Base content Pack Version.
- Also I researched about your issue and this behavior, you can try into MySQL configuration, double check the lower_case_table_names.
I hope this information helps you,
Waiting your answer,
If you find this or any post useful to resolve the issue, please mark this thread as correct answer and other members can benefit with the information given
SW Support Technical Consultant
San Jose, Costa Rica
Hewlett Packard Enterprise “