[
https://issues.apache.org/jira/browse/GRIFFIN-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16709124#comment-16709124
]
Saket Bihari commented on GRIFFIN-219:
--------------------------------------
Thanks...that driver class issue has been resolved. Now while starting the
service getting an error on DDL Syntax exception. Please find below.
[EL Fine]: sql: 2018-12-04
18:56:01.002--ServerSession(551016187)--Connection(302366050)--CREATE TABLE
RULE (ID BIGINT NOT NULL, CREATEDDATE BIGINT, DETAILS VARCHAR(1024), DQTYPE
VARCHAR(255), DSLTYPE VARCHAR(255), INDATAFRAMENAME VARCHAR(255), MODIFIEDDATE
DATETIME, OUT VARCHAR(255), OUTDATAFRAMENAME VARCHAR(255), RULE VARCHAR(8192),
evaluate_rule_id BIGINT, PRIMARY KEY (ID))
[EL Fine]: sql: 2018-12-04 18:56:01.006--ServerSession(551016187)--SELECT 1
[EL Warning]: 2018-12-04 18:56:01.037--ServerSession(551016187)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'OUT VARCHAR(255),
OUTDATAFRAMENAME VARCHAR(255), RULE VARCHAR(8192), evaluate_ru' at line 1
Error Code: 1064
> Griffin 0.3.1 Application Startup getting Failed due to mysql driver
> --------------------------------------------------------------------
>
> Key: GRIFFIN-219
> URL: https://issues.apache.org/jira/browse/GRIFFIN-219
> Project: Griffin (Incubating)
> Issue Type: Bug
> Affects Versions: 0.3.0-incubating
> Environment: CentOS 7.5
> Reporter: Saket Bihari
> Assignee: Kevin Yao
> Priority: Major
>
> Please find the details below:
> Executing: java -jar service-0.3.0-incubating.jar
> Getting Error:
> ------------------------
> Exception encountered during context initialization - cancelling refresh
> attempt: org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'eclipseLinkJpaConfig' defined in URL
> [jar:file:/root/griffin-0.3.0-incubating/service/target/service-0.3.0-incubating.jar!/BOOT-INF/classes!/org/apache/griffin/core/config/EclipseLinkJpaConfig.class]:
> Unsatisfied dependency expressed through constructor parameter 0; nested
> exception is org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'dataSource' defined in class path resource
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]:
> Bean instantiation via factory method failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Failed to instantiate
> [org.apache.tomcat.jdbc.pool.DataSource]: Factory method 'dataSource' threw
> exception; nested exception is java.lang.IllegalStateException: Cannot load
> driver class: com.mysql.jdbc.Driver
> 2018-12-04 08:40:01.007 INFO 67767 --- [ main]
> utoConfigurationReportLoggingInitializer :
> Error starting ApplicationContext. To display the auto-configuration report
> re-run your application with 'debug' enabled.
> 2018-12-04 08:40:01.010 ERROR 67767 --- [ main] o.s.b.SpringApplication :
> Application startup failed
> application.properties file:
> ------------------------------
> # jpa
> spring.datasource.url =
> jdbc:mysql://xxxxxxx.cloudapp.azure.com:3306/quartz?autoReconnect=true&useSSL=false
> spring.datasource.username = username
> spring.datasource.password = password123
> spring.jpa.generate-ddl=true
> spring.datasource.driverClassName = com.mysql.jdbc.Driver
> spring.jpa.show-sql = true
> # hive metastore
> hive.metastore.uris = thrift://xxxxxx.cloudapp.azure.com:9083
> hive.metastore.dbname = default
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
