Examples with MysqlXADataSource com.mysql.jdbc.jdbc2.optional.MysqlXADataSource used on opensource projects

Example 1 with MysqlXADataSource

use of com.mysql.jdbc.jdbc2.optional.MysqlXADataSource in project narayana by jbosstm.

the class PerformanceTestCommitMarkableResource method testXAResource.

// @org.junit.Ignore
@Test
public void testXAResource() throws Exception {
    System.out.println("testXAResource: " + new Date());
    XADataSource dataSource = null;
    if (dbType.equals("oracle")) {
        Class clazz = Class.forName("oracle.jdbc.xa.client.OracleXADataSource");
        dataSource = (XADataSource) clazz.newInstance();
        clazz.getMethod("setDriverType", new Class[] { String.class }).invoke(dataSource, new Object[] { "thin" });
        clazz.getMethod("setServerName", new Class[] { String.class }).invoke(dataSource, new Object[] { "tywin.eng.hst.ams2.redhat.com" });
        clazz.getMethod("setNetworkProtocol", new Class[] { String.class }).invoke(dataSource, new Object[] { "tcp" });
        clazz.getMethod("setDatabaseName", new Class[] { String.class }).invoke(dataSource, new Object[] { "orcl" });
        clazz.getMethod("setUser", new Class[] { String.class }).invoke(dataSource, new Object[] { "dtf11" });
        clazz.getMethod("setPassword", new Class[] { String.class }).invoke(dataSource, new Object[] { "dtf11" });
        clazz.getMethod("setPortNumber", new Class[] { int.class }).invoke(dataSource, new Object[] { 1521 });
    } else if (dbType.equals("sybase")) {
        Class clazz = Class.forName("com.sybase.jdbc3.jdbc.SybXADataSource");
        dataSource = (XADataSource) clazz.newInstance();
        clazz.getMethod("setServerName", new Class[] { String.class }).invoke(dataSource, new Object[] { "192.168.1.5" });
        clazz.getMethod("setDatabaseName", new Class[] { String.class }).invoke(dataSource, new Object[] { "LOCALHOST" });
        clazz.getMethod("setUser", new Class[] { String.class }).invoke(dataSource, new Object[] { "sa" });
        clazz.getMethod("setPassword", new Class[] { String.class }).invoke(dataSource, new Object[] { "sybase" });
        clazz.getMethod("setPortNumber", new Class[] { int.class }).invoke(dataSource, new Object[] { 5000 });
    } else if (dbType.equals("h2")) {
        dataSource = new org.h2.jdbcx.JdbcDataSource();
        ((JdbcDataSource) dataSource).setURL("jdbc:h2:mem:JBTMDB2;MVCC=TRUE;DB_CLOSE_DELAY=-1");
    } else if (dbType.equals("postgres")) {
        dataSource = new PGXADataSource();
        ((PGXADataSource) dataSource).setPortNumber(5432);
        ((PGXADataSource) dataSource).setUser("dtf11");
        ((PGXADataSource) dataSource).setPassword("dtf11");
        ((PGXADataSource) dataSource).setServerName("tywin.eng.hst.ams2.redhat.com");
        ((PGXADataSource) dataSource).setDatabaseName("jbossts");
    } else if (dbType.equals("mysql")) {
        dataSource = new MysqlXADataSource();
        ((MysqlXADataSource) dataSource).setServerName("tywin.eng.hst.ams2.redhat.com");
        ((MysqlXADataSource) dataSource).setPortNumber(3306);
        ((MysqlXADataSource) dataSource).setDatabaseName("jbossts");
        ((MysqlXADataSource) dataSource).setUser("dtf11");
        ((MysqlXADataSource) dataSource).setPassword("dtf11");
    } else if (dbType.equals("db2")) {
        Class clazz = Class.forName("com.ibm.db2.jcc.DB2XADataSource");
        dataSource = (XADataSource) clazz.newInstance();
        clazz.getMethod("setServerName", new Class[] { String.class }).invoke(dataSource, new Object[] { "tywin.eng.hst.ams2.redhat.com" });
        clazz.getMethod("setDatabaseName", new Class[] { String.class }).invoke(dataSource, new Object[] { "BTDB1" });
        clazz.getMethod("setUser", new Class[] { String.class }).invoke(dataSource, new Object[] { "db2" });
        clazz.getMethod("setPassword", new Class[] { String.class }).invoke(dataSource, new Object[] { "db2" });
        clazz.getMethod("setDriverType", new Class[] { int.class }).invoke(dataSource, new Object[] { 4 });
        clazz.getMethod("setPortNumber", new Class[] { int.class }).invoke(dataSource, new Object[] { 50001 });
    } else if (dbType.equals("sqlserver")) {
        Class clazz = Class.forName("com.microsoft.sqlserver.jdbc.SQLServerXADataSource");
        dataSource = (XADataSource) clazz.newInstance();
        clazz.getMethod("setServerName", new Class[] { String.class }).invoke(dataSource, new Object[] { "dev30.mw.lab.eng.bos.redhat.com" });
        clazz.getMethod("setDatabaseName", new Class[] { String.class }).invoke(dataSource, new Object[] { "crashrec" });
        clazz.getMethod("setUser", new Class[] { String.class }).invoke(dataSource, new Object[] { "crashrec" });
        clazz.getMethod("setPassword", new Class[] { String.class }).invoke(dataSource, new Object[] { "crashrec" });
        clazz.getMethod("setSendStringParametersAsUnicode", new Class[] { Boolean.class }).invoke(dataSource, new Object[] { false });
        clazz.getMethod("setPortNumber", new Class[] { int.class }).invoke(dataSource, new Object[] { 3918 });
    }
    Utils.createTables(dataSource);
    doTest(new Handler(dataSource), "_testXAResource_" + dbType);
}