AnsweredAssumed Answered

DevTest Mysql 8.0.11 DB configuration issue

Question asked by saikagho on May 22, 2018
Latest reply on Jun 6, 2018 by saikagho

Hi,

 

I have installed DevTest 10.3 and want to configure Mysql DB for Enterprise Dashboard and Registry server. For Enterprise Dashboard it worked fine, however while trying to start the registry server getting the below error message ...

 

2018-05-22 10:42:24,226Z (12:42) [main] ERROR com.itko.lisa.utils.JpaUtil - Exception raised checking table existence: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:62)
at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getTables(DatabaseMetaDataUsingInfoSchema.java:835)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getTables(NewProxyDatabaseMetaData.java:2938)
at com.itko.lisa.utils.JpaUtil.allTablesExist(JpaUtil.java:653)
at com.itko.lisa.utils.JpaUtil.<init>(JpaUtil.java:490)
at com.itko.lisa.utils.JpaUtil.getDradisUtil(JpaUtil.java:406)
at com.itko.lisa.dradis.comm.JpaUtilWrapper.getAnnotations(JpaUtilWrapper.java:24)
at com.itko.lisa.dradis.comm.DradisCommContext.doEnterpriseDashboardHandshake(DradisCommContext.java:133)
at com.itko.lisa.coordinator.TestRegistryImpl.initialize(TestRegistryImpl.java:280)
at com.itko.lisa.coordinator.TestRegistryImpl.<init>(TestRegistryImpl.java:239)
at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)
at com.install4j.runtime.launcher.WinLauncher.main(Unknown Source) 

 

1. Mysql version is 8.0.11

2. mysql-connector-java-8.0.11.jar is placed in {{LISA_HOME}}/lib/shared folder

3. site.properties file has been modified with proper DB details

 

Kindly suggest a solution for this.

Outcomes