Hi!
After migrate from 3.5 to 3.6, my SQL Datasources are not able to query H2. It says the tables are "not found". It works fine when using the same query in SQL Console.

The error:
class org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "EVENTS" not found; SQL statement: select count(id) as EVENTCOUNT from events; [42102-199]

DS json:
{
"dataSources":[
{
"xid":"DS_40b9a8a4-8206-428f-9c1b-8dac016196c0",
"name":"!!!Andre-SQL-EVENTCOUNT",
"enabled":true,
"type":"SQL",
"alarmLevels":{
"POLL_ABORTED":"URGENT",
"STATEMENT_EXCEPTION":"URGENT",
"DATA_SOURCE_EXCEPTION":"URGENT"
},
"purgeType":"YEARS",
"updatePeriods":1,
"updatePeriodType":"MINUTES",
"connectionUrl":"jdbc:h2:/opt/mango/databases/mah2",
"driverClassname":"org.h2.Driver",
"password":"",
"rowBasedQuery":false,
"selectStatement":"select count(id) as EVENTCOUNT from events;",
"username":"",
"quantize":false,
"useCron":false,
"editPermission":"ds-mngt",
"purgeOverride":false,
"purgePeriod":1
}
]
}
Thanks.

Oh yes, now I see that the problem happens only in the legacy UI, in the new datasource page UI, the feature is working properly!

Hi Phil, I just updated my testing instance to 3.6 now, but I didn't see the function working as you mentioned.
Was it deployed?

Andre

Hi there!
Is there a way to give users permission to enable/disable datasources without being a super-admin?

I put a new user group called "ds-mngt" in the "Data Source Management Permissions"(System settings), afterwards users can access and create DS in the DS page. However, when those users try to enable/disable any DS(which they have edit permissions or even the ones they create themselves), an error message says: "Method toggle requires admin access"

Thanks in advance