The way you use prepared statement is actually creating a insert query without telling the driver column types. It can be optimized by changing the query to INSERT INTO device_user (device_type,device ...

create a table in clickhouse create a prepared statement from a concatenated insert string containing the table name add multiple values to the prepared statement in a batch use executeLargeBatch ...

PreparedStatement.setTimestamp ()でミリ秒が付いたデータを指定した場合に発生するエラー「SQLState = , Code = <1060>」の原因と対処について Symfoware Server (Native Interface)のよくあるご質問 を検索できます。