当前位置: 首页>>代码示例>>Java>>正文

Java TDataSource.setAppName方法代码示例

本文整理汇总了Java中com.taobao.tddl.matrix.jdbc.TDataSource.setAppName方法的典型用法代码示例。如果您正苦于以下问题：Java TDataSource.setAppName方法的具体用法？Java TDataSource.setAppName怎么用？Java TDataSource.setAppName使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.taobao.tddl.matrix.jdbc.TDataSource的用法示例。


在下文中一共展示了TDataSource.setAppName方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: initTestWithDS

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
@Test
public void initTestWithDS() throws TddlException, SQLException {

    TDataSource ds = new TDataSource();
    ds.setAppName("andor_show");
    ds.setTopologyFile("test_matrix.xml");
    ds.setSchemaFile("test_schema.xml");
    ds.init();

    Connection conn = ds.getConnection();
    PreparedStatement ps = conn.prepareStatement("select * from bmw_users limit 10");
    ResultSet rs = ps.executeQuery();

    Assert.assertTrue(rs.next());

    rs.close();
    ps.close();
    conn.close();
}
开发者ID:loye168，项目名称:tddl5，代码行数:20，代码来源:TDatasourceTest.java

示例2: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("XIAMI_WEB_ATHENA");

        Map cp = new HashMap();
        cp.put(ConnectionProperties.ALLOW_TEMPORARY_TABLE, "true");
        // cp.put(ConnectionProperties.MERGE_CONCURRENT, "true");
        ds.setConnectionProperties(cp);
        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // select all records
        PreparedStatement ps = conn.prepareStatement("select user_id,num from (SELECT user_id, count(*) AS num FROM receive_flowers GROUP BY user_id  having num >= 100) t ORDER BY num desc");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:41，代码来源:LeiwenSample.java

示例3: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("INTL_COMM_DEV_APP");

        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // select all records
        PreparedStatement ps = conn.prepareStatement("SELECT * from ae_macro_daily_target a left join ae_macro_daily_target_value b on a.target_id=b.target_id where a.type=? and b.stat_date=? order by a.target_id desc");

        ps.setObject(1, "'ae_byr'");
        ps.setObject(2, "2013-12-11");
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:39，代码来源:InsightLifeSample.java

示例4: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
    TDataSource ds = new TDataSource();

    // init a datasource with local config file
    ds.setAppName("eagleeye_mptest");
    // ds.setRuleFile("eagleeye_rule.xml");
    ds.getConnectionProperties().put(ConnectionProperties.CONCURRENT_THREAD_SIZE, 10);
    ds.getConnectionProperties().put(ConnectionProperties.MERGE_CONCURRENT, true);
    ds.init();
    System.out.println("init done");
    testClient(ds);
}
开发者ID:loye168，项目名称:tddl5，代码行数:13，代码来源:EagleEyeMptestSample.java

示例5: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException, FileNotFoundException {
    Log4jConfigurer.initLogging("src/main/resources/log4j.properties");

    TDataSource ds = new TDataSource();

    // 设置默认db(ob)
    ds.setAppName("DEV_DPS_APP");
    ds.setTopologyFile("tddl-topology-dps.xml");
    ds.setRuleFile("tddl-rule-dps-nonmysql.xml");

    // 设置simba2的mysql
    App subApp = new App();
    subApp.setAppName("DAILY_SOLAR_MERCURY_APP");
    subApp.setRuleFile("tddl-rule-dps-simba2-mysql.xml");
    ds.addSubApp(subApp);

    // 添加subway的mysql
    subApp = new App();
    subApp.setAppName("DEV_SUBWAY_MYSQL");
    subApp.setRuleFile("tddl-rule-dps-subway-mysql.xml");
    ds.addSubApp(subApp);

    Map cp = new HashMap();
    cp.put("ALLOW_TEMPORARY_TABLE", "True");
    cp.put(ConnectionProperties.TEMP_TABLE_DIR, ".\\temp\\");
    cp.put(ConnectionProperties.TEMP_TABLE_CUT_ROWS, false);
    cp.put(ConnectionProperties.TEMP_TABLE_MAX_ROWS, 1000);
    ds.setConnectionProperties(cp);

    ds.init();
    System.out.println("init done");

    // subway_adgroup_list.sql
    // solar_adgroup_list.sql
    String sql = SqlFileUtil.getSql("replace.txt");
    // sql = SqlFileUtil.getSql("solar_adgroup_list.sql");
    Connection conn = ds.getConnection();
    {
        PreparedStatement ps = conn.prepareStatement(sql);
        long start = System.currentTimeMillis();
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }
        System.out.println("done " + (System.currentTimeMillis() - start));
        rs.close();
        ps.close();
    }

    conn.close();
}
开发者ID:loye168，项目名称:tddl5，代码行数:60，代码来源:Simba2Sample.java

示例6: loadSchema

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
private synchronized void loadSchema(final String app) {
    SchemaConfig schema = schemas.get(app);
    if (schema != null) {
        return;
    }

    // MDC.put("app", app);
    TDataSource ds = new TDataSource();
    ds.putConnectionProperties(ConnectionProperties.CHOOSE_STREAMING, true);
    ds.putConnectionProperties(ConnectionProperties.PROCESS_AUTO_INCREMENT_BY_SEQUENCE, true);
    ds.putConnectionProperties(ConnectionProperties.INIT_CONCURRENT_POOL_EVERY_CONNECTION, false);
    // 共享一个链接池
    ds.setGlobalExecutorService(CobarServer.getInstance().getServerExectuor());
    // ds.putConnectionProperties(ConnectionProperties.MERGE_CONCURRENT,
    // true);
    // ds.putConnectionProperties(ConnectionProperties.CONCURRENT_THREAD_SIZE,
    // CobarServer.getInstance()
    // .getConfig()
    // .getSystem()
    // .getServerExecutor());
    ds.setSharding(false);// 允许非sharding启动
    ds.setAppName(app);
    // try {
    // ds.init();
    // } catch (TddlException e) {
    // // 启动时出错不往上抛
    // logger.error(e);
    // } finally {
    // MDC.remove("app");
    // }
    schema = new SchemaConfig(app);
    schema.setDataSource(ds);
    schemas.put(app, schema);
}
开发者ID:loye168，项目名称:tddl5，代码行数:35，代码来源:AppLoader.java

示例7: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
    TDataSource dataSource = new TDataSource();
    dataSource.setAppName("corona_perf_qatest");
    dataSource.init();

    selectMutilStable(dataSource);
}
开发者ID:beebeandwer，项目名称:TDDL，代码行数:8，代码来源:PerfTest.java

示例8: JDBCClient

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void JDBCClient(String dbTypeStack, boolean async) throws Exception {
    us = new TDataSource();
    // if ("tddl".equalsIgnoreCase(dbTypeStack) ||
    // "mysql".equalsIgnoreCase(dbTypeStack)) {
    us.setAppName("andor_mysql_qatest");
    // } else if ("tdhs".equalsIgnoreCase(dbTypeStack)) {
    // us.setAppName("andor_tdhs_qatest");
    // } else if ("hbase".equalsIgnoreCase(dbTypeStack)) {
    // us.setAppName("andor_hbase_qatest");
    // }

    us.setRuleFile(ruleFile + dbTypeStack + "_" + rule);

    if ((!"tddl".equalsIgnoreCase(dbTypeStack)) && (!"tdhs".equalsIgnoreCase(dbTypeStack))) {
        us.setTopologyFile(machineTapologyFile);
        us.setSchemaFile(schemaFile + dbTypeStack + "_" + schema);
    }

    Map<String, Object> cp = new HashMap<String, Object>();
    if ("tdhs".equalsIgnoreCase(dbTypeStack)) {
        cp.put(ExtraCmd.USE_TDHS_FOR_DEFAULT, "true");
    }

    if ("hbase".equalsIgnoreCase(dbTypeStack)) {
        cp.put(ExtraCmd.HBASE_MAPPING_FILE, "matrix/hbase_mapping.xml");
    }
    us.setConnectionProperties(cp);
    try {
        us.init();
    } catch (Exception e) {
        Assert.fail(ExceptionUtils.getFullStackTrace(e));
    }
}
开发者ID:beebeandwer，项目名称:TDDL，代码行数:34，代码来源:BaseMatrixTestCase.java

示例9: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
    TDataSource ds = new TDataSource();

    // init a datasource with local config file
    ds.setAppName("eagleeye");
    // ds.setRuleFile("eagleeye_rule.xml");
    ds.getConnectionProperties().put(ConnectionProperties.CONCURRENT_THREAD_SIZE, 10);

    ds.getConnectionProperties().put(ConnectionProperties.MERGE_CONCURRENT, true);

    ds.getConnectionProperties().put(ConnectionProperties.COUNT_OF_KEY_TO_RIGHT_INDEX_NESTED_LOOP, "1");

    ds.getConnectionProperties().put(ConnectionProperties.MAX_INDEX_NESTED_LOOP_ITERATION_TIMES, "10");

    ds.getConnectionProperties().put(ConnectionProperties.INDEX_NESTED_LOOP_TIME_OUT, "10000");
    ds.init();

    System.out.println("init done");

    testTraceId(ds);
}
开发者ID:loye168，项目名称:tddl5，代码行数:22，代码来源:EagleEyeSample.java

示例10: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("ACSS_BILL_APP");

        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // insert a record
        // conn.prepareStatement("replace into sample_table (id,name,address) values (1,'sun','hz')").executeUpdate();

        // System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement(" select * from bill_detail BILL_DETAIL limit 100,200");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:42，代码来源:SimashaonianSample.java

示例11: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("CREDITCTRL_APP");

        Map cp = new HashMap();
        // cp.put(ConnectionProperties.MERGE_CONCURRENT, "false");

        ds.setConnectionProperties(cp);
        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement("SELECT * from SYS_LOG");
        // PreparedStatement ps =
        // conn.prepareStatement("SELECT device_id from bullet_dt_device_content  limit 10");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:45，代码来源:MingyaSample.java

示例12: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with local config file
        ds.setAppName("tddl5_sample");
        ds.setRuleFile("classpath:sample_rule.xml");
        ds.setTopologyFile("sample_topology.xml");
        ds.setSchemaFile("test_schema.xml");
        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // insert a record
        conn.prepareStatement("replace into sample_table (id,name,address) values (1,'sun','hz')").executeUpdate();

        System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement("SELECT * from sample_table");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");
    }
开发者ID:loye168，项目名称:tddl5，代码行数:43，代码来源:LocalConfigSample.java

示例13: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("tddl5_sample");

        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // insert a record
        conn.prepareStatement("replace into sample_table (id,name,address) values (1,'sun','hz')").executeUpdate();

        System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement("/*+TDDL({\"type\":\"direct\",\"realtabs\":[traa],\"dbid\":\"tddl5_sample_group\",\"vtab\":\"sample_table\"})*/ SELECT * from sample_table");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:42，代码来源:YuxiaoSample.java

示例14: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with local config file
        ds.setAppName("tddl5_sample");
        ds.setRuleFile("classpath:sample_rule.xml");
        ds.setTopologyFile("sample_topology.xml");
        ds.setSchemaFile("demo_repo_schema.xml");
        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        // insert a record
        conn.prepareStatement("replace into _tddl_ (id,name) values (1,'sun1')").executeUpdate();
        conn.prepareStatement("replace into _tddl_ (id,name) values (2,'sun1')").executeUpdate();

        conn.prepareStatement("replace into _tddl_ (id,name) values (3,'sun1')").executeUpdate();

        conn.prepareStatement("replace into _tddl_ (id,name) values (4,'sun2')").executeUpdate();

        conn.prepareStatement("replace into _tddl_ (id,name) values (5,'sun2')").executeUpdate();

        System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement("SELECT id from _tddl_ order by id");
        // PreparedStatement ps =
        // conn.prepareStatement("SELECT * from _tddl_ t1 join _tddl_ t2 where t1.name=t2.name and t2.name='sun1' and t1.id=1");

        // PreparedStatement ps =
        // conn.prepareStatement("SELECT * from _tddl_ t1 where name='sun'");

        // PreparedStatement ps =
        // conn.prepareStatement("SELECT count(*)+1 from _tddl_ t1 where t1.id=1");
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");
    }
开发者ID:loye168，项目名称:tddl5，代码行数:57，代码来源:DemoRepoSample.java

示例15: main

import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {

        TDataSource ds = new TDataSource();

        // init a datasource with dynamic config on diamond
        ds.setAppName("BULLET_APP");
        ds.setRuleFile("xuezhu.xml");

        ds.init();

        System.out.println("init done");

        Connection conn = ds.getConnection();

        System.out.println("insert done");

        // select all records
        PreparedStatement ps = conn.prepareStatement("SELECT sum(TO_SECONDS(end_time)-TO_SECONDS(start_time)) as totalTime from bullet_dt_device_content where device_id>0 LIMIT 10");
        // PreparedStatement ps =
        // conn.prepareStatement("SELECT device_id from bullet_dt_device_content  limit 10");

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder sb = new StringBuilder();
            int count = rs.getMetaData().getColumnCount();
            for (int i = 1; i <= count; i++) {

                String key = rs.getMetaData().getColumnLabel(i);
                Object val = rs.getObject(i);
                sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
            }
            System.out.println(sb.toString());
        }

        rs.close();
        ps.close();
        conn.close();

        System.out.println("query done");

    }
开发者ID:loye168，项目名称:tddl5，代码行数:42，代码来源:XuezhuSample.java


注：本文中的com.taobao.tddl.matrix.jdbc.TDataSource.setAppName方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。