[
https://issues.apache.org/jira/browse/APEXMALHAR-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15213878#comment-15213878
]
ASF GitHub Bot commented on APEXMALHAR-1953:
--------------------------------------------
Github user sandeepdeshmukh commented on a diff in the pull request:
https://github.com/apache/incubator-apex-malhar/pull/215#discussion_r57548724
--- Diff:
library/src/main/java/com/datatorrent/lib/db/jdbc/JdbcPOJOInsertOutputOperator.java
---
@@ -0,0 +1,182 @@
+/**
+ * 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 com.datatorrent.lib.db.jdbc;
+
+import java.lang.reflect.Field;
+import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.List;
+
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import com.google.common.collect.Lists;
+
+import com.datatorrent.api.Context.OperatorContext;
+import com.datatorrent.lib.util.FieldInfo;
+
+/**
+ * <p>
+ * JdbcPOJOInsertOutputOperator class.</p>
+ * An implementation of AbstractJdbcTransactionableOutputOperator which
takes in any POJO.
+ *
+ * @displayName Jdbc Output Operator
+ * @category Output
+ * @tags database, sql, pojo, jdbc
+ * @since 2.1.0
+ */
[email protected]
+public class JdbcPOJOInsertOutputOperator extends
AbstractJdbcPOJOOutputOperator
+{
+ String insertStatement;
+ List<String> columnNames;
+ List<Integer> columnNullabilities;
+ String columnString;
+ String valueString;
+
+ @Override
+ public void setup(OperatorContext context)
+ {
+ super.setup(context);
+
+ // Populate columnNames and columnDataTypes
+ try {
+ if (getFieldInfos() == null) { // then assume direct mapping
+ LOG.info("Assuming direct mapping between POJO fields and DB
columns");
+ populateColumnDataTypes(null);
+ } else {
+ // FieldInfo supplied by user
+ StringBuilder columns = new StringBuilder();
+ StringBuilder values = new StringBuilder();
+ for (int i = 0; i < getFieldInfos().size(); i++) {
+ columns.append(getFieldInfos().get(i).getColumnName());
+ values.append("?");
+ if (i < getFieldInfos().size() - 1) {
+ columns.append(",");
+ values.append(",");
+ }
+ }
+ populateColumnDataTypes(columns.toString());
+ }
+ } catch (SQLException e) {
+ throw new RuntimeException(e);
+ }
+ }
+
+ @Override
+ public void activate(OperatorContext context)
+ {
+ if (getFieldInfos() == null) {
+ Field[] fields = pojoClass.getDeclaredFields();
+ // Create fieldInfos in case of direct mapping
+ List<JdbcFieldInfo> fieldInfos = Lists.newArrayList();
+ for (int i = 0; i < columnNames.size(); i++) {
+ String columnName = columnNames.get(i);
+ String pojoField = getMatchingField(fields, columnName);
+
+ if (columnNullabilities.get(i) == ResultSetMetaData.columnNoNulls
&&
+ (pojoField == null || pojoField.length() == 0)) {
+ throw new RuntimeException("Data for a non-nullable field not
found in POJO");
--- End diff --
Add field name in the message.
> Add generic (insert, update, delete) support to JDBC Output Operator
> --------------------------------------------------------------------
>
> Key: APEXMALHAR-1953
> URL: https://issues.apache.org/jira/browse/APEXMALHAR-1953
> Project: Apache Apex Malhar
> Issue Type: Task
> Reporter: Bhupesh Chawda
> Assignee: Bhupesh Chawda
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
