In statement implementation

[Laputa]

I tried to do some query to mysql using vertx jdbc client but i never make  "IN"clause works in query... how i do that

here is my code:

client.getConnection(c->{

      if(c.succeeded()){

             c.updateWithParams("delete from some_table where some_key in ?",new JsonArray().add(new JsonArray().add(1).add(2)),h->{

                   /** get update result .... its only remove one 

             });

      }

});

is my code wrong or someting ?

please implements this in JDBCStatementHelper#fillStatement(PreparedStatement statement, JsonArray in)

[Paulo Lopes]

The issue is that JDBC arrays are not currently supported due to the fact that JDBC requires type metadata in order to create an array, you can however solve your issue at the sql level:

c.updateWithParams("delete from some_table where some_key in (?, ?)", new JsonArray().add(1).add(2), h-> { ... });

[Laputa]

OK then i think i must do like that, thanks