cannot edit steps and no dashboard in v3.7.7 on linux with MySQL - Klaros Test Management - Forum - Klaros Test Management
cannot edit steps and no dashboard in v3.7.7 on linux with MySQL
Juan Camacaro, modified 11 Years ago.
cannot edit steps and no dashboard in v3.7.7 on linux with MySQL
Youngling Post: 1 Join Date: 3/21/13 Recent Posts
Hi,
we are evaluating klaros community and installed v3.7.7 on linux, opened the application and worked (Dashboard page is there after creating the first project) , changed hibernate.properties to mySQL database, and the dashboard does not work, nor I can edit TestCases Steps, since the tab is disabled.
Here are some parts from the Stack Trace
-----
Problem in renderResponse: /pages/subviews/evaluate/reporting/dashboard/dashboard.jspx @127,69 id="dashboardReport#{reportsDashboard.reports.indexOf(report)}" Could not instantiate Seam component: reportsDashboard
...
-----
Caused by: could not execute query; SQL [select avg(cast(this_.DURATION as double)) as y0_ from K_TEST_CASE_RESULT this_ where this_.CONFIG=? and this_.ENABLED=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
...
-------
I can put the complete stack trace if it helps.
Thanks in advance for any ideas.
we are evaluating klaros community and installed v3.7.7 on linux, opened the application and worked (Dashboard page is there after creating the first project) , changed hibernate.properties to mySQL database, and the dashboard does not work, nor I can edit TestCases Steps, since the tab is disabled.
Here are some parts from the Stack Trace
-----
Problem in renderResponse: /pages/subviews/evaluate/reporting/dashboard/dashboard.jspx @127,69 id="dashboardReport#{reportsDashboard.reports.indexOf(report)}" Could not instantiate Seam component: reportsDashboard
...
-----
Caused by: could not execute query; SQL [select avg(cast(this_.DURATION as double)) as y0_ from K_TEST_CASE_RESULT this_ where this_.CONFIG=? and this_.ENABLED=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
...
-------
I can put the complete stack trace if it helps.
Thanks in advance for any ideas.
Torsten Stolpmann, modified 11 Years ago.
RE: cannot edit steps and no dashboard in v3.7.7 on linux with MySQL
Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
Hi Juan,
Can you please send us the complete log file to support@verit.de and state the version of your MySQL installation?
Thanks,
Torsten
Can you please send us the complete log file to support@verit.de and state the version of your MySQL installation?
Thanks,
Torsten
Torsten Stolpmann, modified 11 Years ago.
RE: cannot edit steps and no dashboard in v3.7.7 on linux with MySQL (Answer)
Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
As we already verified via email you will need org.hibernate.dialect.MySQL5InnoDBDialect in your hibernate.settings file instead oforg.hibernate.dialect.MySQLDialect for your database version, as shown below:
Sorry for the misleading documentation, this has been corrected in the FAQ and forum as well as the upcoming documentation now.
Torsten
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect | |
hibernate.connection.driver_class=com.mysql.jdbc.Driver | |
hibernate.connection.url=jdbc:mysql://localhost:3306/klaros | |
hibernate.connection.username=root | |
hibernate.connection.password=root |
Sorry for the misleading documentation, this has been corrected in the FAQ and forum as well as the upcoming documentation now.
Torsten