Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- JDBCClient client = JDBCClient.createShared(vertx, new JsonObject()
- .put("url", "jdbc:oracle:thin:@localhost:8787:TEST")
- .put("driver_class", "oracle.jdbc.OracleDriver")
- .put("user", "user")
- .put("password", "****"));
- client.getConnection( connection -> {
- if (connection.succeeded()) {
- SQLConnection con = connection.result();
- JsonObject params = new JsonObject()
- .put("query", "{ call ? := package.procedure(?) }")
- .put("paramsIn", new JsonArray().addNull().add(89))
- .put("paramsOut", new JsonArray().add(JDBCType.REF_CURSOR));
- con.callWithParams(params.getString("query"), params.getJsonArray("paramsIn"), params.getJsonArray("paramsOut"), query -> {
- if(query.succeeded()){
- ResultSet rs = query.result();
- System.out.println(rs.toJson().toString())
- }else{
- System.out.println(req.body() + query.cause().toString());
- }
- });
- } else {
- System.out.println(connection.cause().toString())
- }
- });
- { call ? := package.procedure(?) } java.sql.SQLException: Type de colonne non valide: 2012
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement