[GitHub] incubator-trafodion pull request #1344: TRAFODION-2844 add strategy to dcsse...

[hegdean]

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


https://github.com/apache/incubator-trafodion/pull/1344#discussion_r157074271
  
--- Diff: dcs/src/main/java/org/trafodion/dcs/server/ServerManager.java ---
@@ -255,33 +259,17 @@ private void cleanupZk() {
 CountDownLatch startSignal = new CountDownLatch(1);
 RetryCounter retryCounter;
 
-public void reset() {
-startSignal.countDown();
-startSignal = new CountDownLatch(1);
-boolean isRunning = this.serverMonitor.monitor();
-String nid = this.serverMonitor.nid;
-String pid = this.serverMonitor.pid;
-
-if (isRunning) {
-LOG.info("mxosrvr " + nid + "," + pid + " still running");
-this.retryCounter.resetAttemptTimes();
-} else {
-LOG.info("mxosrvr " + nid + "," + pid + " exited, 
restarting, restart attempt time : "
-+ this.retryCounter.getAttemptTimes());
-}
-}
-
 public ServerHandler(Configuration conf ,int childInstance) {
 int maxRestartAttempts = 
conf.getInt(Constants.DCS_SERVER_USER_PROGRAM_RESTART_HANDLER_ATTEMPTS,
 
Constants.DEFAULT_DCS_SERVER_USER_PROGRAM_RESTART_HANDLER_ATTEMPTS);
-int retryIntervalMillis = conf.getInt(
-
Constants.DCS_SERVER_USER_PROGRAM_RESTART_HANDLER_RETRY_INTERVAL_MILLIS,
-
Constants.DEFAULT_DCS_SERVER_USER_PROGRAM_RESTART_HANDLER_RETRY_INTERVAL_MILLIS);
+int retryIntervalMinutes = conf.getInt(
--- End diff --

Why did we change from millis to minutes. Millis is more granular and you 
can achieve mins from millis


---

[GitHub] incubator-trafodion pull request #972: here is the change on pom.xml used to...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/972#discussion_r102244502
  
--- Diff: core/conn/jdbcT4/pom.xml ---
@@ -27,11 +27,34 @@
 -->
 
   4.0.0
-  org.trafodion.jdbc.t4
-  jdbcT4
+  
+org.apache.trafodion
--- End diff --

This may not work as the package names does not contain apache in them. 
First we will need to make the package name change for T4


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #851: TRAFODION-2357 log4c++ build error

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/851

TRAFODION-2357 log4c++ build error

Fix for jdbcT4 build errors. 
Eliminates  git dependency when building from src package

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/851.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #851


commit c0892c320c7153566a9262d97a0d556506613ff0
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-11-23T06:25:06Z

Eliminating use of git command in pom.xml

commit 6723aeab384b92e0752dfd8425c88d9d3ae80c69
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-11-23T06:35:52Z

cleanup




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #785: [TRAFODION-2307] Documentation update...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/785

[TRAFODION-2307] Documentation update for REST and DCS [TRAFODION-2230] 
Reduce number of invocation for jps during dcscheck/sqcheck

Other minor fixes

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/785.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #785


commit 2f34aa7d458a0e370571e5859d42e58618c75c23
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-03T16:33:48Z

Reduce the usage of jps in dcscheck script
some minor fixes

commit c3c47361ea50c2667283a4d433bf0adb82cc475e
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-03T16:34:42Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 1605595e6da911c379698a0b8ef8e1b79a2437cc
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-06T19:08:03Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit d457ac0fb5b3d11e217959e0a6708f592b526881
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-19T21:17:10Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 449f48ae3935d87f1523af74613dff683e55be09
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-24T18:15:55Z

Documenation update for DCS and REST server
Minor fixes in scripts

commit f5179a182b2029879a3110c2b71b7b5093c5d2d9
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-24T18:33:44Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit f7f1ee957ae07bd2cfbd38d6984876bbdedd6fed
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-25T20:16:48Z

Updates to documentation

commit adaa03a7b2bac5f773d80b0cef2bdf23690d7d52
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-10-25T20:17:09Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #763: [TRAFODION-1893]ODBC:Remove vcredist ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/763#discussion_r83725920
  
--- Diff: win-odbc64/Install/win64_installer/installer.iss ---
@@ -152,6 +141,40 @@ begin
   Result := (GetUninstallString() <> '');
 end;
 
+procedure CurStepChanged(CurStep: TSetupStep);
+var
+  bRedistNeedsInstall: Boolean;
+  sDefaultBrowserName: String;
+  sDefaultBrowserReg: String;
+  sDefaultBrowserValue: String;
+  iQuotePos: Integer;
+  lLength: Longint;
+  iRetCode: Integer;
+begin
+  if CurStep=ssPostInstall then
+  begin
+bRedistNeedsInstall := VCRedistNeedsInstall();
+if bRedistNeedsInstall=True then
+begin
+  MsgBox('Install of Visual C++ Redistributable Packages for Visual 
Studio 2013 is not dectected.'+ #13#10#13#10 + 'Please download 
vcredist_x64.exe from Microsoft Download Centre and install it.', 
mbInformation, MB_OK);
--- End diff --

Can we change the message to be as follows:
Run-time dependency needed by the driver is not found. Proceeding to 
download and install run-time dependency from Microsoft.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #613: [TRAFODION-2122] daily build master e...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/613

[TRAFODION-2122] daily build master executor logs contain   update 
statement exception



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/613.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #613


commit 9f6edc66e3ee2aafea736ee409699791b87fdd37
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-07-21T18:19:14Z

[TRAFODION-2122] daily build master executor logs contain update statement 
exception

Fixed the extra newline from sqcheck




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #546: TRAFODION [109] Instrument Trafodion ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/546#discussion_r68082081
  
--- Diff: install/installer/traf_secure_setup ---
@@ -0,0 +1,342 @@
+#!/bin/bash
+
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+# KDC attributes
+MAX_LIFETIME="24hours"
+RENEW_LIFETIME="7days"
+
+# LDAP attributes
+LDAP_AUTH_FILE="traf_authentication_config_${HOSTNAME}"
+
+HOST_NAME=`hostname -f`
+
+# These differ depending on the distribution
+if [[ $HADOOP_TYPE == "cloudera" ]]; then
+  TRAF_KEYTAB_DIR='/etc/trafodion'
+  TRAF_KEYTAB="trafodion.keytab"
+  HBASE_KEYTAB=`sudo find /var/run/cloudera-scm-agent/process/ -name 
hbase.keytab | grep 'hbase-MASTER' | head -n 1`
+  HDFS_KEYTAB=`sudo find /var/run/cloudera-scm-agent/process/ -name 
hdfs.keytab | grep 'hdfs-NAMENODE/' | head -n 1`
+else
+  TRAF_KEYTAB_DIR='/etc/security/keytabs'
+  TRAF_KEYTAB="trafodion.service.keytab"
+  HBASE_KEYTAB='/etc/security/keytabs/hbase.service.keytab'
+  HDFS_KEYTAB='/etc/security/keytabs/hdfs.headless.keytab'
+fi
+
+#==
+#  Setup Trafodion environment for secure Hadoop
+#==
+
+LOCAL_WORKDIR="$( cd "$( dirname "$0" )" && pwd )"
+
+TRAF_CONFIG="/etc/trafodion/trafodion_config"
+LOCAL_SECURE_CONFIG="$LOCAL_WORKDIR/trafodion_secure_config"
+rm $LOCAL_SECURE_CONFIG  2>/dev/null
+
+
+#==
+# Kerberos enabled
+
+echo "***INFO: Starting Trafodion security configuration setup"
+
+# Check to see if kerberos is enabled in Hadoop
+cat /etc/hadoop/conf/core-site.xml | while read a; do
--- End diff --

Use HADOOP_CNF_DIR environment variable


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #522: [TRAFODION-2024] Openssl libraries (s...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/522

[TRAFODION-2024] Openssl libraries (ssl & crypto) should be dynamically 
linked not static



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion ahbrnch-2.0

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/522.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #522


commit f7c2c1e08895c3ad960626a1eb46f5cf2061a4d5
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-06-04T13:32:28Z

Openssl libraries (ssl & crypto) are linked dynamically




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #521: [TRAFODION-2024] Openssl libraries (s...

[hegdean]

Github user hegdean closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/521


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request #521: [TRAFODION-2024] Openssl libraries (s...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/521

[TRAFODION-2024] Openssl libraries (ssl & crypto) should be dynamically 
linked not static



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion ahbrnch-2.0

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/521.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #521


commit a45063a45082674224c074199d23838f96b0a40b
Author: Steve Varnau <steve.var...@esgyn.com>
Date:   2016-06-01T21:43:38Z

[TRAFODION-2023] Clarify license text

Fix issues found in review of release 2.0.0.

Clarify that BSD-4 license has a rescinded clause.

Remove the GPL text of two packages that have dual license, since we are
not redistributing under GPL.

commit 0a8507aaf680216f09340110fae857b402f303ce
Author: Steve Varnau <steve.var...@esgyn.com>
Date:   2016-06-01T21:51:07Z

Clarify how to run RAT, per comments from release 2.0.0 review.

commit 4c49f6f69ff1b10a70134bd25301447fc5a7c0d9
Author: Dave Birdsall <dbirds...@apache.org>
Date:   2016-06-02T18:20:33Z

Merge [TRAFODION-2023] PR 515 Clarify license text

commit 9712b3fe70471ac74065165588031ee07ede06e0
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-06-04T02:45:11Z

Openssl libraries (ssl & crypto) are dynamically linked for
linux odbc driver




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFDOION-1664] Trafci install ...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/504

[TRAFDOION-1664] Trafci install wizard legal disclaimer needs updating

[TRAFODION-1984] Installer packaging is not included in main package build 
target
[TRAFODION-1479] sqcheck should display the status of the rest server
 Additional fixes: 
  Resolved the partially installled Linux ODBC driver along with Trafodion 
server
  sqvers -u will not display the database edition for jar files
  Eliminated the redundant use of 'jps' in sqcheck and dcscheck scripts

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch-2.1

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/504.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #504


commit 8ac0b9f360db9b65bee08af1a963527b79524685
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-17T16:28:01Z

sqcheck now displays RESTServer status along with other components

commit 4ac9c9a84be1caaeaecf632ab4cdc3de7c0ab310
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-17T18:23:29Z

Updated jar files to display the database edition so 'sqvers -u'
output is displayed correctly

commit 6c7cac6c1a6d99f4c09ffaaa0bbd773133792c24
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-17T19:48:57Z

Modified servername in TRAFDSN to use localhost instead of dummy hostname

commit 908e2422c56f6fd1aba46dd53b00dcf265cf3af4
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-19T23:55:19Z

Installing odbc linux driver along with server component

commit ccb6a7ef8a324e7efca2025cf2824adbd78af7c9
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-20T05:09:03Z

Added copyright header

commit 92aaccd2e1fdc15f7e2d109ee2a152bfa834c3ca
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-20T16:14:27Z

Fixed the clean target

commit 9623bf179cfee064deda6af60a17cb907b9ab4d4
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-24T05:44:10Z

Linux odbc driver will now be installed along with Server component
Installer tar is packaged and distributed with 'make pacakge-all'
Fixed minor issues

commit 9fb1bdde5007b2e38198cc1139742798af78936b
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-24T15:45:29Z

Merge branch 'master' into wrkbrnch-2.1

commit b8df0e25cf4b6d9ac29cb84c3798d09bb4b98aa9
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-24T17:15:37Z

Changed installer tar file name

commit 0365574a3a6648f06ecfe043e0856d28b6e80376
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-24T17:52:07Z

Updated the legal disclaimer in install wizard

commit 30093ab44c35df3cde2825162cde2c7c431b798a
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-24T23:43:27Z

Fixed the dependency for installer package

commit a5b4b9631478acec7a1b6ea10752e5051db399e6
Author: Anuradha Hegde <hegdean@edev05.esgyn.local>
Date:   2016-05-25T23:34:48Z

eliminated the redundant jps command from the check scripts

commit a2bd4ac12834931d7bb2dfce662c47e2d99cd6a6
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-05-26T18:50:24Z

Merge remote branch 'origin/master' into wrkbrnch-2.1

Conflicts:
licenses/Makefile




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1982] Package server ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/476#discussion_r62778376
  
--- Diff: core/conn/Makefile ---
@@ -25,16 +25,17 @@ include ../macros.gmk #top level
 
 RM  = /bin/rm
 ifeq ($(SQ_BUILD_TYPE),release)
-  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/trafodion_clients-$(TRAFODION_VER).tgz
+  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/apache-trafodion_clients-$(TRAFODION_VER)-incubating.tar.gz
 else
-  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/trafodion_clients-$(TRAFODION_VER)-debug.tgz
+  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/apache-trafodion_clients-$(TRAFODION_VER)-debug.tar.gz
--- End diff --

can we use TRAFODION_VER_PROD


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1982] Package server ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/476#discussion_r62778320
  
--- Diff: core/conn/Makefile ---
@@ -25,16 +25,17 @@ include ../macros.gmk #top level
 
 RM  = /bin/rm
 ifeq ($(SQ_BUILD_TYPE),release)
-  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/trafodion_clients-$(TRAFODION_VER).tgz
+  CLIENT_TAR   ?= 
../../${DISTRIBUTION_DIR}/apache-trafodion_clients-$(TRAFODION_VER)-incubating.tar.gz
--- End diff --

Instead of hard coding(apache_trafodion) can we use the environment 
variable TRAFODION_VER_PROD


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1954] Enhance VERSION...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/474

[TRAFODION-1954] Enhance VERSION command in trafci

Changed the format of REST server logs to match that of DCS logs

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/474.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #474


commit 9fa9b61136bf2bed3ef18e91c12257c936da7105
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-05-03T16:32:01Z

Support in sqludflog reader to read REST server logs

commit 3a6a615582bf80050c69e9a573b75afb64077ca1
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-05-06T19:02:02Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit e4791e72b47b1ac15af223c4832064155db009b0
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-05-09T16:57:42Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 2e6e3545ac07da908a0ce456454660507ba24712
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-05-09T20:20:00Z

version command now displays information from the server




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675683
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/tracing_logging.adoc 
---
@@ -0,0 +1,195 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[tracing-and-logging-facilities]]
+= Tracing and Logging Facilities
+
+The Type 4 driver provides two tracing and logging facilities:
+
+* Standard JDBC tracing and logging functionality as defined by the JDBC 
standard
+* Type 4 driver logging facility
+
+Server-side tracing (logging) is enabled by configuring DCS.
+
+[[standard-jdbc-tracing-and-logging-facility]]
+== Standard JDBC Tracing and Logging Facility
+
+The JDBC standard provides a logging and tracing facility, which allows
+tracing JDBC method calls by setting the log writer. To set the log
+writer, either call the `setLogWriter()` method on the `DriverManager` 
class
+or call the `setLogWriter()` method on the `DataSource` class
+(or `ConnectionPoolDataSource` class).
+
+* A `DriverManager` log writer is a character output stream to which all
+logging and tracing messages for all connections made through the
+`DriverManager` are printed. This stream includes messages printed by the
+methods of this connection, messages printed by methods of other objects
+manufactured by the connection, and so on. The `DriverManager` log writer
+is initially null, that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html[DriverManager
 class API].
+
+* A `DataSource` log writer is a character output stream to which all
+logging and tracing messages for this data source are printed. This
+stream includes messages printed by the methods of this object, messages
+printed by methods of other objects manufactured by this object, and so
+on. Messages printed to a data-source-specific log writer are not
+printed to the log writer associated with the `java.sql.DriverManager`
+class. When a `DataSource` object is created, the log writer is initially
+null; that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/jdbc/pool/OracleDataSource.html[DriverSource
 interface API].
+
+<<<
+[[the-type-4-driver-logging-facility]]
+== The Type 4 Driver Logging Facility
+
+
+The Type 4 driver Logging facility allows you to retrieve internal
+tracing information, which you can use in debugging the driver. It also
+allows you to capture error and warning messages.
+
+In addition to the standard JDBC tracing and logging facility, the Type
+4 driver provides an independent logging facility (Type 4 Driver
+Logging). The Type 4 Driver Logging provides the same level of logging
+and tracing as the standard JDBC tracing and logging facility with the
+following additional information:
+
+* More detail about the internals of the Type 4 driver and internal 
tracing information
+* Type 4 driver performance-tuning information
+* Finer control over the amount and type of logging information
+* Error and warning messages
+
+[[accessing-the-type-4-driver-logging-facility]]
+=== Accessing the Type 4 Driver Logging Facility
--- End diff --

Remove this section "Accessing the Type4 Driver Logging Facility"


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675650
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/tracing_logging.adoc 
---
@@ -0,0 +1,195 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[tracing-and-logging-facilities]]
+= Tracing and Logging Facilities
+
+The Type 4 driver provides two tracing and logging facilities:
+
+* Standard JDBC tracing and logging functionality as defined by the JDBC 
standard
+* Type 4 driver logging facility
+
+Server-side tracing (logging) is enabled by configuring DCS.
+
+[[standard-jdbc-tracing-and-logging-facility]]
+== Standard JDBC Tracing and Logging Facility
+
+The JDBC standard provides a logging and tracing facility, which allows
+tracing JDBC method calls by setting the log writer. To set the log
+writer, either call the `setLogWriter()` method on the `DriverManager` 
class
+or call the `setLogWriter()` method on the `DataSource` class
+(or `ConnectionPoolDataSource` class).
+
+* A `DriverManager` log writer is a character output stream to which all
+logging and tracing messages for all connections made through the
+`DriverManager` are printed. This stream includes messages printed by the
+methods of this connection, messages printed by methods of other objects
+manufactured by the connection, and so on. The `DriverManager` log writer
+is initially null, that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html[DriverManager
 class API].
+
+* A `DataSource` log writer is a character output stream to which all
+logging and tracing messages for this data source are printed. This
+stream includes messages printed by the methods of this object, messages
+printed by methods of other objects manufactured by this object, and so
+on. Messages printed to a data-source-specific log writer are not
+printed to the log writer associated with the `java.sql.DriverManager`
+class. When a `DataSource` object is created, the log writer is initially
+null; that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/jdbc/pool/OracleDataSource.html[DriverSource
 interface API].
+
+<<<
+[[the-type-4-driver-logging-facility]]
+== The Type 4 Driver Logging Facility
+
+
+The Type 4 driver Logging facility allows you to retrieve internal
+tracing information, which you can use in debugging the driver. It also
+allows you to capture error and warning messages.
+
+In addition to the standard JDBC tracing and logging facility, the Type
+4 driver provides an independent logging facility (Type 4 Driver
+Logging). The Type 4 Driver Logging provides the same level of logging
+and tracing as the standard JDBC tracing and logging facility with the
+following additional information:
+
+* More detail about the internals of the Type 4 driver and internal 
tracing information
+* Type 4 driver performance-tuning information
+* Finer control over the amount and type of logging information
+* Error and warning messages
+
+[[accessing-the-type-4-driver-logging-facility]]
+=== Accessing the Type 4 Driver Logging Facility
+
+The Type 4 Driver Logging facility is based on the `java.util.logging`
+package. The Type 4 driver instantiates a `java.util.logging.Logger` class
+and names the logger `org.trafodion.jdbc.t4.logger`.
+
+Your JDBC program can access the Type 4 driver logger directly by
+calling the `java.util.logging.Logger` static method `getLogger(String)`.
+
+*example*
+
+[source, java]
 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675642
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/tracing_logging.adoc 
---
@@ -0,0 +1,195 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[tracing-and-logging-facilities]]
+= Tracing and Logging Facilities
+
+The Type 4 driver provides two tracing and logging facilities:
+
+* Standard JDBC tracing and logging functionality as defined by the JDBC 
standard
+* Type 4 driver logging facility
+
+Server-side tracing (logging) is enabled by configuring DCS.
+
+[[standard-jdbc-tracing-and-logging-facility]]
+== Standard JDBC Tracing and Logging Facility
+
+The JDBC standard provides a logging and tracing facility, which allows
+tracing JDBC method calls by setting the log writer. To set the log
+writer, either call the `setLogWriter()` method on the `DriverManager` 
class
+or call the `setLogWriter()` method on the `DataSource` class
+(or `ConnectionPoolDataSource` class).
+
+* A `DriverManager` log writer is a character output stream to which all
+logging and tracing messages for all connections made through the
+`DriverManager` are printed. This stream includes messages printed by the
+methods of this connection, messages printed by methods of other objects
+manufactured by the connection, and so on. The `DriverManager` log writer
+is initially null, that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html[DriverManager
 class API].
