List of usage examples for io.vertx.pgclient PgPool pool
static PgPool pool(PgConnectOptions connectOptions, PoolOptions poolOptions)
From source file:examples.PgClientExamples.java
License:Apache License
public void gettingStarted() { // Connect options PgConnectOptions connectOptions = new PgConnectOptions().setPort(5432).setHost("the-host") .setDatabase("the-db").setUser("user").setPassword("secret"); // Pool options PoolOptions poolOptions = new PoolOptions().setMaxSize(5); // Create the client pool PgPool client = PgPool.pool(connectOptions, poolOptions); // A simple query client.query("SELECT * FROM users WHERE id='julien'", ar -> { if (ar.succeeded()) { RowSet<Row> result = ar.result(); System.out.println("Got " + result.size() + " rows "); } else {/*from w w w. ja va 2s . c om*/ System.out.println("Failure: " + ar.cause().getMessage()); } // Now close the pool client.close(); }); }
From source file:examples.PgClientExamples.java
License:Apache License
public void connecting01() { // Connect options PgConnectOptions connectOptions = new PgConnectOptions().setPort(5432).setHost("the-host") .setDatabase("the-db").setUser("user").setPassword("secret"); // Pool options PoolOptions poolOptions = new PoolOptions().setMaxSize(5); // Create the pooled client PgPool client = PgPool.pool(connectOptions, poolOptions); }
From source file:examples.PgClientExamples.java
License:Apache License
public void connecting06(Vertx vertx) { // Connect Options // Socket file name will be /var/run/postgresql/.s.PGSQL.5432 PgConnectOptions connectOptions = new PgConnectOptions().setHost("/var/run/postgresql").setPort(5432) .setDatabase("the-db"); // Pool options PoolOptions poolOptions = new PoolOptions().setMaxSize(5); // Create the pooled client PgPool client = PgPool.pool(connectOptions, poolOptions); // Create the pooled client with a vertx instance // Make sure the vertx instance has enabled native transports PgPool client2 = PgPool.pool(vertx, connectOptions, poolOptions); }