Which database/driver? Which Clojure library? How are you invoking it? What does the update look like?

SQL Server (driver is com.microsoft.sqlserver/mssql-jdbc version 12.3.0.jre17-preview. When I invoke the query using execute-batch! from next-jdbc, it gives me the empty vector, with no exceptions. But if I just use execute! it does throw. I've discovered that there's stuff wrong with my query that I'm in the process of fixing but I was surprised that execute-batch! doesn't throw as well.

and, to clarify my bad terminology usage, it's a batch insert, not an update :face_in_clouds:

I'm a little surprised you just get an empty array, rather than an exception... but the underlying executeBatch() method is a funny beast and behavior varies across databases. In theory, if one or more statements fail in the batch you should get error indicators in the array in place of update counts, but it isn't entirely clear what should happen if all statements fail, and only certain cases are called out to throw exceptions... ...and not all DB drivers follow the JDBC spec to the letter anyway 😞

Ah, well. At least it's a JDBC quirk then. I can live with that. Thanks.