+
+* A `DataSource` log writer is a character output stream to which all
+logging and tracing messages for this data source are printed. This
+stream includes messages printed by the methods of this object, messages
+printed by methods of other objects manufactured by this object, and so
+on. Messages printed to a data-source-specific log writer are not
+printed to the log writer associated with the `java.sql.DriverManager`
+class. When a `DataSource` object is created, the log writer is initially
+null; that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/jdbc/pool/OracleDataSource.html[DriverSource
 interface API].
+
+<<<
+[[the-type-4-driver-logging-facility]]
+== The Type 4 Driver Logging Facility
+
+
+The Type 4 driver Logging facility allows you to retrieve internal
+tracing information, which you can use in debugging the driver. It also
+allows you to capture error and warning messages.
+
+In addition to the standard JDBC tracing and logging facility, the Type
+4 driver provides an independent logging facility (Type 4 Driver
+Logging). The Type 4 Driver Logging provides the same level of logging
+and tracing as the standard JDBC tracing and logging facility with the
+following additional information:
+
+* More detail about the internals of the Type 4 driver and internal 
tracing information
+* Type 4 driver performance-tuning information
+* Finer control over the amount and type of logging information
+* Error and warning messages
+
+[[accessing-the-type-4-driver-logging-facility]]
+=== Accessing the Type 4 Driver Logging Facility
+
+The Type 4 Driver Logging facility is based on the `java.util.logging`
+package. The Type 4 driver instantiates a `java.util.logging.Logger` class
+and names the logger `org.trafodion.jdbc.t4.logger`.
+
+Your JDBC program can access the Type 4 driver logger directly by
+calling the `java.util.logging.Logger` static method `getLogger(String)`.
+
+*example*
+
+[source, java]
 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675603
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/tracing_logging.adoc 
---
@@ -0,0 +1,195 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[tracing-and-logging-facilities]]
+= Tracing and Logging Facilities
+
+The Type 4 driver provides two tracing and logging facilities:
+
+* Standard JDBC tracing and logging functionality as defined by the JDBC 
standard
+* Type 4 driver logging facility
+
+Server-side tracing (logging) is enabled by configuring DCS.
+
+[[standard-jdbc-tracing-and-logging-facility]]
+== Standard JDBC Tracing and Logging Facility
+
+The JDBC standard provides a logging and tracing facility, which allows
+tracing JDBC method calls by setting the log writer. To set the log
+writer, either call the `setLogWriter()` method on the `DriverManager` 
class
+or call the `setLogWriter()` method on the `DataSource` class
+(or `ConnectionPoolDataSource` class).
+
+* A `DriverManager` log writer is a character output stream to which all
+logging and tracing messages for all connections made through the
+`DriverManager` are printed. This stream includes messages printed by the
+methods of this connection, messages printed by methods of other objects
+manufactured by the connection, and so on. The `DriverManager` log writer
+is initially null, that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html[DriverManager
 class API].
+
+* A `DataSource` log writer is a character output stream to which all
+logging and tracing messages for this data source are printed. This
+stream includes messages printed by the methods of this object, messages
+printed by methods of other objects manufactured by this object, and so
+on. Messages printed to a data-source-specific log writer are not
+printed to the log writer associated with the `java.sql.DriverManager`
+class. When a `DataSource` object is created, the log writer is initially
+null; that is, the default is for logging to be disabled.
+
+For information about using the setLogWriter method, see the

+https://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/jdbc/pool/OracleDataSource.html[DriverSource
 interface API].
