[BUG] <update monitoring template error happen>

[tomsun28]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I think this is due the EclipseLink orm replace of hibernate orm process casue

Apply Failed!
Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT id, collector, creator, gmt_create, gmt_update, modifier, monitor_id FROM hzb_collector_monitor_bind WHERE (monitor_id IN [*]?)"; expected "("; SQL statement: SELECT id, collector, creator, gmt_create, gmt_update, modifier, monitor_id FROM hzb_collector_monitor_bind WHERE (monitor_id IN ?) [42001-224] Error Code: 42001 Call: SELECT id, collector, creator, gmt_create, gmt_update, modifier, monitor_id FROM hzb_collector_monitor_bind WHERE (monitor_id IN ?) bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=CollectorMonitorBind sql="SELECT id, collector, creator, gmt_create, gmt_update, modifier, monitor_id FROM hzb_collector_monitor_bind WHERE (monitor_id IN ?)")

Expected Behavior

update success.

Steps To Reproduce

1. update the websocket monitoring template in webui
2. error happen

Environment

HertzBeat version(s): master code

Debug logs

No response

Anything else?

No response

[tomsun28]

see https://stackoverflow.com/questions/12758424/eclipselink-how-to-use-empty-collection-in-in-operator