I have a problem with creating an SQL datasource. I added the parameters and this error appears to me.
In addition, the icons highlighted once clicked, start flashing indefinitely.
Maybe I put the wrong connectionstring? Could someone summarize a guide for creating this kind of datasource? (I read other posts about it before writing here )
Thank you in advance
I would guess the icon flashing was the timeout for the connection and took more waiting or there was an error in the page you could see in your developer tools.
My guess from the configuration you've posted is that you need to have the MySQL port in the connection string, and if you're using the default MySQL port, that should be,
I can guess from your select statement that you intend to be getting data out of Mango's database. Are you using MySQL (where H2 would be the default database)? You can find the appropriate connection string for your database type in your env.properties file, simply replace
Try the settings (if you are trying to query the default H2 database),
Driver class: org.h2.Driver //this is in the contextual help Connection string: /path/to/Mango/databases/mah2 Username: Password:
The H2 database is configured to run as an embedded database and though you can enable the web console for human interaction with the DB while Mango is running (use the
db.web.startproperty in your env.properties), I don't think it's serving database connections, so no.
It probably is possible to make happen, but it may involve performance compromises with the embedded mode of the database.
I would advise converting your system to use MySQL if you intend to have other clients for the database server directly (as opposed to querying Mango through the UI or API)