+
+<<<
+[[the-type-4-driver-logging-facility]]
+== The Type 4 Driver Logging Facility
+
+
+The Type 4 driver Logging facility allows you to retrieve internal
+tracing information, which you can use in debugging the driver. It also
+allows you to capture error and warning messages.
+
+In addition to the standard JDBC tracing and logging facility, the Type
+4 driver provides an independent logging facility (Type 4 Driver
+Logging). The Type 4 Driver Logging provides the same level of logging
+and tracing as the standard JDBC tracing and logging facility with the
+following additional information:
+
+* More detail about the internals of the Type 4 driver and internal 
tracing information
+* Type 4 driver performance-tuning information
+* Finer control over the amount and type of logging information
+* Error and warning messages
+
+[[accessing-the-type-4-driver-logging-facility]]
+=== Accessing the Type 4 Driver Logging Facility
+
+The Type 4 Driver Logging facility is based on the `java.util.logging`
+package. The Type 4 driver instantiates a `java.util.logging.Logger` class
+and names the logger `org.trafodion.jdbc.t4.logger`.
+
+Your JDBC program can access the Type 4 driver logger directly by
+calling the `java.util.logging.Logger` static method `getLogger(String)`.
+
+*example*
+
+[source, java]
 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675402
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675360
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675377
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675346
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675332
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61675315
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_overview.adoc ---
@@ -0,0 +1,245 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-properties]]
+= Type 4 Driver Properties
+
+[[summary-of-type-4-driver-properties]]
+== Summary of Type 4 Driver Properties
+
+Type 4 driver properties that effect client-side operations are
+summarized in the following tables. For the detailed description, click
+the link provided in the property name.
+
+NOTE: Unless otherwise noted in the brief description, the particular
+property applies to the `DataSource` object, `DriverManager` object, and
+`ConnectionPoolDataSource` object.
+
+[[client-side-properties]]
+=== Client-Side Properties
+
+*Connection-Control Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<dataSourceName, dataSourceName>>`   | Specifies the registered 
DataSource or ConnectionPoolDataSource name. (Can be set only on the 
DriverManager object.) | None.
+| `<<loginTimeout, loginTimeout>>`   | Sets the time limit that a 
connection can be attempted before the connection disconnects. | 60 (seconds)
+| `<<networkTimeout, networkTimeout>>`   | Sets a time limit that the 
driver waits for a reply from the database server. | 0 (No network timeout is 
specified. 
+|===
+
+*Pooling Management Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<initialPoolSize, initialPoolSize>>` | Sets the initial connection 
pool size when connection pooling is used with the Type 4 driver. (Ignored for
+connections made through the ConnectionPoolDataSource object.) | -1 (Do 
not create an initial connection pool.)
+| `<<maxIdleTime, maxIdleTime>>` | Sets the number of seconds that 
a physical connection can remain unused in the pool before the connection is 
closed. | 0 (Specifies no limit.)
+| `<<maxPoolSize, maxPoolSize>>` | Sets the maximum number of 
physical connections that the pool can contain. | -1 (Disables connection 
pooling.) 
+| `<<maxStatements, maxStatements>>` | Sets the total number of 
PreparedStatement objects that the connection pool should cache. | 0 (Disables 
statement pooling.)
+| `<<minPoolSize, minPoolSize>>` | Limits the number of physical 
connections that can be in the free connection pool. | -1 (The minPoolSize 
value is ignored.)
+|===
+
+
+*Operations on CLOB and BLOB Data*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<blobTableName, blobTableName>>` | Specifies the LOB table for 
using BLOB columns. | None.
+| `<<clobTableName, clobTableName>>` | Specifies the LOB table for 
using CLOB columns. | None.
+| `<<reserveDataLocators,reserveDataLocators>>` | Sets the number of data 
locators to be reserved for a process that stores data in a LOB table. | 100 
+|===
+
+
+<<<
+*Internationalization Properties*
+[cols="25%,55%,30%",options="header" ]
+|===
+| Property Name  | Description | Default Value
+| `<<ISO88591, ISO88591>>`   | Sets character-set mapping that 
corresponds to the ISO88591 character set. | ISO88591_1
+| `<<KANJI, KANJI>>` | Sets character-set mapping that 
corresponds to the KANJI character set. | SJIS (which 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61670108
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_detail.adoc ---
@@ -0,0 +1,959 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-property-descriptions]]
+= Type 4 Driver Property Descriptions
+
+The properties are listed in alphabetic order with their descriptions.
+For the properties summarized in categories, see
+<<summary-of-type-4-driver-properties, Summary of Type 4 Driver 
Properties>>.
+
+
+[[blobtablename]]
+== blobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+[[catalog]]
+== catalog Property
+
+The `catalog` property sets the default catalog used to access SQL objects
+referenced in SQL statements if the SQL objects are not fully qualified.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: String
+
+Default: none
+```
+
+*Example*
+
+Specifying the catalog Seabase:
+
+```
+catalog=Seabase
+```
+
+
+[[clobtablename]]
+== clobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+<<<
+[[connectiontimeout]]
+== connectionTimeout Property
+
+The `connectionTimeout` property sets the number of seconds a connection
+can be idle before the connection is physically closed by DCS.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: int
+
+Units: seconds
+
+Default: -1 (Use the ConnTimeout value set on the server-side data source.)
+
+Range: -1, 0 to 2147483647
+```
+
+* Zero (0) specifies infinity as the timeout value.
+* A non-zero positive value overrides the value set on the
+{project-name}  data source, if allowed by the connectivity settings.
+* A negative value is treated as -1.
+
+*Example*
+
+Consider the following scenario.
+
+Even if a connection is not being used, it takes up resources. The 
application
+abandons connections; that is, the application does not physically close a
+connection after the application finishes using the connection.
+
+However, you can configure the connection to close itself after 300 
seconds by setting
+the `connectionTimeout` property. Then, when a connection is not 
referenced for 300 seconds,
+the connection automatically closes itself.
+
+In this example, the specification to set the `connectionTimeout` property 
is:
+
+```
+connectionTimeout=300
+```
+
+<<<
+[[fetchbuffersize]]
+== fetchBufferSize Property
+
+The `fetchBufferSize` property provides the benefits of bulk fetch.
+
+This property sets the value in kilobytes (KB) of the size of the fetch
+buffer that is used when rows are fetched from a `ResultSet` object after
+a successful `executeQuery()` operation on a statement.
+
+Set this property on a `DriverManager` object. For information about how 
to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: short
+
+Default size: 4
+
+Range: 4 through 32767
+```
+
+* Zero and negative values are treated as default values.
+* The Type 4 driver gu

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61670102
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_detail.adoc ---
@@ -0,0 +1,959 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-property-descriptions]]
+= Type 4 Driver Property Descriptions
+
+The properties are listed in alphabetic order with their descriptions.
+For the properties summarized in categories, see
+<<summary-of-type-4-driver-properties, Summary of Type 4 Driver 
Properties>>.
+
+
+[[blobtablename]]
+== blobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+[[catalog]]
+== catalog Property
+
+The `catalog` property sets the default catalog used to access SQL objects
+referenced in SQL statements if the SQL objects are not fully qualified.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: String
+
+Default: none
+```
+
+*Example*
+
+Specifying the catalog Seabase:
+
+```
+catalog=Seabase
+```
+
+
+[[clobtablename]]
+== clobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+<<<
+[[connectiontimeout]]
+== connectionTimeout Property
+
+The `connectionTimeout` property sets the number of seconds a connection
+can be idle before the connection is physically closed by DCS.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: int
+
+Units: seconds
+
+Default: -1 (Use the ConnTimeout value set on the server-side data source.)
+
+Range: -1, 0 to 2147483647
+```
+
+* Zero (0) specifies infinity as the timeout value.
+* A non-zero positive value overrides the value set on the
+{project-name}  data source, if allowed by the connectivity settings.
+* A negative value is treated as -1.
+
+*Example*
+
+Consider the following scenario.
+
+Even if a connection is not being used, it takes up resources. The 
application
+abandons connections; that is, the application does not physically close a
+connection after the application finishes using the connection.
+
+However, you can configure the connection to close itself after 300 
seconds by setting
+the `connectionTimeout` property. Then, when a connection is not 
referenced for 300 seconds,
+the connection automatically closes itself.
+
+In this example, the specification to set the `connectionTimeout` property 
is:
+
+```
+connectionTimeout=300
+```
+
+<<<
+[[fetchbuffersize]]
+== fetchBufferSize Property
+
+The `fetchBufferSize` property provides the benefits of bulk fetch.
+
+This property sets the value in kilobytes (KB) of the size of the fetch
+buffer that is used when rows are fetched from a `ResultSet` object after
+a successful `executeQuery()` operation on a statement.
+
+Set this property on a `DriverManager` object. For information about how 
to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: short
+
+Default size: 4
+
+Range: 4 through 32767
+```
+
+* Zero and negative values are treated as default values.
+* The Type 4 driver gu

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61670095
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/properties_detail.adoc ---
@@ -0,0 +1,959 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-property-descriptions]]
+= Type 4 Driver Property Descriptions
+
+The properties are listed in alphabetic order with their descriptions.
+For the properties summarized in categories, see
+<<summary-of-type-4-driver-properties, Summary of Type 4 Driver 
Properties>>.
+
+
+[[blobtablename]]
+== blobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+[[catalog]]
+== catalog Property
+
+The `catalog` property sets the default catalog used to access SQL objects
+referenced in SQL statements if the SQL objects are not fully qualified.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: String
+
+Default: none
+```
+
+*Example*
+
+Specifying the catalog Seabase:
+
+```
+catalog=Seabase
+```
+
+
+[[clobtablename]]
+== clobTableName Property
+
+See <<lob-table-name, LOB Table Name Properties>>.
+
+
+<<<
+[[connectiontimeout]]
+== connectionTimeout Property
+
+The `connectionTimeout` property sets the number of seconds a connection
+can be idle before the connection is physically closed by DCS.
+
+Set this property on a `DataSource` object, `ConnectionPoolDataSource`
+object, or `DriverManager` object. For information about how to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: int
+
+Units: seconds
+
+Default: -1 (Use the ConnTimeout value set on the server-side data source.)
+
+Range: -1, 0 to 2147483647
+```
+
+* Zero (0) specifies infinity as the timeout value.
+* A non-zero positive value overrides the value set on the
+{project-name}  data source, if allowed by the connectivity settings.
+* A negative value is treated as -1.
+
+*Example*
+
+Consider the following scenario.
+
+Even if a connection is not being used, it takes up resources. The 
application
+abandons connections; that is, the application does not physically close a
+connection after the application finishes using the connection.
+
+However, you can configure the connection to close itself after 300 
seconds by setting
+the `connectionTimeout` property. Then, when a connection is not 
referenced for 300 seconds,
+the connection automatically closes itself.
+
+In this example, the specification to set the `connectionTimeout` property 
is:
+
+```
+connectionTimeout=300
+```
+
+<<<
+[[fetchbuffersize]]
+== fetchBufferSize Property
+
+The `fetchBufferSize` property provides the benefits of bulk fetch.
+
+This property sets the value in kilobytes (KB) of the size of the fetch
+buffer that is used when rows are fetched from a `ResultSet` object after
+a successful `executeQuery()` operation on a statement.
+
+Set this property on a `DriverManager` object. For information about how 
to set
+properties, see
+<<how-to-specify-jdbc-type-4-properties, How to Specify JDBC Type 4 
Properties>>.
+
+```
+Data type: short
+
+Default size: 4
+
+Range: 4 through 32767
+```
+
+* Zero and negative values are treated as default values.
+* The Type 4 driver gu

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61670015
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/introduction.adoc ---
@@ -0,0 +1,53 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[introduction]]
+= Introduction
+
+This document describes how to use the {project-name} JDBC Type 4
+Driver. This driver provides Java applications running on a foreign
+platform with JDBC access to {project-name} SQL databases on the
+{project-name}.
+
+*Supported Java Releases:* The Type 4 driver requires Java enabled
+platforms that support JDK 1.4.1 or higher.
+
+
+[[type-4-driver-api-package]]
+== Type 4 Driver API Package
+
+The Type 4 driver package, `org.trafodion.t4jdbc`, is shipped with the
+driver software. For class and method descriptions, see the
+_{project-name} JDBC Type 4 Driver API Reference_.
+
+The {project-name} JDBC Type 4 Driver (hereafter, Type 4 driver)
+implements JDBC technology that conforms to the standard JDBC 3.0 Data
+Access API.
+
+To obtain detailed information on the standard JDBC API, download the
+JDBC API documentation: http://docs.oracle.com/en/java/.
--- End diff --

might need to fix the link


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61669998
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/introduction.adoc ---
@@ -0,0 +1,53 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[introduction]]
+= Introduction
+
+This document describes how to use the {project-name} JDBC Type 4
+Driver. This driver provides Java applications running on a foreign
+platform with JDBC access to {project-name} SQL databases on the
+{project-name}.
+
+*Supported Java Releases:* The Type 4 driver requires Java enabled
+platforms that support JDK 1.4.1 or higher.
+
+
+[[type-4-driver-api-package]]
+== Type 4 Driver API Package
+
+The Type 4 driver package, `org.trafodion.t4jdbc`, is shipped with the
--- End diff --

jdbc.t4


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61669988
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/compliance.adoc ---
@@ -0,0 +1,386 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-compliance]]
+= Type 4 Driver Compliance
+
+[[compliance-overview]]
+== Compliance Overview
+
+The Type 4 driver conforms where applicable to the JDBC
+3.0 API specification. However, this driver differs from the JDBC
+standard in some ways. This subsection describes the JDBC methods that
+are not supported, the methods and features that deviate from the
+specification, and features that are {project-name} extensions to the JDBC 
standard.
+JDBC features that conform to the specification are not described in this 
subsection.
+
+In addition, this chapter lists features of {project-name} SQL that are 
not supported by the {project-name} JDBC Type 4 driver, other
+unsupported features, and restrictions.
+
+[[unsupported-features]]
+== Unsupported Features
+
+These methods in the java.sql package throw an SQLException with the
+message `Unsupported feature - `:
+
+[cols="65%,35%", options="header"]
+|===
+| Method   | Comments
+| `CallableStatement.getArray(int parameterIndex)` +
+`CallableStatement.getArray(String parameterName)` +
+`CallableStatement.getBlob(int parameterIndex)` +
+`CallableStatement.getBlob(String parameterName)` +
+`CallableStatement.getClob(int parameterIndex)` +
+`CallableStatement.getClob(String parameterName)` +
+`CallableStatement.getObject(int parameterIndex, Map map)` +
+`CallableStatement.getObject(String parameterName, Map map)` +
+`CallableStatement.getRef(int parameterIndex)` +
+`CallableStatement.getRef(String parameterName)` +
+`CallableStatement.getURL(int parameterIndex)` +
+`CallableStatement.getURL(String parameterName)` +
+`CallableStatement.executeBatch()` | The particular `CallableStatement` 
method is not supported.
+| `Connection.releaseSavepoint(Savepoint savepoint)` +
+`Connection.rollback(Savepoint savepoint)` +
+`Connection.setSavepoint()` +
+`Connection.setSavepoint(String name)` | The particular `Connection` 
methods are not supported.
+| `PreparedStatement.setArray(int parameterIndex, Array x)` +
+`PreparedStatement.setRef(int parameterIndex, Ref x)` +
+`PreparedStatement.setURL(int parameterIndex, URL x)` | The particular 
`PreparedStatement` methods are not supported.
+| `ResultSet.getArray(int columnIndex)` +
+`ResultSet.getArray(String columnName)` +
+`ResultSet.getObject(int columnIndex, Map map)` +
+`ResultSet.getObject(String columnName, Map map)` +
+`ResultSet.getRef(int columnIndex)ResultSet.getRef(String columnName)` +
+`ResultSet.getURL(int columnIndex)` +
+`ResultSet.getURL(String columnName)` +
+`ResultSet.updateArray(int columnIndex)` +
+`ResultSet.updateArray(String columnName)` +
+`ResultSet.updateRef(int columnIndex)` +
+`ResultSet.updateRef(String columnName) | The particular `ResultSet` 
methods are not supported.
+| `Statement.getQueryTimeout()` +
+`Statement.setQueryTimeout()` | The particular `Statement` methods are not 
supported.
+|===
+
+The following methods in the java.sql package throw an SQLException with
+the message `Auto generated keys not supported`:
+
+[cols="65%,35%", options="header" ]
+|===
+| Method   | Comments
+| `Connection.prepareStatement(String sql, int autoGeneratedKeys)` +
+`Connection.prepareStatement(String sql, int[] columnIndexes)` +
+`Connection.prepareStatement(String sql, String[] columnNames)` | 
Automatically generated keys are not supported.
+| `Statement.executeUpdate(String sql, int autoGen

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61669973
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/compliance.adoc ---
@@ -0,0 +1,386 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-compliance]]
+= Type 4 Driver Compliance
+
+[[compliance-overview]]
+== Compliance Overview
+
+The Type 4 driver conforms where applicable to the JDBC
+3.0 API specification. However, this driver differs from the JDBC
+standard in some ways. This subsection describes the JDBC methods that
+are not supported, the methods and features that deviate from the
+specification, and features that are {project-name} extensions to the JDBC 
standard.
+JDBC features that conform to the specification are not described in this 
subsection.
+
+In addition, this chapter lists features of {project-name} SQL that are 
not supported by the {project-name} JDBC Type 4 driver, other
+unsupported features, and restrictions.
+
+[[unsupported-features]]
+== Unsupported Features
+
+These methods in the java.sql package throw an SQLException with the
+message `Unsupported feature - `:
+
+[cols="65%,35%", options="header"]
+|===
+| Method   | Comments
+| `CallableStatement.getArray(int parameterIndex)` +
+`CallableStatement.getArray(String parameterName)` +
+`CallableStatement.getBlob(int parameterIndex)` +
+`CallableStatement.getBlob(String parameterName)` +
+`CallableStatement.getClob(int parameterIndex)` +
+`CallableStatement.getClob(String parameterName)` +
+`CallableStatement.getObject(int parameterIndex, Map map)` +
+`CallableStatement.getObject(String parameterName, Map map)` +
+`CallableStatement.getRef(int parameterIndex)` +
+`CallableStatement.getRef(String parameterName)` +
+`CallableStatement.getURL(int parameterIndex)` +
+`CallableStatement.getURL(String parameterName)` +
+`CallableStatement.executeBatch()` | The particular `CallableStatement` 
method is not supported.
+| `Connection.releaseSavepoint(Savepoint savepoint)` +
+`Connection.rollback(Savepoint savepoint)` +
+`Connection.setSavepoint()` +
+`Connection.setSavepoint(String name)` | The particular `Connection` 
methods are not supported.
+| `PreparedStatement.setArray(int parameterIndex, Array x)` +
+`PreparedStatement.setRef(int parameterIndex, Ref x)` +
+`PreparedStatement.setURL(int parameterIndex, URL x)` | The particular 
`PreparedStatement` methods are not supported.
+| `ResultSet.getArray(int columnIndex)` +
+`ResultSet.getArray(String columnName)` +
+`ResultSet.getObject(int columnIndex, Map map)` +
+`ResultSet.getObject(String columnName, Map map)` +
+`ResultSet.getRef(int columnIndex)ResultSet.getRef(String columnName)` +
+`ResultSet.getURL(int columnIndex)` +
+`ResultSet.getURL(String columnName)` +
+`ResultSet.updateArray(int columnIndex)` +
+`ResultSet.updateArray(String columnName)` +
+`ResultSet.updateRef(int columnIndex)` +
+`ResultSet.updateRef(String columnName) | The particular `ResultSet` 
methods are not supported.
+| `Statement.getQueryTimeout()` +
+`Statement.setQueryTimeout()` | The particular `Statement` methods are not 
supported.
+|===
+
+The following methods in the java.sql package throw an SQLException with
+the message `Auto generated keys not supported`:
+
+[cols="65%,35%", options="header" ]
+|===
+| Method   | Comments
+| `Connection.prepareStatement(String sql, int autoGeneratedKeys)` +
+`Connection.prepareStatement(String sql, int[] columnIndexes)` +
+`Connection.prepareStatement(String sql, String[] columnNames)` | 
Automatically generated keys are not supported.
+| `Statement.executeUpdate(String sql, int autoGen

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61669923
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/compliance.adoc ---
@@ -0,0 +1,386 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[type-4-driver-compliance]]
+= Type 4 Driver Compliance
+
+[[compliance-overview]]
+== Compliance Overview
+
+The Type 4 driver conforms where applicable to the JDBC
+3.0 API specification. However, this driver differs from the JDBC
+standard in some ways. This subsection describes the JDBC methods that
+are not supported, the methods and features that deviate from the
+specification, and features that are {project-name} extensions to the JDBC 
standard.
+JDBC features that conform to the specification are not described in this 
subsection.
+
+In addition, this chapter lists features of {project-name} SQL that are 
not supported by the {project-name} JDBC Type 4 driver, other
+unsupported features, and restrictions.
+
+[[unsupported-features]]
+== Unsupported Features
+
+These methods in the java.sql package throw an SQLException with the
+message `Unsupported feature - `:
+
+[cols="65%,35%", options="header"]
+|===
+| Method   | Comments
+| `CallableStatement.getArray(int parameterIndex)` +
+`CallableStatement.getArray(String parameterName)` +
+`CallableStatement.getBlob(int parameterIndex)` +
+`CallableStatement.getBlob(String parameterName)` +
+`CallableStatement.getClob(int parameterIndex)` +
+`CallableStatement.getClob(String parameterName)` +
+`CallableStatement.getObject(int parameterIndex, Map map)` +
+`CallableStatement.getObject(String parameterName, Map map)` +
+`CallableStatement.getRef(int parameterIndex)` +
+`CallableStatement.getRef(String parameterName)` +
+`CallableStatement.getURL(int parameterIndex)` +
+`CallableStatement.getURL(String parameterName)` +
+`CallableStatement.executeBatch()` | The particular `CallableStatement` 
method is not supported.
+| `Connection.releaseSavepoint(Savepoint savepoint)` +
+`Connection.rollback(Savepoint savepoint)` +
+`Connection.setSavepoint()` +
+`Connection.setSavepoint(String name)` | The particular `Connection` 
methods are not supported.
+| `PreparedStatement.setArray(int parameterIndex, Array x)` +
+`PreparedStatement.setRef(int parameterIndex, Ref x)` +
+`PreparedStatement.setURL(int parameterIndex, URL x)` | The particular 
`PreparedStatement` methods are not supported.
+| `ResultSet.getArray(int columnIndex)` +
+`ResultSet.getArray(String columnName)` +
+`ResultSet.getObject(int columnIndex, Map map)` +
+`ResultSet.getObject(String columnName, Map map)` +
+`ResultSet.getRef(int columnIndex)ResultSet.getRef(String columnName)` +
+`ResultSet.getURL(int columnIndex)` +
+`ResultSet.getURL(String columnName)` +
+`ResultSet.updateArray(int columnIndex)` +
+`ResultSet.updateArray(String columnName)` +
+`ResultSet.updateRef(int columnIndex)` +
+`ResultSet.updateRef(String columnName) | The particular `ResultSet` 
methods are not supported.
+| `Statement.getQueryTimeout()` +
+`Statement.setQueryTimeout()` | The particular `Statement` methods are not 
supported.
+|===
+
+The following methods in the java.sql package throw an SQLException with
+the message `Auto generated keys not supported`:
+
+[cols="65%,35%", options="header" ]
+|===
+| Method   | Comments
+| `Connection.prepareStatement(String sql, int autoGeneratedKeys)` +
+`Connection.prepareStatement(String sql, int[] columnIndexes)` +
+`Connection.prepareStatement(String sql, String[] columnNames)` | 
Automatically generated keys are not supported.
+| `Statement.executeUpdate(String sql, int autoGen

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665457
  
--- Diff: 
docs/jdbct4ref_guide/src/asciidoc/_chapters/avoiding_mismatch.adoc ---
@@ -0,0 +1,106 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[avoiding-driver-server-version-mismatch]]
+= Avoiding Driver-Server Version Mismatch
+
+The {project-name} JDBC type 4 driver described in this
+document can connect only with an version-equivalent platform
+(server). It cannot connect with an earlier version platform.
+
+To make a connection with the {project-name} platform, JDBC clients,
+through the driver, connect with the {project-name} database
+connectivity service (DCS) on the {project-name} platform. In some
+situations, {project-name} JDBC clients need to make connections to
+older-version platforms (servers) from the same client boxes.
+To make a connection, the driver version
+must be compatible with the {project-name} platform version.
+
+NOTE: The DCS release version and {project-name} platform release
+version are always the same.
+
+
+[[compatible-versions]]
+== Compatible Versions
+
+Ensure that you install the driver version that is compatible with the
+{project-name} platform version.
+
+
+[cols=",",options="header" ]
+|===
+| Driver version  | Compatible versions of the {project-name} platform
+| {project-name} Release 2.0 driver  | All versions up to, but not 
including, {project-name} Release 2.2
+| {project-name} Release 2.1 driver  | All versions up to, but not 
including, {project-name} Release 2.2
+| {project-name} Release 2.2 driver  | {project-name} Release 2.2 and 
later versions
+|===
+
+If a compatible version is not installed, you can obtain the software to
+download from the {project-name} download site.
+

+[[considerations-for-mixed-version-jdbc-clients-connecting-to-project-name-platforms]]
+== Considerations for Mixed-Version JDBC Clients Connecting to 
{project-name} Platforms
+
+On the client platform, you can install multiple versions of the
+{project-name} JDBC type 4 driver to connect to {project-name}
+platforms of different platform versions.
+
+* Assuming you have installed the Release 2.2 {project-name} JDBC type
+4 driver on your workstation and set up the client environment, the 2.2
+driver's classes are set your java CLASSPATH.
+* To connect to a Release 2.1 or 2.0 server ({project-name} platform)
+from the same client machine, you must load the 2.1 driver by making
+sure that it is in your java CLASSPATH.
+* Connecting to both a 2.1 and 2.2 server from the same application at
+the same time is not possible.
+* A given application must use either the 2.2 driver or the 2.1 driver
+when launched. The only way to switch is to reload the application when
+pointing to a new CLASSPATH that contains a different driver.
+
+[[version-mismatch-error-message]]
+== Version Mismatch Error Message
+
+If an {project-name} JDBC client attempts to connect to an invalid DCS
+version, the driver returns the error:
+
+```
+SQLCODE: 29162
+SQLSTATE S1000
+
+Error text:
+
+Unexpected programming exception has been found: . Check
+the server event log on node  for details.
+```
+
+*  is the error text from the server.
+*  is the location of the log file.
+
+Additional error text returned only by a Release 2.2 server, but displayed 
by any version driver:
--- End diff --

Delete all of this till end of T7969...


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at 

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665441
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665392
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665276
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665243
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665223
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665226
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
+
+NOTE: There is no secure wire communication such as SSL provided for the
+communication between Type 4 driver and the {project-name} platform.
+
+<<<
+[[connection-by-using-the-datasource-interface]]
+== Connection by Using the DataSource Interface
+
+The `javax.sql.DataSource` interface is the preferred way to establish a
+connection to the database because this interface enhances the application
+portability. Portability is achieved by allowing the application to use a
+logical name for a data source instead of providing driver-specific 
information
+in the application. A logical name is mapped to a `javax.sql.DataSource`
+object through a naming service that uses the Java Naming and Directory
+Interface (JNDI). Using this DataSource method is particularly recommended
+for application servers.
+
+When an application requests a connection by using the `getConnection` 
method
+in the `DataSource`, then the method returns a `Connection` object.
+
+A `DataSource` object is a factory for `Connection` objects. An object that
+implements the `DataSource` interface is typically registered with a JNDI
+service provider.
+
+[[overview-of-tasks-to-deploy-datasource-objects]]
+=== Overview of Tasks to Deploy DataSource Objects
+
+Before an application can connect to a `DataSource` object, typically
+the system administrator deploys the `DataSource` object so that
+the application programmers can start using it.
+
+Data source properties are usually set by a system administrator using
+a GUI tool as part of

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665164
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
+connections using different user IDs, and creating different Connection
+objects.
+
+The Type 4 driver provides for user name and password authentication.
+The password is encrypted with a proprietary algorithm provided by DCS.
--- End diff --

This sentence can be "The password is encrypted" and remove the remaining 
text...


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665152
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
+`org.trafodion.t4jdbc.HPT4ConnectionPoolDataSource`. (These classes are
+defined by the JDBC 3.0 specification.)
+
+Typically, a user or system administrator uses a tool to create a data
+source, and then registers the data source by using a JNDI service
+provider. At run time, a user application typically retrieves the data
+source through JNDI, and uses the data source's methods to establish a
+connection to the underlying database.
+
+A DataSource object maps to an instance of a database. In the Type 4
+driver product, the DataSource object acts as an interface between the
+application code and the database and enables connection with an DCS
+data source.
+
+[[security]]
+== Security
+
+Clients connect to the {project-name} platform with a valid user name
+and ID, using standard JDBC 3.0 APIs. An application can make multiple
--- End diff --

Change ID to password 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Trafodion 1949: New JDBC Type 4 ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/457#discussion_r61665112
  
--- Diff: docs/jdbct4ref_guide/src/asciidoc/_chapters/accessing.adoc ---
@@ -0,0 +1,910 @@
+
+/**
+ *@@@ START COPYRIGHT @@@
+ * 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.
+ * @@@ END COPYRIGHT @@@
+ */
+
+
+[[accessing-project-name-sql-databases]]
+= Accessing {project-name} SQL Databases
+
+[[data-sources]]
+== Data Sources
+
+The term *data source* logically refers to a database or other data
+storage entity. A JDBC (client) data source is physically a Java object 
that
+contains properties such as the URL of the physical database, the
+catalog to use when connecting to this database, and the schema to use
+when connecting to this database. The JDBC data source also contains
+methods for obtaining a JDBC connection to the underlying database.
+
+[[jdbc-data-source-client-side]]
+=== JDBC Data Source (client-side)
+
+All JDBC data source classes implement either the `javax.sql.DataSource`
+interface or the `javax.sql.ConnectionPoolDataSource` interface. The Type
+4 driver data source classes are `org.trafodion.t4jdbc.HPT4DataSource` and
--- End diff --

This should be org.trafodion.jdbc.t4 instead of org.trafodion.t4jdbc


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1933] Migrate jdbcT4 ...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/458

[TRAFODION-1933] Migrate jdbcT4 and trafci build scripts from Ant to Maven

This PR only contains migration changes for jdbcT4.  TRAFCI migration to 
Maven will be done in a seperate JIRA.

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/458.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #458


commit 72e170198fa80baa9891fc40fc7b66da8cbb6a32
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-18T16:11:06Z

TRAFODION-1933 JDBC TYpe4 driver build scripts migrated to use maven 
instead of ant

commit 5ac5a9f2ac17a45ff7b6c2f39254f26e550cb5e3
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-18T16:32:11Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 500d20767fad083cc0fda1c1ef9d895b295ed412
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-18T16:35:58Z

including the missing files in previous commit

commit 90667eeab9a1dbb20982470eec320e84603f5baf
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-19T15:33:06Z

Minor fixes

commit a0f21cde508487d96f62bcf4c930f015e9fa57b8
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-19T18:07:06Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

Conflicts:
core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/BaseRow.java
core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/InsertRow.java
core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/Row.java

commit 3253e7231f7d01a444643069d2ac7fd7cd1912b2
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T00:17:06Z

Additional jdbcT4 changes in other components

commit 8a8d2ad7bdf7fd36cf5c45adb2d3e5e57b662be5
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T00:20:35Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 842caed8b8c1616e22c0f49aa240994ce62b6b45
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T03:46:45Z

fixed the dependency

commit e17dce614702af782db997db5bbca47c99b50aa6
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T16:55:38Z

additional files

commit 9d450e992f4d8610f1caff99181fd232849b368a
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T17:25:07Z

updated files

commit 5955e92b21961b2805149f9f02f11ce681a5026e
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-22T22:47:01Z

fixed dcs/rest/udr to have the version infor for jdbcT4 jar file

commit 8ed58bf6389015275646f83298ca2bf067f817f9
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-26T16:18:13Z

Minor T4 driver fix
Fixed duplicate copyright in dcs files

commit c4d50df102924d9bd5410d09309d3b5fa277cc89
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-28T18:31:51Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 1ca6f60806e2d76eb7b78c4c5bbd218410d7d8ec
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-29T15:33:44Z

Updated the dependencies

commit b50829942facca522efc41fbece00720717a3cf1
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-29T15:34:06Z

Merge branch 'master' of github.com:apache/incubator-trafodion into wrkbrnch

commit 780f976a6b3412f9f0bc8bb946fe25adf400dde3
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-04-29T16:04:34Z

Included LICENSE and NOTICE in T4 zip file




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Fix for a typo in runregr_udr, c...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/369#discussion_r55256104
  
--- Diff: core/sql/regress/tools/runregr_udr.ksh ---
@@ -851,9 +851,9 @@ if [ $LINUX -ne 0 ]; then
 fi
 
--- End diff --

Should be fine Hans.  Just did not want to see hpt4jdbc.jar being 
referenced anywhere incorrectly as our tyep4 jar file is now called jdbcT4.jar


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Fix for a typo in runregr_udr, c...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/369#discussion_r55254497
  
--- Diff: core/sql/regress/tools/runregr_udr.ksh ---
@@ -851,9 +851,9 @@ if [ $LINUX -ne 0 ]; then
 fi
 
--- End diff --

Do we want to clean up the unused  env variables/conditional checks ( 
_RLD_LIB_PATH and CLASSPATH) ?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r51331627
  
--- Diff: install/installer/traf_config_setup ---
@@ -528,7 +555,7 @@ echo "export 
DCS_PRIMARY_MASTER_NODE=\"$DCS_PRIMARY_MASTER_NODE\"" >> $LOCAL_TRA
 #==
 #Enable HA
 
-echo -n "Enable High Availability (Y/N), default is N: "
+echo -n "Enable High Avalability (Y/N), default is N: "
--- End diff --

Typo for Availability


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r51333079
  
--- Diff: install/installer/trafodion_install ---
@@ -718,7 +761,7 @@ if [[ "$LDAP_SECURITY" == "Y" ]]; then
   $TRAF_PDSH sudo chmod 750 $HOME_DIR/$TRAF_USER/$LDAP_AUTH_FILE
   if [[ $LDAP_LEVEL == "2" ]] || [[ $LDAP_LEVEL == "1" ]]; then
  echo "***INFO: Copying $LDAP_CERT to Trafodion home dir"
- $TRAF_PDCP $LDAP_CERT $HOME
+ $TRAF_PCP $LDAP_CERT $HOME
--- End diff --

This should be TRAF_PDCP


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50443958
  
--- Diff: install/installer/dcs_installer ---
@@ -196,8 +194,6 @@ echo $DCS_PRIMARY_MASTER_NODE > $DCS_DIR/conf/master
 
 
 if [[ "$ENABLE_HA" == "true" ]]; then
-
-   ##Configure dcs-site.xml file
--- End diff --

can you put back the comments in this file


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50444726
  
--- Diff: install/installer/traf_add_sudoAccess ---
@@ -23,12 +23,12 @@
 TRAF_CONFIG=/etc/trafodion/trafodion_config
 source $TRAF_CONFIG
 
-if [ $node_count -eq 1 ]; then
+if [ $all_node_count -eq 1 ]; then
 TRAF_PDSH=""
 TRAF_PDCP=""
 else
-TRAF_PDSH="pdsh -R exec $MY_NODES $PDSH_SSH_CMD"
-TRAF_PDCP="pdcp -R ssh $MY_NODES"
+TRAF_PDSH="pdsh -R exec $ALL_NODES $PDSH_SSH_CMD"
+TRAF_PDCP="pdcp -R ssh $ALL_NODES"
 fi
--- End diff --

Can generalize the TRAF_PDSH and TRAF_PDCP environment variables in the 
config file that is sourced in.  Then these conditional checks for setting them 
can be removed from each script


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50451782
  
--- Diff: install/installer/traf_config_setup ---
@@ -226,6 +230,33 @@ echo "export NODE_LIST=\"$NODE_LIST\"" >> 
$LOCAL_TRAF_CONFIG
 node_count=$(echo $NODE_LIST | wc -w)
 
 #==
+echo -n "Are management nodes enabled (Y/N), default is N: "
+read answer
+ 
+if [ -z $answer ]; then
+  echo "export MANAGE_ENABLED=\"N\"" >> $LOCAL_TRAF_CONFIG
+else
+  if [[ "${answer}" =~ ^[Yy]$ ]]; then
+ echo "export MANAGE_ENABLED=\"Y\"" >> $LOCAL_TRAF_CONFIG
+ #List of Management Nodes
+ echo -n "Enter list management nodes (blank separated), default 
[$MANAGE_NODES]: "
+ read answer
+ if [[ -z "$answer" ]]; then
+if [ -z "$MANAGE_NODES" ]; then
+   echo "***ERROR: Must enter list of management nodes."
+   exit -1
+fi
+ else
+MANAGE_NODES="$answer"
--- End diff --

Should be MANAGEMENT_NODES instead of MANAGE_NODES. Should fix all files 
where this is referenced


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50466634
  
--- Diff: install/installer/traf_sqgen ---
@@ -0,0 +1,96 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+export TRAF_CONFIG=/etc/trafodion/trafodion_config
+
+source $TRAF_CONFIG
+
+STARTING_NODE=$(hostname)
+
+#==
+echo "***INFO: starting sqgen" | tee -a $INSTALL_LOG
+cd $SQ_ROOT/sql/scripts
+$SQ_ROOT/sql/scripts/sqgen
+SQGEN_RC=$?
+if [ "$SQGEN_RC" != "0" ]; then
+echo "***ERROR: sqgen failed with RC=$SQGEN_RC. Check install log file 
for details." | tee -a $INSTALL_LOG
+exit -1;
+fi
+#==
+
+if [ "$node_count" -ne "1" ]; then
--- End diff --

Should this now be all_node_count instead of node_count?

 It would have been better if node_count was assigned all_node_count  and 
MY_NODES was assigned ALL_NODES. That way changes could be kept to  minimal


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50466851
  
--- Diff: install/installer/traf_sqgen ---
@@ -0,0 +1,96 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+export TRAF_CONFIG=/etc/trafodion/trafodion_config
+
+source $TRAF_CONFIG
+
+STARTING_NODE=$(hostname)
+
+#==
+echo "***INFO: starting sqgen" | tee -a $INSTALL_LOG
+cd $SQ_ROOT/sql/scripts
+$SQ_ROOT/sql/scripts/sqgen
+SQGEN_RC=$?
+if [ "$SQGEN_RC" != "0" ]; then
+echo "***ERROR: sqgen failed with RC=$SQGEN_RC. Check install log file 
for details." | tee -a $INSTALL_LOG
+exit -1;
+fi
+#==
+
+if [ "$node_count" -ne "1" ]; then
+echo "***INFO: copying $HOME/sqcert directory to all nodes" | tee -a 
$INSTALL_LOG
+$PDCP $ALL_NODES -x $HOSTNAME -r $HOME/sqcert $HOME
+fi
+
+#==
+
+if [ "$all_node_count" -ne "1" ]; then
--- End diff --

Is this check required ? can the pdcp step be incorporated in the previous 
conditional check itself?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50451279
  
--- Diff: install/installer/traf_config_setup ---
@@ -226,6 +230,33 @@ echo "export NODE_LIST=\"$NODE_LIST\"" >> 
$LOCAL_TRAF_CONFIG
 node_count=$(echo $NODE_LIST | wc -w)
 
 #==
+echo -n "Are management nodes enabled (Y/N), default is N: "
+read answer
+ 
+if [ -z $answer ]; then
+  echo "export MANAGE_ENABLED=\"N\"" >> $LOCAL_TRAF_CONFIG
+else
+  if [[ "${answer}" =~ ^[Yy]$ ]]; then
+ echo "export MANAGE_ENABLED=\"Y\"" >> $LOCAL_TRAF_CONFIG
+ #List of Management Nodes
+ echo -n "Enter list management nodes (blank separated), default 
[$MANAGE_NODES]: "
+ read answer
+ if [[ -z "$answer" ]]; then
+if [ -z "$MANAGE_NODES" ]; then
+   echo "***ERROR: Must enter list of management nodes."
--- End diff --

Can we update the message as "Management nodes must be specified."


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50449380
  
--- Diff: install/installer/traf_config_setup ---
@@ -211,7 +215,7 @@ fi
 #==
 # List of Nodes
 
-echo -n "Enter list of nodes (blank separated), default [$NODE_LIST]: "
+echo -n "Enter list of Trafodion nodes (blank separated), default 
[$NODE_LIST]: "
--- End diff --

Do we want to call this Trafodion nodes or data nodes: ? 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50449749
  
--- Diff: install/installer/traf_config_setup ---
@@ -226,6 +230,33 @@ echo "export NODE_LIST=\"$NODE_LIST\"" >> 
$LOCAL_TRAF_CONFIG
 node_count=$(echo $NODE_LIST | wc -w)
 
 #==
+echo -n "Are management nodes enabled (Y/N), default is N: "
--- End diff --

Should this question be "Do you have a set of management nodes (Y/N), 
default is N:"


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50451389
  
--- Diff: install/installer/traf_config_setup ---
@@ -226,6 +230,33 @@ echo "export NODE_LIST=\"$NODE_LIST\"" >> 
$LOCAL_TRAF_CONFIG
 node_count=$(echo $NODE_LIST | wc -w)
 
 #==
+echo -n "Are management nodes enabled (Y/N), default is N: "
+read answer
+ 
+if [ -z $answer ]; then
+  echo "export MANAGE_ENABLED=\"N\"" >> $LOCAL_TRAF_CONFIG
+else
+  if [[ "${answer}" =~ ^[Yy]$ ]]; then
+ echo "export MANAGE_ENABLED=\"Y\"" >> $LOCAL_TRAF_CONFIG
+ #List of Management Nodes
+ echo -n "Enter list management nodes (blank separated), default 
[$MANAGE_NODES]: "
+ read answer
+ if [[ -z "$answer" ]]; then
+if [ -z "$MANAGE_NODES" ]; then
+   echo "***ERROR: Must enter list of management nodes."
+   exit -1
+fi
+ else
+MANAGE_NODES="$answer"
+ fi
+
+ echo "export MANAGE_NODES=\"$MANAGE_NODES\"" >> $LOCAL_TRAF_CONFIG
+  else
+ echo "export MANAGE_ENABLED=\"N\"" >> $LOCAL_TRAF_CONFIG
--- End diff --

can be removed if default value is initialized


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50452962
  
--- Diff: install/installer/traf_config_setup ---
@@ -544,9 +574,9 @@ fi
 echo "export ENABLE_HA=\"$ENABLE_HA\"" >> $LOCAL_TRAF_CONFIG
 
 #==
-#Get the floating IP address, interface name and the list of backup nodes 
to be used 
--- End diff --

can you put back this comment


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: Many bug fixes for Installer. Al...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/274#discussion_r50453726
  
--- Diff: install/installer/traf_getHadoopNodes ---
@@ -31,20 +29,22 @@ echo "***INFO: Getting list of all $HADOOP_TYPE nodes"
 
 curlRC=0
 if [[ $HADOOP_TYPE == "cloudera" ]]; then
-   curl -su $ADMIN:$PASSWORD http://$URL/api/v6/cm/deployment > tempFile
+   curl -k -su $ADMIN:$PASSWORD $URL/api/v10/hosts > tempFile
curlRC=$?
--- End diff --

Looks like curlRC is not being used here, can be removed


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/251

[TRAFODION-1680] Dcs needs to provide support for HA on AWS

Documentation and installer changes

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrkbrnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/251.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #251


commit 1cde2505bef3b26428537c064790db8157a2b9ae
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-01-05T17:46:09Z

Documentation and installer change for Floating IP

commit d5e3e843e010443f530c9010658c957f2b554fd3
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-01-05T21:35:28Z

Applied review comments

commit c2ce702e22f63b05ca59fb609803e0339e7c5de7
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-01-06T23:53:44Z

Fixed issues seen during testing

commit 4e30bf08e0d88106f5b6ccf29652d65ec8b966c9
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2016-01-07T00:42:04Z

fixed issued




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1685]Fix catalog api ...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/236#discussion_r48210797
  
--- Diff: core/conn/jdbc_type2/native/SrvrSmd.cpp ---
@@ -357,6 +357,7 @@ void odbc_SQLSvc_GetSQLCatalogs_sme_(
}
 
SQLValue = (SQLValue_def *)outputValueList->_buffer;
+   /* //useless and doesn't be included in MXOS server
--- End diff --

Can we remove the code in comments?  Is there a reason why we need to keep 
it?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/231#discussion_r48059956
  
--- Diff: RAT_README.txt ---
@@ -60,6 +60,7 @@ $MY_SQROOT/../sql/bin/SqlciErrors.txt
 
 dcs/conf/servers 
 dcs/conf/backup-masters 
+dcs/conf/master
  :  Apache Trafodion DCS default configuration file
  -> configuration file do not handle comments
 
--- End diff --

This is not documentation but a short description for each component  for 
list of files that excludes the copyright information as mentioned in the 
initial section of the this file. 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/231#discussion_r48060646
  
--- Diff: install/installer/setup_ssh_key ---
@@ -0,0 +1,27 @@
+#!/bin/bash
--- End diff --

This is is similar to our backup-masters file which is also empty and does 
no harm but it helps users to know that they can modify this file if they 
require DcsMaster to start on a specific node. Dcs documentation will be 
updated in the subsequent PR


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1668]initialize spj f...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/203#discussion_r47968093
  
--- Diff: core/conn/spj_mgmt/Makefile ---
@@ -0,0 +1,37 @@
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+LIBDIR := lib
+JAVAC := $(JAVA_HOME)/bin/javac
+INSTALL_LIBDIR := ${MY_SQROOT}/export/lib
+INSTALL_SCRIPTSDIR := ${MY_SQROOT}/sql/scripts
+CP :=/bin/cp -f
+INSTALL_INCLUDEDIR := ${MY_SQROOT}/export/include
--- End diff --

Do we need these 2 variables LIBDIR and INSTALL_INCLUDEDIR?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1668]initialize spj f...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/203#discussion_r47974185
  
--- Diff: 
core/conn/spj_mgmt/src/main/java/org/trafodion/mgmt/JarFileMgmt.java ---
@@ -0,0 +1,434 @@
+/**
+* @@@ START COPYRIGHT @@@
+*
+* 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.
+*
+* @@@ END COPYRIGHT @@@
+ */
+package org.trafodion.mgmt;
--- End diff --

can we call the package name same as the directory name 
org.trafodion.spjmgmt.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/231#discussion_r47984503
  
--- Diff: core/sqf/sql/scripts/cleanlogs ---
@@ -0,0 +1,92 @@
+#!/bin/bash
+#
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+# This script cleans up the log files of various components
+if [ -e $SQ_PDSH ]; then
+   L_PDSH="/usr/bin/pdsh $MY_NODES "
+else
+   L_PDSH=
+fi
+
+function usage() {
+   prog=`basename $0` 
+   echo ""
+   echo "$prog { all | dcs | rest | core }"
+   echo "all  --- Remove files from core, dcs and rest logs folder"
+   echo "dcs  --- Remove files from $DCS_INSTALL_DIR/logs folder"
+   echo "rest --- Remove files from $REST_INSTALL_DIR/logs folder"
+   echo "core --- Remove log files residing in $MY_SQROOT/logs folder"
--- End diff --

cleanlogs script is only a helpful utility. This cleanlogs script is not 
invoked by any other script and used only on demand on need basis.  The logs 
for core are all the log files that reside in MY_SQROOT/logs folder


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/231#discussion_r47984639
  
--- Diff: RAT_README.txt ---
@@ -60,6 +60,7 @@ $MY_SQROOT/../sql/bin/SqlciErrors.txt
 
 dcs/conf/servers 
 dcs/conf/backup-masters 
+dcs/conf/master
  :  Apache Trafodion DCS default configuration file
  -> configuration file do not handle comments
 
--- End diff --

dcs/conf/master is another configuration file which contains the hostname.. 
It is  just like backup-masters file and as described in the comments it  does 
not handle comments


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1680] Dcs needs to pr...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/231

[TRAFODION-1680] Dcs needs to provide support for HA on AWS



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/231.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #231


commit 1f0d872bd11262fbd5b66b3e11d3cab059faf050
Author: Anuradha Hegde <hegd...@adev04.esgyn.com>
Date:   2015-12-14T03:33:33Z

Floating IP support for AWS cluster

commit f9ef790dc6cc35fc2aece7771feb92321f4f6fdb
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-14T03:36:23Z

Merge branch 'master' into wrk-brnch

commit fafc88ff812ffc23fd88217dc65d78d234e76198
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-15T02:02:26Z

Merge branch 'master' into wrk-brnch

commit 68157d51fd1dbbbff562b2564f664b7783372c12
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-15T18:32:23Z

Additional changes for floating ip.
Support to start dcsmaster on remote node

commit c14887c5940c8fa99a35138cd984a3e2a5e4ab3c
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-15T18:34:09Z

Merge branch 'master' into wrk-brnch

commit 34ff7b309b58e76f3461c0519940f2e3463d8d13
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-15T18:52:32Z

Merge branch 'master' into wrk-brnch

commit bc691879b0012888e12ee2be9d6eb948359e5f30
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-16T18:15:30Z

Improved display for dcscheck script
additional bug fixes

commit cbcde79ea87bae975a3a1c18faa17223d80b1a2d
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-16T23:42:33Z

fixes

commit 254447922f3df5aaa411ca7c50b6528265c5
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-16T23:49:02Z

added the missing quotes

commit 718880c8f0e8cb08fb2fe29ab456f8cdf33fa9cd
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-12-16T23:58:41Z

Changed name to lowercase for  MXOSRVR to match the process name




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1670] upsert and upse...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/228

[TRAFODION-1670] upsert and upsert with load doesn't report the rows 
affected information in Trafci [TRAFODION-1709] trafci does not deallocate the 
statement



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion trafci-wrk

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/228.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #228


commit 8617ad9cedf4ae721ed1a428ba11455164f50f10
Author: Anuradha Hegde <hegdean@edev06.esgyn.local>
Date:   2015-12-14T23:57:46Z

- Status message for UPSERT statement reports the number of records that 
are inserted
- Fix to close the statement object after execution (execdirect)




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1668]initialize spj f...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46655295
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
--- End diff --

remove CI_SERVER_LOG if  not being used
We don't build 32 bit anymore. Need to change it to 64 bit and reference  
debug or  release version


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1668]initialize spj f...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46655613
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
+CIS_SCHEMA=DEFAULT_SPJ
+
+
+function dropAndCreateSchema {
+echo "Creating Schema for CI Server Component"
--- End diff --

remove the echo statement or change the description


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1668]initialize spj f...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46655533
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
--- End diff --

Can we change the name from MANAGEABILITY_CATALOG to something 
else(CATALOG_NAME)


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1647]Put unified copy...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/189#discussion_r45822914
  
--- Diff: core/conn/trafci/build.xml ---
@@ -148,6 +148,8 @@
 


+   
+   
--- End diff --

The 2 new lines are redundant as the previous 2 lines (149 and 150) do the 
same thing


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1647]Put unified copy...

[hegdean]

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

https://github.com/apache/incubator-trafodion/pull/189#discussion_r45822943
  
--- Diff: core/conn/trafci/utils/trafci.sh ---
@@ -27,6 +27,8 @@
 #
 
 TRAFCI_CLASSPATH="##TRAFCI_CLASSPATH##"
+export TRAFODION_VER_PROD="##prodver##"
+export PRODUCT_COPYRIGHT_HEADER="##copyrighthdr##"
--- End diff --

How is ##prodver## being substituted?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1579] Clean up test s...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/159

[TRAFODION-1579] Clean up test scripts



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/159.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #159


commit 0ce8b15c094a1e43e13eec67e6d4f35c898533f8
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-11-03T17:53:50Z

Cleanup the scripts to remove HP names

commit 3bc1a7f1c43096c27c0317a26847ecc6b6be8bbe
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-11-03T17:58:22Z

Merge branch 'master' of github.com:apache/incubator-trafodion into 
wrk-brnch

Conflicts:
core/sqf/sql/scripts/install_traf_components




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: TRAFODION-1549 Extends event_log...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/147

TRAFODION-1549 Extends event_log_reader TMUDF to read DCS logs and overflow 
files from all components

Fix in installer so DCS_INSTALL_DIR is set before executing sqgen so that 
UDFs can read this environment variable

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/147.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #147


commit 5977ca5712303261f145df8602650f6042fdfc8f
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-10-21T21:10:40Z

Merge branch 'master' of github.com:apache/incubator-trafodion into 
wrk-brnch

commit f13f269c6e94a1e67b022c14920602b640cebd8c
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-10-23T03:50:50Z

Merge branch 'master' of github.com:apache/incubator-trafodion into 
wrk-brnch

commit 6046ef706ba2fdbdc015f666b602138055e2c55f
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-10-27T04:55:35Z

Merge branch 'master' of github.com:apache/incubator-trafodion into 
wrk-brnch

commit 397e06b16777932c0ccb1d23ab08996046de0e97
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-10-27T22:33:21Z

Moved sqgen step after dcsinstaller and restinstaller




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1527] Dcs Webui shows...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/122

[TRAFODION-1527] Dcs Webui shows the dcs version as unknown

Added a new target to Makefile(toplevel and core) to install traf components
 (Ex: make trafinstall)
Updated the format of DCS log files
Fixed minor issues

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/122.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #122


commit 5a2eceb6c0f8d36010b48f57e94a020c86a71f1d
Author: Anuradha Hegde <hegd...@dev02.trafodion.org>
Date:   2015-10-14T05:02:16Z

Fixed version issue in DCS
Added a new target to Makefile(toplevel and core) to install
traf components( eg: make trafinstall)
Updated the format of DCS log files
fixed minor issues




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION 1511] Phoenix tests w...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/108

[TRAFODION 1511] Phoenix tests when using T2 driver fails with Index out of 
range error

Updated license file for Linux Driver

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/108.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #108


commit 5e17dfe957f6350cd163c0a4938418d1159de99b
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-10-07T20:50:19Z

[TRAFODION-1511] Phoenix tests when using T2 driver fails with Index out of 
range error

Updated the license file for Linux driver




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1506] TRAFCI on windo...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/103

[TRAFODION-1506] TRAFCI on windows is missing the banner and copyright 
information

Fixed the version information for source package
Fixed other minor issues

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/103.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #103


commit 4e2784214bad33882719e766f8b3e5798f3301a1
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-10-05T17:32:40Z

Changed the source package name to contain the version info
Fixed trafci banner issue for non-unix machines
Fixed other minor issues

commit b209f13b2eba327fdec3fc974b85afe4506f1438
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-10-05T19:05:42Z

compressed the src package




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1506] TRAFCI on windo...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/106

[TRAFODION-1506] TRAFCI on windows is missing the banner and copyright 
information O added copyright to template file Changed the source packaging tar 
file name



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/106.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #106


commit 7c7245e821b09dd2c1ae45c3a02912123fadc13a
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-10-06T04:51:56Z

Added copyright to template file
Fixed the package name for the src tar file




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: TRAFODION-1501 Packaging trafodi...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/97

TRAFODION-1501 Packaging trafodion source is missing in build script



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion wrk-brnch

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/97.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #97


commit 444e0409cf4ef76e24507b05b32a5cc8ccc0ece9
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date:   2015-09-30T18:30:20Z

Modified top level makefile to package trafodion source




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-30]dcs start fails on...

[hegdean]

GitHub user hegdean opened a pull request:

https://github.com/apache/incubator-trafodion/pull/29

[TRAFODION-30]dcs start fails on development workspaces when

 using install_local_hadoop

Fixed the local hadoop script so servers file in $DCS_INSTALL_DIR
/conf folder is generated correctly. Also took care of the default
github location for DCS/REST and Phoenix tests

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/hegdean/incubator-trafodion traf-30

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/29.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #29


commit 0fe0c4134279c3550d2100c4c79ed1982cbbe264
Author: Anuradha Hegde hegd...@dev02.trafodion.org
Date:   2015-07-15T18:43:27Z

[TRAFODION-30]dcs start fails on development workspaces when
 using install_local_hadoop

Fixed the local hadoop script so servers file in $DCS_INSTALL_DIR
/conf folder is generated correctly. Also took care of the default
github location for DCS/REST and Phoenix tests




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---