[ 
https://issues.apache.org/jira/browse/FLINK-6281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119810#comment-16119810
 ] 

ASF GitHub Bot commented on FLINK-6281:
---------------------------------------

Github user fhueske commented on a diff in the pull request:

    https://github.com/apache/flink/pull/3712#discussion_r132146531
  
    --- Diff: 
flink-connectors/flink-jdbc/src/main/java/org/apache/flink/api/java/io/jdbc/JDBCAppendTableSinkBuilder.java
 ---
    @@ -0,0 +1,97 @@
    +/*
    + * Licensed to the Apache Software Foundation (ASF) under one
    + * or more contributor license agreements.  See the NOTICE file
    + * distributed with this work for additional information
    + * regarding copyright ownership.  The ASF licenses this file
    + * to you under the Apache License, Version 2.0 (the
    + * "License"); you may not use this file except in compliance
    + * with the License.  You may obtain a copy of the License at
    + *
    + *     http://www.apache.org/licenses/LICENSE-2.0
    + *
    + * Unless required by applicable law or agreed to in writing, software
    + * distributed under the License is distributed on an "AS IS" BASIS,
    + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    + * See the License for the specific language governing permissions and
    + * limitations under the License.
    + */
    +
    +package org.apache.flink.api.java.io.jdbc;
    +
    +import org.apache.flink.api.common.typeinfo.TypeInformation;
    +import org.apache.flink.util.Preconditions;
    +
    +import static 
org.apache.flink.api.java.io.jdbc.JDBCOutputFormat.DEFAULT_BATCH_INTERVAL;
    +
    +/**
    + * A builder to configure and build the JDBCAppendTableSink.
    + */
    +public class JDBCAppendTableSinkBuilder {
    +   private String username;
    +   private String password;
    +   private String driverName;
    +   private String dbURL;
    +   private String query;
    +   private int batchSize = DEFAULT_BATCH_INTERVAL;
    +   private TypeInformation<?>[] fieldTypes;
    +
    +   public JDBCAppendTableSinkBuilder setUsername(String username) {
    +           this.username = username;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setPassword(String password) {
    +           this.password = password;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setDrivername(String drivername) {
    +           this.driverName = drivername;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setDBUrl(String dbURL) {
    +           this.dbURL = dbURL;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setQuery(String query) {
    +           this.query = query;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setBatchSize(int batchSize) {
    +           this.batchSize = batchSize;
    +           return this;
    +   }
    +
    +   public JDBCAppendTableSinkBuilder setFieldTypes(TypeInformation<?>... 
fieldTypes) {
    +           this.fieldTypes = fieldTypes;
    +           return this;
    +   }
    +
    +   /**
    +    * Finalizes the configuration and checks validity.
    +    *
    +    * @return Configured JDBCOutputFormat
    +    */
    +   public JDBCAppendTableSink build() {
    +           Preconditions.checkNotNull(fieldTypes, "Row type is 
unspecified");
    --- End diff --
    
    change error message to `"Types of the query parameters are not specified. 
Please specify types using the setFieldTypes() method."` (or 
`setParameterTypes()` if we rename the method).`


> Create TableSink for JDBC
> -------------------------
>
>                 Key: FLINK-6281
>                 URL: https://issues.apache.org/jira/browse/FLINK-6281
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table API & SQL
>            Reporter: Haohui Mai
>            Assignee: Haohui Mai
>
> It would be nice to integrate the table APIs with the JDBC connectors so that 
> the rows in the tables can be directly pushed into JDBC.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to