Examples of com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
This class is used to obtain a physical connection and instantiate and return a MysqlPooledConnection. J2EE application servers map client calls to dataSource.getConnection to this class based upon mapping set within deployment descriptor. This class extends MysqlDataSource. @see javax.sql.PooledConnection @see javax.sql.ConnectionPoolDataSource @see org.gjt.mm.mysql.MysqlDataSource @author Todd Wolff

  public IDataSourceDescriptor createDescriptor(String name, String databaseName, String username) {
    return new DataSourceDescriptorStandard(name, "com.mysql.jdbc.Driver", this.createConnectionURL(databaseName), username);
  }


  public MysqlConnectionPoolDataSource createDataSource(String databaseName, String username, IPassword password) throws SQLException {
    MysqlConnectionPoolDataSource pooled = new MysqlConnectionPoolDataSource();
    pooled.setUser(username);
    pooled.setPassword(new String(password.getPassword()));
    pooled.setDatabaseName(databaseName);
    pooled.setPort(this.port);
    pooled.setLocalSocketAddress("localhost");
    return pooled;
  }

View Full Code Here

    if (uri == null)
    {
      throw new ConfigurationException("Please define a MySQL URI for property: " + URI_PROPERTY);
    }
    
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setUrl(uri);
    
    if (useConfigs != null)
    {
      ds.setUseConfigs(useConfigs);
    }
    ds.setUser("benchmarkdbuser");
    ds.setPassword("benchmarkdbpass");


    this.dataSource = ds;
    }

View Full Code Here

   * @throws Exception
   *             if the test fails.
   */
  public void testChangeUserAndCharsets() throws Exception {
    if (versionMeetsMinimum(4, 1)) {
      MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
      ds.setURL(BaseTestCase.dbUrl);
      ds.setCharacterEncoding("utf-8");
      PooledConnection pooledConnection = ds.getPooledConnection();


      Connection connToMySQL = pooledConnection.getConnection();
      this.rs = connToMySQL.createStatement().executeQuery(
          "SELECT @@character_set_results");
      assertTrue(this.rs.next());

View Full Code Here

   * 
   * @throws Exception
   *             if an error occurs.
   */
  public void testBug4808() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection closeMeTwice = ds.getPooledConnection();
    closeMeTwice.close();
    closeMeTwice.close();


  }

View Full Code Here

    String port = System.getProperty(DS_PORT_PROP_NAME);


    // Only run this test if at least one of the above are set
    if ((databaseName != null) || (userName != null) || (password != null)
        || (port != null)) {
      MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();


      if (databaseName != null) {
        ds.setDatabaseName(databaseName);
      }


      if (userName != null) {
        ds.setUser(userName);
      }


      if (password != null) {
        ds.setPassword(password);
      }


      if (port != null) {
        ds.setPortNumber(Integer.parseInt(port));
      }


      bindDataSource(jndiName, ds);


      ConnectionPoolDataSource boundDs = null;

View Full Code Here

    String serverName = System.getProperty(DS_HOST_PROP_NAME);


    // Only run this test if at least one of the above are set
    if ((databaseName != null) || (serverName != null)
        || (userName != null) || (password != null) || (port != null)) {
      MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();


      if (databaseName != null) {
        ds.setDatabaseName(databaseName);
      }


      if (userName != null) {
        ds.setUser(userName);
      }


      if (password != null) {
        ds.setPassword(password);
      }


      if (port != null) {
        ds.setPortNumber(Integer.parseInt(port));
      }


      if (serverName != null) {
        ds.setServerName(serverName);
      }


      bindDataSource(jndiName, ds);


      ConnectionPoolDataSource boundDs = null;

View Full Code Here

    this.tempDir = File.createTempFile("jnditest", null);
    this.tempDir.delete();
    this.tempDir.mkdir();
    this.tempDir.deleteOnExit();


    MysqlConnectionPoolDataSource ds;
    Hashtable<String, String> env = new Hashtable<String, String>();
    env.put(Context.INITIAL_CONTEXT_FACTORY,
        "com.sun.jndi.fscontext.RefFSContextFactory");
    this.ctx = new InitialContext(env);
    assertTrue("Naming Context not created", this.ctx != null);
    ds = new MysqlConnectionPoolDataSource();
    ds.setUrl(dbUrl); // from BaseTestCase
    ds.setDatabaseName("test");
    this.ctx.bind(this.tempDir.getAbsolutePath() + "/test", ds);
  }

View Full Code Here


    return boundDs;
  }


  public void testCSC4616() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection pooledConn = ds.getPooledConnection();
    Connection physConn = pooledConn.getConnection();
    Statement physStatement = physConn.createStatement();


    Method enableStreamingResultsMethodStmt = Class.forName(
        "com.mysql.jdbc.jdbc2.optional.StatementWrapper").getMethod(

View Full Code Here

     * a prepared statement.
     * 
   * @throws Exception
   */
  public void testBug32101() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection pc = ds.getPooledConnection();
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1"));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", Statement.RETURN_GENERATED_KEYS));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new int[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new String[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY));

View Full Code Here

  }


  public void testBug35810() throws Exception {
    int defaultConnectTimeout = ((ConnectionProperties) this.conn).getConnectTimeout();
    int nonDefaultConnectTimeout = defaultConnectTimeout + 1000 * 2;
    MysqlConnectionPoolDataSource cpds = new MysqlConnectionPoolDataSource();
    String dsUrl = BaseTestCase.dbUrl;
    if (dsUrl.indexOf("?") == -1) {
      dsUrl += "?";
    } else {
      dsUrl += "&";
    }
    
    dsUrl += "connectTimeout=" + nonDefaultConnectTimeout;
    cpds.setUrl(dsUrl);
    
    Connection dsConn = cpds.getPooledConnection().getConnection();
    int configuredConnectTimeout = ((ConnectionProperties) dsConn).getConnectTimeout();
    
    assertEquals("Connect timeout spec'd by URL didn't take", nonDefaultConnectTimeout, configuredConnectTimeout);
    assertFalse("Connect timeout spec'd by URL didn't take", defaultConnectTimeout == configuredConnectTimeout);
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

bean.DbUtility

bean.DbUtilitySMS

cn.iver.common.Config

com.alibaba.druid.util.MySqlUtils

com.carrotsearch.junitbenchmarks.mysql.MySQLConsumer

com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper

com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection

com.nurkiewicz.jdbcrepository.mysql.JdbcRepositoryTestMysqlConfig

com.proofpoint.dbpool.MySqlDataSource

com.taobao.metamorphosis.example.XATransactionProducer

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.