The following _un-tested_ code demonstrate how to use two different connection pools

// MySQL Connection Pool ConnectionPool_T myPool = ConnectionPool_new(URL_new("mysql://root:swordfish@localhost:3306/test")); ConnectionPool_start(myPool);

// Postgres Connection Pool ConnectionPool_T pgPool = ConnectionPool_new(URL_new("postgresql://root:swordfish@localhost/test")); ConnectionPool_start(pgPool);

// MySQL Connection Connection_T mc = ConnectionPool_getConnection(myPool); // Postgres Connection Connection_T pc = ConnectionPool_getConnection(pgPool);

// Select from MySQL and Prepare to insert into Postgres ResultSet_T r = Connection_executeQuery(mc, "select id, name from employee”); PreparedStatement_T p = Connection_prepareStatement(pc, "INSERT INTO employee(id, name) VALUES(?, ?)”);

while (ResultSet_next(r)) { // Select from MySQL int id = ResultSet_getInt(r, 1); const char *name = ResultSet_getString(r, 2);

// Insert into Postgres PreparedStatement_setInt(p, 1, id); PreparedStatement_setString(p, 2, name); PreparedStatement_execute(p); }

[..]

// Close URL_T myURL = ConnectionPool_getURL(myPool); ConnectionPool_free(&myPool); URL_free(&myURL);

URL_T pgURL = ConnectionPool_getURL(pgPool); ConnectionPool_free(&pgPool); URL_free(&pgURL);

On 12 Aug 2015, at 08:14, patel ravi patel_ravij@yahoo.com wrote:

Hello, I am using libzdb for database connection pool from a C++ program . Till now I was making only one database connection pool through libzdb and was working perfect . Now I need to make multiple database connection pools , I tried making this , but it consider only one connection pool and fetch the data from only one database . I found that Multiple database connection is possible through libzdb , somehow I am not able to do that . Any help will be appriciated.

Thank You, Ravi