Package com.mysql.jdbc.jdbc2.optional

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

50
51
52
53
54
55
56
57
58
    MysqlXADataSource xaDs;
   
  public XATest(String name) {
    super(name);
   
    this.xaDs = new MysqlXADataSource();
    this.xaDs.setUrl(BaseTestCase.dbUrl);
    this.xaDs.setRollbackOnPooledClose(true);
  }
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
      return;
    }
   
    Connection conn1 = null;

    MysqlXADataSource suspXaDs = new MysqlXADataSource();
    suspXaDs.setUrl(BaseTestCase.dbUrl);
    suspXaDs.setPinGlobalTxToPhysicalConnection(true);
    suspXaDs.setRollbackOnPooledClose(true);
   
    XAConnection xaConn1 = null;
   
    Xid xid = createXid();
   
    try {
      /*
          -- works using RESUME
        xa start 0x123,0x456;
        select * from foo;
        xa end 0x123,0x456;
        xa start 0x123,0x456 resume;
        select * from foo;
        xa end 0x123,0x456;
        xa commit 0x123,0x456 one phase;
       */
     
      xaConn1 = suspXaDs.getXAConnection();
      XAResource xaRes1 = xaConn1.getXAResource();
      conn1 = xaConn1.getConnection();
      xaRes1.start(xid, XAResource.TMNOFLAGS);
      conn1.createStatement().executeQuery("SELECT 1");
      xaRes1.end(xid, XAResource.TMSUCCESS);
      xaRes1.start(xid, XAResource.TMRESUME);
      conn1.createStatement().executeQuery("SELECT 1");
      xaRes1.end(xid, XAResource.TMSUCCESS);
      xaRes1.commit(xid, true);
     
      xaConn1.close();
     
      /*

        -- fails using JOIN
        xa start 0x123,0x456;
        select * from foo;
        xa end 0x123,0x456;
        xa start 0x123,0x456 join;
        select * from foo;
        xa end 0x123,0x456;
        xa commit 0x123,0x456 one phase;
        */
   
      xaConn1 = suspXaDs.getXAConnection();
      xaRes1 = xaConn1.getXAResource();
      conn1 = xaConn1.getConnection();
      xaRes1.start(xid, XAResource.TMNOFLAGS);
      conn1.createStatement().executeQuery("SELECT 1");
      xaRes1.end(xid, XAResource.TMSUCCESS);
View Full Code Here
2702
2703
2704
2705
2706
2707
2708
2709
2710
2711
2712
2713
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
    }

  }
 
  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.
    c2.getXAResource().commit(txid,false);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
        return new XAMetaMessageSessionFactory(initMetaConfig());
    }


    private static XADataSource getXADataSource() throws SQLException {
        final MysqlXADataSource mysqlXADataSource = new MysqlXADataSource();
        mysqlXADataSource
        .setUrl("jdbc:mysql://localhost:3306/test?characterEncoding=utf8&connectTimeout=1000&autoReconnect=true");
        mysqlXADataSource.setUser("root");
        mysqlXADataSource.setPassword("");
        mysqlXADataSource.setPreparedStatementCacheSize(20);
        return mysqlXADataSource;
    }
View Full Code Here
2821
2822
2823
2824
2825
2826
2827
2828
2829
2830
2831
  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);
View Full Code Here
5375
5376
5377
5378
5379
5380
5381
5382
5383
5384
5385
    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);

    try {
      testXAConn2.getXAResource().start(duplicateXID, 0);
View Full Code Here
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
  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);
View Full Code Here
458
459
460
461
462
463
464
465
   
    new UID().write(dataOut);
   
    final byte[] bqual = bqualOut.toByteArray();
   
    Xid xid = new MysqlXid(gtrid, bqual, 3306);
    return xid;
  }
View Full Code Here
470
471
472
473
474
475
476
477
478
   
    new UID().write(dataOut);
   
    final byte[] bqual = bqualOut.toByteArray();
   
    Xid xid = new MysqlXid(xidToBranch.getGlobalTransactionId(), bqual, 3306);
   
    return xid;
  }
View Full Code Here
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
  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);
View Full Code Here
TOP

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

  • 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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.