Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
None
-
2.4.0
-
None
-
tier docker
Description
With the following config I get the error below:
the uf_change_log_consumer is a table just like grouper_change_log_consumer
grouperClient.syncTable.EXT_IDENTITY.databaseFrom = shibtst
grouperClient.syncTable.EXT_IDENTITY.schemaFrom = IDREGISTRY
grouperClient.syncTable.EXT_IDENTITY.tableFrom = EXT_IDENTITY
grouperClient.syncTable.EXT_IDENTITY.databaseTo = grouper
grouperClient.syncTable.EXT_IDENTITY.schemaTo = grouper
grouperClient.syncTable.EXT_IDENTITY.tableTo = uf_EXT_IDENTITY
grouperClient.syncTable.EXT_IDENTITY.columns = REGISTRY_ID, SEQUENCE_NO, LINKED_ID, UFID, PRINCIPAL, PRIN_RSC_TYP, FRIENDLY_NAME, HONORIFIC_PREFIX, GIVEN_NAME, MIDDLE_NAME, FAMILY_NAME, HONORIFIC_SUFFIX, DISPLAY_NAME, EMAIL, PHONE_NUMBER, PHONE_TYPE, CREATED_TS, INACTIVE_TS, END_TS, STATUS, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01
grouperClient.syncTable.EXT_IDENTITY.primaryKeyColumns = REGISTRY_ID
grouperClient.syncTable.EXT_IDENTITY.groupingColumn = REGISTRY_ID
grouperClient.syncTable.EXT_IDENTITY.groupingSize = 100000
grouperClient.syncTable.EXT_IDENTITY.batchSize = 100000
grouperClient.syncTable.EXT_IDENTITY.realTimeLastUpdatedCol = last_updated
grouperClient.syncTable.EXT_IDENTITY.statusDatabase = grouper
grouperClient.syncTable.EXT_IDENTITY.statusSchema = grouper
grouperClient.syncTable.EXT_IDENTITY.statusTable = uf_change_log_consumer
2019-06-24T01:36:20+00:00 DAEMON:dev grouper-api;grouper_event.log;grouper_dev;daemon;2019-06-23 21:36:20,510: [Thread-152] ERROR GrouperClientLog.error(116) - - Error assigning status and logging
2019-06-24T01:36:20+00:00 DAEMON:dev java.lang.RuntimeException: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().,
2019-06-24T01:36:20+00:00 DAEMON:dev sql: insert into grouper.uf_change_log_consumer ( name, last_sequence_processed, last_updated, created_on, id, hibernate_version_number ) values ( ?, ?, ?, ?, ?, ? )
-------- error
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1901)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1371)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1245)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.select(GcDbAccess.java:1195)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.statusAssignLastUpdated(GcTableSync.java:558)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync$3.run(GcTableSync.java:610)
2019-06-24T01:36:20+00:00 DAEMON:dev at java.lang.Thread.run(Thread.java:748)
2019-06-24T01:36:20+00:00 DAEMON:dev Caused by: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().,
2019-06-24T01:36:20+00:00 DAEMON:dev sql: insert into grouper.uf_change_log_consumer ( name, last_sequence_processed, last_updated, created_on, id, hibernate_version_number ) values ( ?, ?, ?, ?, ?, ? )
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.StatementImpl.checkForDml(StatementImpl.java:385)
2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:964)
2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1896)
2019-06-24T01:36:20+00:00 DAEMON:dev ... 6 more