Page History

SET 'sql-gateway.table-dynamic-option-provider-factory'='jdbc-security-provider'; // Set the jdbc security provider for Sql-Gateway

CREATE TABLE my_jdbc_table (
    val1 INT,
    val2 INT)
  WITH (
    'connector' = 'jdbc',
    'url' = 'jdbc:mysql://localhost:3306/test',
    'table-name' = 'mysql_table'
    //'username' = '****'    We don't need to provide username and password infor jobsjob here
    //'password' = '****'
  );

INSERT INTO my_jdbc_table SELECT ... FROM ... GROUP BY ...;