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

com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
A JNDI DataSource for a Mysql JDBC connection @author Mark Matthews

   * expect them to be.
   * 
   * @throws Exception if the test fails.
   */
  public void testBug19169() throws Exception {
    MysqlDataSource toSerialize = new MysqlDataSource();
    toSerialize.setZeroDateTimeBehavior("convertToNull");
    
    boolean testBooleanFlag = !toSerialize.getAllowLoadLocalInfile();
    toSerialize.setAllowLoadLocalInfile(testBooleanFlag);
    
    int testIntFlag = toSerialize.getBlobSendChunkSize() + 1;
    toSerialize.setBlobSendChunkSize(String.valueOf(testIntFlag));
    
    ByteArrayOutputStream bOut = new ByteArrayOutputStream();
    ObjectOutputStream objOut = new ObjectOutputStream(bOut);
    objOut.writeObject(toSerialize);
    objOut.flush();
    
    ObjectInputStream objIn = new ObjectInputStream(new ByteArrayInputStream(bOut.toByteArray()));
    
    MysqlDataSource thawedDs = (MysqlDataSource)objIn.readObject();
    
    assertEquals("convertToNull", thawedDs.getZeroDateTimeBehavior());
    assertEquals(testBooleanFlag, thawedDs.getAllowLoadLocalInfile());
    assertEquals(testIntFlag, thawedDs.getBlobSendChunkSize());
  }

View Full Code Here

   * due to Reference containing RefAddrs with null content.
   * 
   * @throws Exception if the test fails
   */
  public void testBug16791() throws Exception {
    MysqlDataSource myDs = new MysqlDataSource();
    myDs.setUrl(dbUrl);
    Reference asRef = myDs.getReference();
    System.out.println(asRef);
    
    removeFromRef(asRef, "port");
    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
    removeFromRef(asRef, "serverName");
    removeFromRef(asRef, "databaseName");
    
    MysqlDataSource newDs = (MysqlDataSource)new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
  }

View Full Code Here

    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
    removeFromRef(asRef, "serverName");
    removeFromRef(asRef, "databaseName");
    
    //MysqlDataSource newDs = (MysqlDataSource)
    new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
  }

View Full Code Here

    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
    removeFromRef(asRef, "serverName");
    removeFromRef(asRef, "databaseName");
    
    MysqlDataSource newDs = (MysqlDataSource)new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
  }

View Full Code Here

    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
    removeFromRef(asRef, "serverName");
    removeFromRef(asRef, "databaseName");
    
    MysqlDataSource newDs = (MysqlDataSource)new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
  }

View Full Code Here

    if (this.pooledConnection == null) {
      // no-op
      return;
    }
    
    MysqlPooledConnection con = this.pooledConnection; // we need this
                               // later...


    try {
      super.close();
    } finally {

View Full Code Here

   * 
   * @throws Exception if the test fails.
   */
  public void testXADataSource() throws Exception {
  
    MysqlXADataSource ds = new MysqlXADataSource();
    ds.setUrl(dbUrl);
    
    String name = "XA";
    this.ctx.rebind(name, ds);


    Object result = this.ctx.lookup(name);

View Full Code Here

        Class.forName("org.jboss.resource.adapter.jdbc.ValidConnectionChecker");
      } catch (Exception ex) {
        return; // class not available for testing
      }
      
      MysqlXADataSource xaDs = new MysqlXADataSource();
      xaDs.setUrl(dbUrl);
      
      MysqlValidConnectionChecker checker = new MysqlValidConnectionChecker();
      assertNull(checker.isValidConnection(xaDs.getXAConnection().getConnection()));
    }  
  }

View Full Code Here

    }


  }


  public void testBug46925() throws Exception {
    MysqlXADataSource xads1 = new MysqlXADataSource();
    MysqlXADataSource xads2 = new MysqlXADataSource();


    Xid txid = new MysqlXid(new byte[] { 0x1 }, new byte[] { 0xf }, 3306);


    xads1.setPinGlobalTxToPhysicalConnection(true);
    xads1.setUrl(dbUrl);


    xads2.setPinGlobalTxToPhysicalConnection(true);
    xads2.setUrl(dbUrl);


    XAConnection c1 = xads1.getXAConnection();
    assertTrue(c1 instanceof SuspendableXAConnection);
    // start a transaction on one connection
    c1.getXAResource().start(txid, XAResource.TMNOFLAGS);
    c1.getXAResource().end(txid, XAResource.TMSUCCESS);


    XAConnection c2 = xads2.getXAConnection();
    assertTrue(c2 instanceof SuspendableXAConnection);
    // prepare on another one. Since we are using a "pinned" connection
    // we should have the same "currentXAConnection" for both
    // SuspendableXAConnection
    c2.getXAResource().prepare(txid); // this will fail without the fix.

View Full Code Here

   * 
   * @throws Exception
   *             if the test fails.
   */
  public void testBug69506() throws Exception {
    MysqlXADataSource dataSource = new MysqlXADataSource();


    dataSource.setUrl(dbUrl);
    
    XAConnection testXAConn1 = dataSource.getXAConnection();
    XAConnection testXAConn2 = dataSource.getXAConnection();


    Xid duplicateXID = new MysqlXid("1".getBytes(), "1".getBytes(), 1);


    testXAConn1.getXAResource().start(duplicateXID, 0);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

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.