I don't think we should have a dataconnector table for quartz? Could you share the full log?
On Wed, Oct 28, 2020 at 10:26 PM [email protected] < [email protected]> wrote: > when i submit > > > get the error > ''' > 2020-10-28 16:01:35.218 ERROR 872879 --- [http-nio-8080-exec-10] > o.a.c.c.C.[.[.[.[dispatcherServlet] [175] : Servlet.service() for > servlet [dispatcherServlet] in context with path [] threw exception > [Request processing failed; nested exception is > org.springframework.transaction.TransactionSystemException: Could not > commit JPA transaction; nested exception is > javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse > Persistence Services - 2.6.0.v20150309-bf26070): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'quartz.DATACONNECTOR' doesn't exist > Error Code: 1146 > Call: INSERT INTO DATACONNECTOR (ID, CONFIG, CREATEDDATE, DATAFRAMENAME, > DATATIMEZONE, DATAUNIT, MODIFIEDDATE, NAME, TYPE, VERSION) VALUES (?, ?, ?, > ?, ?, ?, ?, ?, ?, ?) > bind => [12, > {"database":"test","table.name":"hdfs_meta_data_sum1","where":""}, > 1603872095196, null, , 1day, null, source1603869251654, HIVE, 1.2] > Query: InsertObjectQuery(DataConnector{name=source1603869251654type=HIVE, > version='1.2', > config={"database":"test","table.name":"hdfs_meta_data_sum1","where":""}})] > with root cause > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'quartz.DATACONNECTOR' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > ~[?:1.8.0_60] > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > ~[?:1.8.0_60] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[?:1.8.0_60] > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > ~[?:1.8.0_60] > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > at com.mysql.jdbc.Util.getInstance(Util.java:408) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > ''' > i can not find 'quartz.DATACONNECTOR ' in Init_quartz_mysql_innodb.sql > <https://github.com/apache/griffin/blob/master/service/src/main/resources/Init_quartz_mysql_innodb.sql> > please help me. > ------------------------------ > > 姓 名：张 欣 > > 邮 件：[email protected] > > 地 址：杭州市滨江区江南大道3688号潮人汇9楼 > > 网 址：www.ngarihealth.com >
