No database selected Error

Question

Hi, I have set up a JNDI datasource which tests correctly but when I go on to create a 'query' dataset and paste the query in the box i get this error 'No database selected Query is:'  Any ideas what could be causing this issue? thanks in advance.

Comments

Can you please provide the correct answer instead of closing the question?

Thanks

Answer 1

I had not defined the datasource in $knowage_home/conf/ server.xml under the 'url' section(url="jdbc:mariadb://host:3306/datasource"). I added the datasource and knowage could then correctly test for JNDI datasource connections.