Examples of com.alibaba.wasp.jdbcx.JdbcDataSource

com.alibaba.wasp.jdbcx.JdbcDataSource

A data source for H2 database connections. It is a factory for XAConnection and Connection objects. This class is usually registered in a JNDI naming service. To create a data source object and register it with a JNDI service, use the following code:

 import com.alibaba.wasp.jdbcx.JdbcDataSource; import javax.naming.Context; import javax.naming.InitialContext; JdbcDataSource ds = new JdbcDataSource(); ds.setURL("jdbc:wasp:˜/test"); ds.setUser("sa"); ds.setPassword("sa"); Context ctx = new InitialContext(); ctx.bind("jdbc/dsName", ds);

To use a data source that is already registered, use the following code:

 import java.sql.Connection; import javax.sql.DataSource; import javax.naming.Context; import javax.naming.InitialContext; Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("jdbc/dsName"); Connection conn = ds.getConnection();

In this example the user name and password are serialized as well; this may be a security problem in some cases.

    Class.forName("com.alibaba.wasp.jdbc.Driver");


    conf = TEST_UTIL.getConfiguration();
    conf.setInt(FConstants.JDBC_POOL_MAX_CONNECTIONS, 3);


    pool = JdbcConnectionPool.create(new JdbcDataSource(conf), conf);
  }

      }
    } catch (SQLException e) {
      assertTrue(e.getMessage().indexOf("get connection timeout") != -1);
    }


    pool = JdbcConnectionPool.create(new JdbcDataSource(conf), conf);
    for (int i = 0; i < 5; i++) {
      Connection conn = pool.getConnection();
      conn.close();
    }

Examples of com.alibaba.wasp.jdbcx.JdbcDataSource

Related Classes of com.alibaba.wasp.jdbcx.JdbcDataSource