CODEWITHSUNDEEP
jdbcinformix
lsv
lsv

Reputation: 1757

How to make allowMultiQueries in INFORMIX sql queries

I have a question about supporting allowMultiQueries in INFORMIX sql queries I know a way for MySQL:

jdbc:mysql://10.242.182.152:3306/db?allowMultiQueries=true

Is there a way for INFORMIX ?

Upvotes: 1

Views: 306

Answers (1)

Michał Niklas
Michał Niklas

Reputation: 54322

In Informix it is standard to use multiple INSERT/UPDATE/DELETE statements in one execute() call. It works with ODBC and JDBC drivers I use. I don't know if you can mix it with SELECT statements, but my eyes hurts when I see JDBC code that works with MySQL mixture of INSERT and SELECT. For such complicated things I would use stored function.

PS I don't like this feature while it is easier to write code that can be attacked by SQL injection.

Upvotes: 1

Related Questions