new> datasour...">
Clever Geek Handbook

How to fix "datasource serviceImpl.error_0009" in pentaho?

I login to pentaho using admin username and password, then go to file> new> datasource, select "SQL QUERY" then enter my database and test it to connect to the database, it will be successful. When I try to test a new datasource using sql query I type " select 1 from mytable

" and it gives me this error:

datasourceServiceImpl.error_0009 request validation failed: request validation failed {0}

That's all it gives me and I don't know how to fix it.

Biserver-ce-5.1.0.0-752 works for me

+3


source to share


4 answers


Stop the server.
Change the driver mysql .. \ tomcat \ lib "mysql-connector-java-5.1.17.jar"

driver folder "mysql-connector-java-5.1.25-bin.jar"

.
Reboot the server and it should work.



+3


source


I fixed the problem by removing the ";" at the end of my request.



+2


source


I got this error and found it was as easy as having two columns with the same name in my SELECT statement.

0


source


Install mysql-connector-java-gpl-xxxmsi Put in lib folder mysql-connector-java-xxxjar

-1


source






More articles:


All Articles