在trafodion数据库查询mysql数据库的表和oracle的表

1. 配置说明：

select ... from udf(JDBC(      <name of JDBC driver jar>,                ----JDBC驱动jar包      <name of JDBC driver class in the jar>,   ----类名      <connection string>,                      ----连接串      <user name>,                              ----数据库用户名      <password>,                               ----密码      <statement_type>,                         ----source      <sql statement 1>                         ----sql语句      [ , <sql statements 2 ...n> ] )) ...

2. 配置在trafodion中查询mysql数据库的表

select *from udf(jdbc('mysql-connector-java-5.1.44-bin.jar','com.mysql.jdbc.Driver','jdbc:mysql://192.168.1.6:3636/TEST_ESGYN','root','123456','source','select count(*) from test_table'));

3. 配置trafodion中查询oracle的表

select *from udf(jdbc('ojdbc6.jar',              'oracle.jdbc.driver.OracleDriver',              'jdbc:oracle:thin:@192.168.1.6:1521:esgyn',              'sys',              '123456',              'source',              'select * from dual'));