Package com.mysql.jdbc.jdbc2.optional

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

418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
    this.pstmt = pds.getPooledConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();

    MysqlXADataSource xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);
    this.pstmt = xads.getXAConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();

    xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);
    xads.setPinGlobalTxToPhysicalConnection(true);
    this.pstmt = xads.getXAConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();
  }
View Full Code Here
2498
2499
2500
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
    }

  }

  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
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
    this.pstmt = pds.getPooledConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();

    MysqlXADataSource xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);
    this.pstmt = xads.getXAConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();

    xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);
    xads.setPinGlobalTxToPhysicalConnection(true);
    this.pstmt = xads.getXAConnection().getConnection()
        .prepareStatement("SELECT 1");
    this.pstmt.execute();
    this.pstmt.close();
  }
View Full Code Here
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
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
434
435
436
437
      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
212
213
214
215
216
217
218
219
220
221
222
223
   *
   * @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
327
328
329
330
331
332
333
334
335
336
337
338
        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
2557
2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
    }

  }

  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
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
2585
2586
    }

  }

  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
52
53
54
55
56
57
58
59
60
    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
TOP

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

  • 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.