JDBC Insert with Params

[Guru Prasad]

I want to insert a new row into MySQL using the Vert.x JDBCClient. The row contains several differnt data types which includes DateTime, Varchar, double, etc. So I want to perform an insert operation using params. But the Vert.x's SQLConnection object doesn't provide an execute() method which accepts params.

Any suggestions how this can be achieved?

[Jozef Ševčík]

Use updateWithParams() methods.

connection.updateWithParams("insert into x values(?)", new JsonArray().add(1), null);

[Mumuney Abdlquadri]

An example from the examples repo.

https://github.com/vert-x3/vertx-examples/blob/master/jdbc-examples/src/main/java/io/vertx/example/jdbc/query_params/JDBCExample.java

--
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
Visit this group at https://groups.google.com/group/vertx.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/522eb1f0-e129-4b29-a251-35b307576494%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Mumuney Abdlquadri]

Description from docs.

http://vertx.io/docs/vertx-sql-common/java/#_prepared_statement_queries