You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/05/02 18:11:58 UTC
[19/60] incubator-trafodion git commit: TRAFODION-1933 JDBC TYpe4
driver build scripts migrated to use maven instead of ant
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_LIST_def.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_LIST_def.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_LIST_def.java
new file mode 100644
index 0000000..62214a4
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_LIST_def.java
@@ -0,0 +1,65 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+
+class VERSION_LIST_def {
+ VERSION_def[] list;
+
+ int sizeOf() { // since VERSION_def is a constant size we can just call the
+ // sizeOf() once
+ return VERSION_def.sizeOf() * list.length + TRANSPORT.size_int;
+ }
+
+ void insertIntoByteArray(LogicalByteArray buf) {
+ buf.insertInt(list.length);
+
+ for (int i = 0; i < list.length; i++) {
+ list[i].insertIntoByteArray(buf);
+ }
+ }
+
+ int sizeOfChar() {
+ return list.length * VERSION_def.sizeOfChar() + 10;
+ }
+
+ void insertIntoByteArrayChar(LogicalByteArray buf, InterfaceConnection ic) throws CharacterCodingException, UnsupportedCharsetException{
+ buf.insertFixedString(ic.encodeString("" + list.length, 1), 10);
+
+ for (int i = 0; i < list.length; i++) {
+ list[i].insertIntoByteArrayChar(buf, ic);
+ }
+ }
+
+ void extractFromByteArray(LogicalByteArray buf) {
+ int len = buf.extractInt();
+
+ list = new VERSION_def[len];
+
+ for (int i = 0; i < list.length; i++) {
+ list[i] = new VERSION_def();
+ list[i].extractFromByteArray(buf);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_def.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_def.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_def.java
new file mode 100644
index 0000000..108622a
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/VERSION_def.java
@@ -0,0 +1,61 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+
+class VERSION_def {
+ short componentId;
+ short majorVersion;
+ short minorVersion;
+ int buildId;
+
+ static int sizeOf() {
+ return TRANSPORT.size_int + TRANSPORT.size_short * 3;
+ }
+
+ void insertIntoByteArray(LogicalByteArray buf) {
+ buf.insertShort(componentId);
+ buf.insertShort(majorVersion);
+ buf.insertShort(minorVersion);
+ buf.insertInt(buildId);
+ }
+
+ static int sizeOfChar() {
+ return 50;
+ }
+
+ void insertIntoByteArrayChar(LogicalByteArray buf, InterfaceConnection ic) throws CharacterCodingException, UnsupportedCharsetException{
+ buf.insertFixedString(ic.encodeString("" + componentId, 1), 10);
+ buf.insertFixedString(ic.encodeString("" + majorVersion, 1), 10);
+ buf.insertFixedString(ic.encodeString("" + minorVersion, 1), 10);
+ buf.insertFixedString(ic.encodeString("" + buildId, 1), 20);
+ }
+
+ void extractFromByteArray(LogicalByteArray buf) {
+ componentId = buf.extractShort();
+ majorVersion = buf.extractShort();
+ minorVersion = buf.extractShort();
+ buildId = buf.extractInt();
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/Vproc.java-tmpl
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/Vproc.java-tmpl b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/Vproc.java-tmpl
new file mode 100644
index 0000000..9ab6727
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/Vproc.java-tmpl
@@ -0,0 +1,36 @@
+// @@@ 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.jdbc.t4;
+
+public class Vproc {
+ private static final String vprocStr = "@@@@";
+ static final int jdbcMajorVersion = 1;
+ static final int jdbcMinorVersion = 0;
+
+ public static void main(String[] args) {
+ System.out.println(vprocStr);
+ }
+
+ public static String getVproc() {
+ return vprocStr;
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_GetObjRefHdl_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_GetObjRefHdl_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_GetObjRefHdl_exc_.java
new file mode 100644
index 0000000..564fe5b
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_GetObjRefHdl_exc_.java
@@ -0,0 +1,95 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_Dcs_GetObjRefHdl_exc_ {
+ int exception_nr;
+ int exception_detail;
+
+ String ErrorText;
+ int errorCode;
+
+ //
+ // It looks like ODBC doesn't generate error text in all
+ // error cases, so the following variable will contain
+ // any error text generated by this JDBC driver.
+ // Note, this variable is not part of the message, but it
+ // represents a value stored in the HPT4Messages_*.properties file.
+ //
+
+ String clientErrorText;
+
+ static final int odbc_Dcs_GetObjRefHdl_ASParamError_exn_ = 1;
+ static final int odbc_Dcs_GetObjRefHdl_ASTimeout_exn_ = 2;
+ static final int odbc_Dcs_GetObjRefHdl_ASNoSrvrHdl_exn_ = 3;
+ static final int odbc_Dcs_GetObjRefHdl_ASTryAgain_exn_ = 4;
+ static final int odbc_Dcs_GetObjRefHdl_ASNotAvailable_exn_ = 5;
+ static final int odbc_Dcs_GetObjRefHdl_DSNotAvailable_exn_ = 6;
+ static final int odbc_Dcs_GetObjRefHdl_PortNotAvailable_exn_ = 7;
+ static final int odbc_Dcs_GetObjRefHdl_InvalidUser_exn_ = 8;
+ static final int odbc_Dcs_GetObjRefHdl_LogonUserFailure_exn_ = 9;
+
+ // -------------------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buffer1, InterfaceConnection ic) throws SQLException,
+ UnsupportedCharsetException, CharacterCodingException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ ErrorText = ic.decodeBytes(buffer1.extractString(), 1);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_Dcs_GetObjRefHdl_ASParamError_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ErrorText);
+ case odbc_Dcs_GetObjRefHdl_LogonUserFailure_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unable_to_logon", "");
+ case odbc_Dcs_GetObjRefHdl_ASNotAvailable_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_dcs_srvr_not_available", ErrorText);
+ case odbc_Dcs_GetObjRefHdl_DSNotAvailable_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_ds_not_available", new T4Properties()
+ .getServerDataSource());
+ case odbc_Dcs_GetObjRefHdl_PortNotAvailable_exn_:
+ case odbc_Dcs_GetObjRefHdl_ASTryAgain_exn_:
+ case odbc_Dcs_GetObjRefHdl_ASNoSrvrHdl_exn_:
+ case -27:
+ case -29:
+
+ // should be retried by the driver so dont throw exception
+ clientErrorText = "ids_port_not_available";
+ break;
+ case odbc_Dcs_GetObjRefHdl_InvalidUser_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_28_000", null);
+ case odbc_Dcs_GetObjRefHdl_ASTimeout_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_s1_t00", null);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "unknown_connect_error", null);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_StopSrvr_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_StopSrvr_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_StopSrvr_exc_.java
new file mode 100644
index 0000000..44b6796
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_Dcs_StopSrvr_exc_.java
@@ -0,0 +1,86 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_Dcs_StopSrvr_exc_ {
+
+ int exception_nr;
+ int exception_detail;
+ //
+ // If the third element is not zero, then it is an offset
+ // to a character array that contains a message.
+ //
+ String ErrorText;
+ int errorCode;
+
+ //
+ // It looks like ODBC doesn't generate error text in all
+ // error cases, so the following variable will contain
+ // any error text generated by this JDBC driver.
+ // Note, this variable is not part of the message, but it
+ // represents a value stored in the HPT4Messages_*.properties file.
+ //
+
+ String clientErrorText;
+
+ static final int odbcas_ASSvc_StopSrvr_ASParamError_exn_ = 1;
+ static final int odbcas_ASSvc_StopSrvr_ASNotAvailable_exn_ = 2;
+ static final int odbcas_ASSvc_StopSrvr_SrvrNotFound_exn_ = 3;
+ static final int odbcas_ASSvc_StopSrvr_SrvrInUseByAnotherClient_exn_ = 4;
+ static final int odbcas_ASSvc_StopSrvr_ProcessStopError_exn_ = 5;
+
+ // -------------------------------------------------------------------
+ odbc_Dcs_StopSrvr_exc_() {
+ // Do nothing constructor
+ }
+
+ // -------------------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buffer1, InterfaceConnection ic) throws SQLException,
+ UnsupportedCharsetException, CharacterCodingException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbcas_ASSvc_StopSrvr_ASParamError_exn_:
+ case odbcas_ASSvc_StopSrvr_SrvrNotFound_exn_:
+ case odbcas_ASSvc_StopSrvr_ProcessStopError_exn_:
+ case odbcas_ASSvc_StopSrvr_SrvrInUseByAnotherClient_exn_:
+ ErrorText = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ErrorText);
+ case odbcas_ASSvc_StopSrvr_ASNotAvailable_exn_:
+ ErrorText = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_dcs_srvr_not_available", ErrorText);
+
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "unknown_error", null);
+ } // end switch
+ } // end extractFromByteArray
+} // end odbc_Dcs_StopSrvr_exc_
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Close_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Close_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Close_exc_.java
new file mode 100644
index 0000000..619bece
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Close_exc_.java
@@ -0,0 +1,69 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_Close_exc_ {
+ int exception_nr;
+ int exception_detail;
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+
+ String clientErrorText = null;
+
+ static final int odbc_SQLSvc_Close_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_Close_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_Close_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_Close_TransactionError_exn_ = 4;
+
+ // -------------------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buf, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buf.extractInt();
+ exception_detail = buf.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_Close_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buf, ic);
+ break;
+ case odbc_SQLSvc_Close_ParamError_exn_:
+ ParamError = ic.decodeBytes(buf.extractString(), 1);
+ ;
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_Close_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_Close_TransactionError_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_transaction_error", temp1, addr);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_EndTransaction_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_EndTransaction_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_EndTransaction_exc_.java
new file mode 100644
index 0000000..f46d161
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_EndTransaction_exc_.java
@@ -0,0 +1,87 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_EndTransaction_exc_ {
+ int exception_nr;
+ int exception_detail;
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+
+ //
+ // From odbc_cl.h
+ //
+ // struct odbc_SQLSvc_EndTransaction_exc_ {
+ // size_int exception_nr;
+ // size_int exception_detail;
+ // union {
+ // odbc_SQLSvc_ParamError ParamError;
+ // odbc_SQLSvc_SQLError SQLError;
+ // } u;
+ // };
+
+ String clientErrorText = null;
+
+ //
+ // Exception number constants for
+ // operation 'odbc_SQLSvc_EndTransaction'
+ //
+
+ static final int odbc_SQLSvc_EndTransaction_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_EndTransaction_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_EndTransaction_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_EndTransaction_SQLInvalidHandle_exn_ = 4;
+ static final int odbc_SQLSvc_EndTransaction_TransactionError_exn_ = 5;
+
+ // ----------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buffer1, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_EndTransaction_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buffer1, ic);
+ break;
+ case odbc_SQLSvc_EndTransaction_ParamError_exn_:
+ ParamError = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_EndTransaction_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_EndTransaction_SQLInvalidHandle_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_transaction_error", temp1, addr);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ } // end switch
+ } // end extractFromByteArray
+
+} // end class odbc_SQLSvc_EndTransaction_exc_
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Execute_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Execute_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Execute_exc_.java
new file mode 100644
index 0000000..ebf444e
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Execute_exc_.java
@@ -0,0 +1,89 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_Execute_exc_ {
+ int exception_nr;
+ int exception_detail;
+
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+ ERROR_DESC_LIST_def SQLRetryCompile;
+ int SQLQueryCancelled;
+
+ //
+ // Taken from odbc_cl.h
+ // Exception number constants for
+ // operation 'odbc_SQLSvc_ExecuteRowset'
+ //
+ static final int odbc_SQLSvc_Execute_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_Execute_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_Execute_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_Execute_SQLInvalidHandle_exn_ = 4;
+ static final int odbc_SQLSvc_ExecuteSQLNeedData_exn_ = 5;
+ static final int odbc_SQLSvc_Execute_SQLRetryCompile_exn_ = 6;
+ static final int odbc_SQLSvc_Execute_SQLStillExecuting_exn_ = 7;
+ static final int odbc_SQLSvc_Execute_SQLQueryCancelled_exn_ = 8;
+ static final int odbc_SQLSvc_Execute_TransactionError_exn_ = 9;
+
+ odbc_SQLSvc_Execute_exc_() {
+ }
+
+ void extractFromByteArray(LogicalByteArray buf, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buf.extractInt();
+ exception_detail = buf.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_Execute_SQLStillExecuting_exn_:
+ break;
+ case odbc_SQLSvc_Execute_SQLQueryCancelled_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_s1_008", null);
+ case odbc_SQLSvc_Execute_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buf, ic);
+ break;
+ case odbc_SQLSvc_Execute_SQLRetryCompile_exn_:
+ SQLRetryCompile = new ERROR_DESC_LIST_def();
+ SQLRetryCompile.extractFromByteArray(buf, ic);
+ break;
+ case odbc_SQLSvc_Execute_ParamError_exn_:
+ ParamError = ic.decodeBytes(buf.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_Execute_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_Execute_TransactionError_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_transaction_error", temp1, addr);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Fetch_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Fetch_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Fetch_exc_.java
new file mode 100644
index 0000000..b125b5d
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Fetch_exc_.java
@@ -0,0 +1,87 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_Fetch_exc_ {
+ int exception_nr;
+ int exception_detail;
+
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+ int SQLQueryCancelled;
+
+ //
+ // Taken from odbc_cl.h
+ // Exception number constants for
+ // operation 'odbc_SQLSvc_Fetch'
+ //
+ static final int odbc_SQLSvc_Fetch_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_Fetch_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_Fetch_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_Fetch_SQLInvalidHandle_exn_ = 4;
+ static final int odbc_SQLSvc_Fetch_SQLNoDataFound_exn_ = 5;
+ static final int odbc_SQLSvc_Fetch_SQLStillExecuting_exn_ = 6;
+ static final int odbc_SQLSvc_Fetch_SQLQueryCancelled_exn_ = 7;
+ static final int odbc_SQLSvc_Fetch_TransactionError_exn_ = 8;
+
+ odbc_SQLSvc_Fetch_exc_() {
+ // Do nothing constructor
+ }
+
+ void extractFromByteArray(LogicalByteArray buffer1, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_Fetch_SQLStillExecuting_exn_:
+ break;
+ case odbc_SQLSvc_Fetch_SQLNoDataFound_exn_:
+ break;
+ case odbc_SQLSvc_Fetch_SQLQueryCancelled_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_s1_008", null);
+ case odbc_SQLSvc_Fetch_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buffer1, ic);
+ break;
+ case odbc_SQLSvc_Fetch_ParamError_exn_:
+ ParamError = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_Fetch_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_Fetch_TransactionError_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_transaction_error", temp1, addr);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ } // end extractFromByteArray
+
+} // end odbc_SQLSvc_Fetch_exc_
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_GetSQLCatalogs_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_GetSQLCatalogs_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_GetSQLCatalogs_exc_.java
new file mode 100644
index 0000000..c48c67f
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_GetSQLCatalogs_exc_.java
@@ -0,0 +1,100 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_GetSQLCatalogs_exc_ {
+
+ // From odbc_cl.h
+ //
+ // struct odbc_SQLSvc_GetSQLCatalogs_exc_
+ // {
+ // size_int exception_nr;
+ // size_int exception_detail;
+ // union {
+ // odbc_SQLSvc_ParamError ParamError;
+ // odbc_SQLSvc_SQLError SQLError;
+ // } u;
+ // };
+
+ int exception_nr;
+ int exception_detail;
+
+ //
+ // The third element is special when it is stored in
+ // the buffer. It may be:
+ //
+ // an offset to a character array (ParamError)
+ // an offset to an odbc_SQLSvc_SQLError (SQLError)
+ // or it may be an integer (SQLQueryCancelled).
+ //
+
+ int p3Index;
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+ int SQLQueryCancelled;
+
+ //
+ // Taken from odbc_cl.h
+ // Exception number constants for
+ // operation 'odbc_SQLSvc_GetSQLCatalogs'
+ //
+ static final int odbc_SQLSvc_GetSQLCatalogs_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_GetSQLCatalogs_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_GetSQLCatalogs_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_GetSQLCatalogs_SQLInvalidHandle_exn_ = 4;
+
+ odbc_SQLSvc_GetSQLCatalogs_exc_() {
+ // Do nothing constructor
+ }
+
+ void extractFromByteArray(LogicalByteArray buffer1, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_GetSQLCatalogs_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buffer1, ic);
+ break;
+ case odbc_SQLSvc_GetSQLCatalogs_ParamError_exn_:
+ ParamError = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_GetSQLCatalogs_SQLInvalidHandle_exn_:
+ break;
+ case odbc_SQLSvc_GetSQLCatalogs_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ } // end extractFromByteArray
+
+} // end odbc_SQLSvc_GetSQLCatalogs_exc_
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_InitializeDialogue_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_InitializeDialogue_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_InitializeDialogue_exc_.java
new file mode 100644
index 0000000..0488eef
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_InitializeDialogue_exc_.java
@@ -0,0 +1,76 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_InitializeDialogue_exc_ {
+ int exception_nr;
+ int exception_detail;
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+ ERROR_DESC_LIST_def InvalidUser;
+
+ String clientErrorText;
+
+ static final int odbc_SQLSvc_InitializeDialogue_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_InitializeDialogue_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_InitializeDialogue_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_InitializeDialogue_SQLInvalidHandle_exn_ = 4;
+ static final int odbc_SQLSvc_InitializeDialogue_SQLNeedData_exn_ = 5;
+ static final int odbc_SQLSvc_InitializeDialogue_InvalidUser_exn_ = 6;
+
+ static final int SQL_PASSWORD_EXPIRING = 8857;
+ static final int SQL_PASSWORD_GRACEPERIOD = 8837;
+
+ // ----------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buf, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buf.extractInt();
+ exception_detail = buf.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_InitializeDialogue_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buf, ic);
+ break;
+ case odbc_SQLSvc_InitializeDialogue_InvalidUser_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_28_000", null);
+ case odbc_SQLSvc_InitializeDialogue_ParamError_exn_:
+ ParamError = ic.decodeBytes(buf.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_InitializeDialogue_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+
+ default:
+ clientErrorText = "unknown_initialize_dialogue_reply_error";
+ break;
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Prepare_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Prepare_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Prepare_exc_.java
new file mode 100644
index 0000000..62d056a
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_Prepare_exc_.java
@@ -0,0 +1,68 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_Prepare_exc_ {
+ int returnCode;
+ String sqlError;
+ int rowsAffected;
+ int outValuesFormat;
+ byte[] outValues;
+
+ static final int odbc_SQLSvc_Prepare_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_Prepare_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_Prepare_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_Prepare_SQLStillExecuting_exn_ = 4;
+ static final int odbc_SQLSvc_Prepare_SQLQueryCancelled_exn_ = 5;
+ static final int odbc_SQLSvc_Prepare_TransactionError_exn_ = 6;
+
+ void extractFromByteArray(LogicalByteArray buf, String addr, InterfaceConnection ic) throws SQLException,
+ UnsupportedCharsetException, CharacterCodingException {
+ returnCode = buf.extractInt();
+
+ String temp0 = Integer.toString(returnCode);
+
+ switch (returnCode) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_Prepare_SQLStillExecuting_exn_:
+ break;
+ case odbc_SQLSvc_Prepare_SQLQueryCancelled_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_s1_008", null);
+ case odbc_SQLSvc_Prepare_SQLError_exn_:
+ break;
+ case odbc_SQLSvc_Prepare_ParamError_exn_:
+ sqlError = ic.decodeBytes(buf.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", sqlError, addr);
+ case odbc_SQLSvc_Prepare_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_Prepare_TransactionError_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_transaction_error", temp0, addr);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_SetConnectionOption_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_SetConnectionOption_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_SetConnectionOption_exc_.java
new file mode 100644
index 0000000..192e527
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_SetConnectionOption_exc_.java
@@ -0,0 +1,70 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_SetConnectionOption_exc_ {
+ int exception_nr;
+ int exception_detail;
+ String ParamError;
+ SQLWarningOrError[] errorList;
+ ERROR_DESC_LIST_def SQLError;
+
+ static final int odbc_SQLSvc_SetConnectionOption_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_SetConnectionOption_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_SetConnectionOption_SQLError_exn_ = 3;
+ static final int odbc_SQLSvc_SetConnectionOption_SQLInvalidHandle_exn_ = 4;
+
+ // ----------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buf, String addr, InterfaceConnection ic) throws SQLException,
+ UnsupportedCharsetException, CharacterCodingException {
+ exception_nr = buf.extractInt();
+ exception_detail = buf.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_SetConnectionOption_SQLError_exn_:
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buf, ic);
+ HPT4Messages.throwSQLException(ic.t4props_, SQLError);
+ case odbc_SQLSvc_SetConnectionOption_ParamError_exn_:
+ ParamError = ic.decodeBytes(buf.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_SetConnectionOption_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ case odbc_SQLSvc_SetConnectionOption_SQLInvalidHandle_exn_:
+ // SQLInvalidHandle
+ // throw HPT4Messages.createSQLException(null, locale, "ids_08_s01",
+ // null);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "autocommit_txn_in_progress", null);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_TerminateDialogue_exc_.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_TerminateDialogue_exc_.java b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_TerminateDialogue_exc_.java
new file mode 100644
index 0000000..6242b6e
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/odbc_SQLSvc_TerminateDialogue_exc_.java
@@ -0,0 +1,66 @@
+// @@@ 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.jdbc.t4;
+
+import java.nio.charset.CharacterCodingException;
+import java.nio.charset.UnsupportedCharsetException;
+import java.sql.SQLException;
+
+class odbc_SQLSvc_TerminateDialogue_exc_ {
+ int exception_nr;
+ int exception_detail;
+ String ParamError;
+ ERROR_DESC_LIST_def SQLError;
+
+ static final int odbc_SQLSvc_TerminateDialogue_ParamError_exn_ = 1;
+ static final int odbc_SQLSvc_TerminateDialogue_InvalidConnection_exn_ = 2;
+ static final int odbc_SQLSvc_TerminateDialogue_SQLError_exn_ = 3;
+
+ // ----------------------------------------------------------
+ void extractFromByteArray(LogicalByteArray buffer1, String addr, InterfaceConnection ic)
+ throws CharacterCodingException, UnsupportedCharsetException, SQLException {
+ exception_nr = buffer1.extractInt();
+ exception_detail = buffer1.extractInt();
+
+ String temp0 = Integer.toString(exception_nr);
+ String temp1 = Integer.toString(exception_detail);
+
+ switch (exception_nr) {
+ case TRANSPORT.CEE_SUCCESS:
+ break;
+ case odbc_SQLSvc_TerminateDialogue_SQLError_exn_:
+ if (exception_detail == 25000) {
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_25_000", null);
+ }
+ SQLError = new ERROR_DESC_LIST_def();
+ SQLError.extractFromByteArray(buffer1, ic);
+ break;
+ case odbc_SQLSvc_TerminateDialogue_ParamError_exn_:
+ ParamError = ic.decodeBytes(buffer1.extractString(), 1);
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_program_error", ParamError, addr);
+ case odbc_SQLSvc_TerminateDialogue_InvalidConnection_exn_:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_08_s01", null);
+ default:
+ throw HPT4Messages.createSQLException(null, ic.getLocale(), "ids_unknown_reply_error", temp0, temp1);
+ }
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbcT4/src/main/java/secClient.properties
----------------------------------------------------------------------
diff --git a/core/conn/jdbcT4/src/main/java/secClient.properties b/core/conn/jdbcT4/src/main/java/secClient.properties
new file mode 100644
index 0000000..4b71fa2
--- /dev/null
+++ b/core/conn/jdbcT4/src/main/java/secClient.properties
@@ -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 @@@
+#
+#**********************************************************************/
+
+#Java Security Client error messages
+
+# Make sure the file SecClientMsgKeys.java is also updated if a new error
+# message is added to this file
+
+ERR_RETRIEVE_KEY_FROM_FILE = 29701 *** ERROR[29701] failed to retrieve the public key from the certificate file {0}.
+SESSION_KEY_GENERATION_FAILED = 29702 *** ERROR[29702] Internal error: Session key generation failed.
+INPUT_PARAMETER_IS_NULL = 29703 *** ERROR[29703] Internal error: The input parameter {0} is null.
+PWD_LENGTH_TOO_LONG = 29704 *** ERROR[29704] The password was too long.
+ENCRYPTION_FAILED = 29705 *** ERROR[29705] Internal error: Failed to encrypt the password.
+HMAC_FAILED = 29706 *** ERROR[29706] Internal error: Failed to create the keyed-Hash Message Authentication Code.
+PUBKEY_LENGTH_IS_ZERO = 29707 *** ERROR[29707] Internal error: The public key length was zero.
+ERR_CREATE_SYMMETRIC_KEY = 29708 *** ERROR[29708] Internal error: Symmetric key creation failed.
+ERR_READ_CERT_FILE = 29709 *** ERROR[29709] Error reading the certificate file {0}.
+FAILED_GENERATE_RANDOM_NUM = 29710 *** ERROR[29710] Internal error: Random number generation failed.
+CIPHER_TEXT_LEN_NOT_EQUAL_KEY_LEN = 29711 *** ERROR[29711] Internal error: The length of the cipher text was not equal to the length of the public key.
+BAD_MESSAGE_DIGEST_LEN = 29712 *** ERROR[29712] Internal error: The length of the HMAC message was less than the expected length.
+FILE_NOTFOUND = 29713 *** ERROR[29713] Certificate file {0} is not found.
+DATA_ENCRYPTION_FAILED = 29714 *** ERROR[29714] Internal error: Failed to encrypt the data.
+DECRYPTION_FAILED = 29715 *** ERROR[29715] Internal error: Failed to decrypt the password.
+ERR_WRITE_CERT_FILE = 29716 *** ERROR[29716] Error writing to the certificate file {0}.
+GET_LOCAL_HOST_NAME_FAILED = 29717 *** ERROR[29717] Internal error: Error getting the name of the local host.
+BAD_TOKEN_LEN = 29718 *** ERROR[29718] Internal error: The length of the token was not equal to the expected length.
+INCORRECT_TOKEN_FORMAT = 29719 *** ERROR[29719] Internal error: Unexpected token format.
+HOME_ENVIRONMENT_VAR_IS_NULL = 29720 *** ERROR[29720] No HOME environment variables are set on the system.
+FILE_CORRUPTION = 29721 *** ERROR[29721] The certificate file {0} is corrupted.
+FAILED_BUILDING_PWDKEY = 29722 *** ERROR[29722] Internal error: Error building the password key.
+DIR_NOTFOUND = 29723 *** ERROR[29723] Directory {0} is not found.
+ERR_OPEN_INPUT_FILE = 29729 *** ERROR[29729] Failed to open the certificate file {0}.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/CallableStatementSample/CallableStatementSample.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/CallableStatementSample/CallableStatementSample.java b/core/conn/jdbc_type4/samples/CallableStatementSample/CallableStatementSample.java
deleted file mode 100755
index d96864d..0000000
--- a/core/conn/jdbc_type4/samples/CallableStatementSample/CallableStatementSample.java
+++ /dev/null
@@ -1,83 +0,0 @@
-// @@@ 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 @@@
-import common.*;
-
-import java.sql.*;
-public class CallableStatementSample
-{
- public static void main(String args[]) throws Exception
- {
- try
- {
- Connection conn = sampleUtils.getPropertiesConnection();
- Statement stmt = conn.createStatement();
-
- try
- {
- String st = "drop procedure CallableStatementSample";
- try {
- stmt.executeUpdate(st);
- } catch (Exception e) {}
-
- st = "drop library qaspj";
- try {
- stmt.executeUpdate(st);
- } catch (Exception e) {}
-
-
- String path = System.getProperty("serverJarPath");
-
- st = "create library qaspj file '" + path + "/qaspj.jar'";
- stmt.executeUpdate(st);
-
- st = "create procedure CallableStatementSample(out OUT_PARAM INTEGER) EXTERNAL NAME 'IntegerSPJ.Integer_Proc(int[])' LANGUAGE JAVA PARAMETER STYLE JAVA NO ISOLATE LIBRARY QASPJ";
- stmt.executeUpdate(st);
- stmt.close();
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- System.exit(0);
- }
-
-
- // get the CallableStatement object
- CallableStatement cstmt = conn.prepareCall("{call CallableStatementSample(?)}");
- //System.out.println("The Callable Statement " + cstmt);
-
- //register the output parameters
- cstmt.registerOutParameter(1, java.sql.Types.VARCHAR);
-
- //execute the procedure
- cstmt.execute();
-
- //invoke getInt method
- int nRetVal = cstmt.getInt(1);
-
- System.out.println("Out parameter is " + cstmt.getInt(1));
- }
- catch(Exception ex)
- {
- System.err.println("Unexpected Exception" + ex.getMessage());
- throw new Exception("Call to getWarnings is Failed!");
- }
- }
-}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/CallableStatementSample/IntegerSPJ.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/CallableStatementSample/IntegerSPJ.java b/core/conn/jdbc_type4/samples/CallableStatementSample/IntegerSPJ.java
deleted file mode 100755
index 1b64ee9..0000000
--- a/core/conn/jdbc_type4/samples/CallableStatementSample/IntegerSPJ.java
+++ /dev/null
@@ -1,28 +0,0 @@
-// @@@ 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 @@@
-public class IntegerSPJ
-{
- public static void Integer_Proc (int[] out_param)
- {
-
- out_param[0] = 100;
- }
-}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/CallableStatementSample/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/CallableStatementSample/README b/core/conn/jdbc_type4/samples/CallableStatementSample/README
deleted file mode 100755
index 3fdfa2b..0000000
--- a/core/conn/jdbc_type4/samples/CallableStatementSample/README
+++ /dev/null
@@ -1,42 +0,0 @@
-This sample demonstrates the invocation of a stored procedure in Java (SPJ).
-
-
-Statement
-===========================================
- "/tmp" is a server-side path where the SPJ jar files are located.
-
-
-Generate the jar file by running build.xml, which is located in the samples directory.
-===========================================
- ant build.xml
-
-Copy the jar file to the system where your instance is running.
-===========================================
- cp samples/target/qaspj.jar /tmp
-Note:
- 1.The sample will create and drop the SPJ via the CREATE/DROP PROCEDURE statement by indirectly using qaspj.jar.
- 2.The jar file must be copied to all nodes in a cluster environment.
-
-Compiling the Java files
-===========================================
- On Windows Platform:
- cd samples\CallableStatementSample
- %JAVA_HOME%\bin\javac -classpath ..\..\lib\jdbcT4.jar *.java ..\common\*.java
- On Linux:
- cd samples/CallableStatementSample
- $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4.jar *.java ../common/*.java
-Note: Make sure there are no compilation errors displayed on the screen.
-
-Executing CallableStatementSample
-===========================================
- On Windows Platform:
- cd samples\CallableStatementSample
- %JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties -DserverJarPath=/tmp CallableStatementSample
- On Linux:
- cd samples/CallableStatementSample
- $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties -DserverJarPath=/tmp CallableStatementSample
-
- A successful execution of the sample will produce output similar to the following:
- <DATE, TIME> common.sampleUtils getPropertiesConnection
- INFO: DriverManager.getConnection(url, props) passed
- Out parameter is 100
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/DBMetaSample/DBMetaSample.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/DBMetaSample/DBMetaSample.java b/core/conn/jdbc_type4/samples/DBMetaSample/DBMetaSample.java
deleted file mode 100755
index 8f0a2b7..0000000
--- a/core/conn/jdbc_type4/samples/DBMetaSample/DBMetaSample.java
+++ /dev/null
@@ -1,132 +0,0 @@
-// @@@ 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 @@@
-import common.*;
-
-import java.sql.*;
-import java.math.BigDecimal;
-
-public class DBMetaSample
-{
- public static void main(String args[])
- {
-
- Connection connection;
- Statement stmt;
- PreparedStatement pStmt;
- ResultSet rs;
- DatabaseMetaData dbMeta;
- int rowNo;
- String table = "DBMETASAMPLE";
-
- try
- {
- connection = sampleUtils.getPropertiesConnection();
- sampleUtils.dropTable(connection, table);
- sampleUtils.initialData(connection, table);
- sampleUtils.initialCurrentData(connection, table);
-
-
- System.out.println("");
-
-
- for (int i = 0; i < 6; i++)
- {
- switch (i)
- {
- case 0:
- System.out.println("");
- System.out.println("getTypeInfo() ");
- dbMeta = connection.getMetaData();
- rs = dbMeta.getTypeInfo();
- break;
- case 2:
- System.out.println("");
- System.out.println("getCatalogs()");
- dbMeta = connection.getMetaData();
- rs = dbMeta.getCatalogs();
- break;
- case 3:
- System.out.println("");
- System.out.println("getTables() ");
- dbMeta = connection.getMetaData();
- rs = dbMeta.getTables(connection.getCatalog(), sampleUtils.props.getProperty("schema"), "DBMETASAMPLE", null);
- break;
- case 4:
- System.out.println("");
- System.out.println("getColumns()");
- dbMeta = connection.getMetaData();
- rs = dbMeta.getColumns(connection.getCatalog(), sampleUtils.props.getProperty("schema"), "DBMETASAMPLE", "C1");
- break;
- case 5:
- System.out.println("");
- System.out.println("getProcedures()");
- dbMeta = connection.getMetaData();
- rs = dbMeta.getProcedures(connection.getCatalog(), sampleUtils.props.getProperty("schema"), "Integer_Proc");
- break;
- default:
- rs = null;
- continue;
- }
-
- ResultSetMetaData rsMD = rs.getMetaData();
- System.out.println("");
- System.out.println("Printing ResultSetMetaData ...");
- System.out.println("No. of Columns " + rsMD.getColumnCount());
- for (int j = 1; j <= rsMD.getColumnCount(); j++)
- {
- System.out.println("Column " + j + " Data Type: " + rsMD.getColumnTypeName(j) + " Name: " + rsMD.getColumnName(j));
- }
- System.out.println("");
- System.out.println("Fetching rows...");
- rowNo = 0;
- while (rs.next())
- {
- rowNo++;
- System.out.println("");
- System.out.println("Printing Row " + rowNo + " using getString(), getObject()");
- for (int j=1; j <= rsMD.getColumnCount(); j++)
- {
- System.out.println("Column " + j + " - " + rs.getString(j) + "," + rs.getObject(j));
- }
-
- }
- System.out.println("");
- System.out.println("End of Data");
- rs.close();
- }
-
- sampleUtils.dropTable(connection, table);
- connection.close();
- }
- catch (SQLException e)
- {
- SQLException nextException;
-
- nextException = e;
- do
- {
- System.out.println(nextException.getMessage());
- System.out.println("SQLState " + nextException.getSQLState());
- System.out.println("Error Code " + nextException.getErrorCode());
- } while ((nextException = nextException.getNextException()) != null);
- }
- }
-}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/DBMetaSample/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/DBMetaSample/README b/core/conn/jdbc_type4/samples/DBMetaSample/README
deleted file mode 100755
index 77dc3a3..0000000
--- a/core/conn/jdbc_type4/samples/DBMetaSample/README
+++ /dev/null
@@ -1,904 +0,0 @@
-Compiling the Java files
-========================
-On Windows Platform:
-%JAVA_HOME%\bin\javac -classpath ..\..\lib\jdbcT4.jar *.java ..\common\*.java
-
-On Linux:
-$JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4.jar *.java ../common/*.java
-
-Note: Make sure there are no compilation errors displayed on
- the screen.
-
-
-Executing DBMetaSample
-======================
-On Windows Platform:
-%JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties DBMetaSample
-
-On Linux:
-$JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties DBMetaSample
-
-
-Output of the execution would look like:
-========================================
-<DATE, TIME> common.sampleUtils getPropertiesConnection
-INFO: DriverManager.getConnection(url, props) passed
-
-Inserting TimeStamp
-
-INFO: DriverManager.getConnection(url, props) passed
-
-Inserting TimeStamp
-
-
-getTypeInfo()
-
-Printing ResultSetMetaData ...
-No. of Columns 19
-Column 1 Data Type: VARCHAR Name: TYPE_NAME
-Column 2 Data Type: SMALLINT Name: DATA_TYPE
-Column 3 Data Type: INTEGER Name: PRECISION
-Column 4 Data Type: VARCHAR Name: LITERAL_PREFIX
-Column 5 Data Type: VARCHAR Name: LITERAL_SUFFIX
-Column 6 Data Type: VARCHAR Name: CREATE_PARAMS
-Column 7 Data Type: SMALLINT Name: NULLABLE
-Column 8 Data Type: SMALLINT Name: CASE_SENSITIVE
-Column 9 Data Type: SMALLINT Name: SEARCHABLE
-Column 10 Data Type: SMALLINT Name: UNSIGNED_ATTRIBUTE
-Column 11 Data Type: SMALLINT Name: FIXED_PREC_SCALE
-Column 12 Data Type: SMALLINT Name: AUTO_INCREMENT
-Column 13 Data Type: VARCHAR Name: LOCAL_TYPE_NAME
-Column 14 Data Type: SMALLINT Name: MINIMUM_SCALE
-Column 15 Data Type: SMALLINT Name: MAXIMUM_SCALE
-Column 16 Data Type: SMALLINT Name: SQL_DATA_TYPE
-Column 17 Data Type: SMALLINT Name: SQL_DATETIME_SUB
-Column 18 Data Type: SMALLINT Name: NUM_PREC_RADIX
-Column 19 Data Type: SMALLINT Name: INTERVAL_PRECISION
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - BIGINT,BIGINT
-Column 2 - -5,-5
-Column 3 - 19,19
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - LARGEINT,LARGEINT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - -402,-402
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 2 using getString(), getObject()
-Column 1 - BIGINT SIGNED,BIGINT SIGNED
-Column 2 - -5,-5
-Column 3 - 19,19
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - LARGEINT,LARGEINT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - -402,-402
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 3 using getString(), getObject()
-Column 1 - CHAR,CHAR
-Column 2 - 1,1
-Column 3 - 32000,32000
-Column 4 - ','
-Column 5 - ','
-Column 6 - max length,max length
-Column 7 - 1,1
-Column 8 - 1,1
-Column 9 - 3,3
-Column 10 - null,null
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - CHARACTER,CHARACTER
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 1,1
-Column 17 - null,null
-Column 18 - null,null
-Column 19 - null,null
-
-Printing Row 4 using getString(), getObject()
-Column 1 - NUMERIC,NUMERIC
-Column 2 - 2,2
-Column 3 - 128,128
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - NUMERIC,NUMERIC
-Column 14 - 0,0
-Column 15 - 128,128
-Column 16 - 2,2
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 5 using getString(), getObject()
-Column 1 - NUMERIC SIGNED,NUMERIC SIGNED
-Column 2 - 2,2
-Column 3 - 128,128
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - NUMERIC,NUMERIC
-Column 14 - 0,0
-Column 15 - 128,128
-Column 16 - 2,2
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 6 using getString(), getObject()
-Column 1 - NUMERIC UNSIGNED,NUMERIC UNSIGNED
-Column 2 - 2,2
-Column 3 - 128,128
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 1,1
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - NUMERIC,NUMERIC
-Column 14 - 0,0
-Column 15 - 128,128
-Column 16 - 2,2
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 7 using getString(), getObject()
-Column 1 - DECIMAL,DECIMAL
-Column 2 - 3,3
-Column 3 - 18,18
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - DECIMAL,DECIMAL
-Column 14 - 0,0
-Column 15 - 18,18
-Column 16 - 3,3
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 8 using getString(), getObject()
-Column 1 - DECIMAL SIGNED,DECIMAL SIGNED
-Column 2 - 3,3
-Column 3 - 18,18
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - DECIMAL,DECIMAL
-Column 14 - 0,0
-Column 15 - 18,18
-Column 16 - 3,3
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 9 using getString(), getObject()
-Column 1 - DECIMAL UNSIGNED,DECIMAL UNSIGNED
-Column 2 - 3,3
-Column 3 - 18,18
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - precision,scale,precision,scale
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 1,1
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - DECIMAL,DECIMAL
-Column 14 - 0,0
-Column 15 - 18,18
-Column 16 - -301,-301
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 10 using getString(), getObject()
-Column 1 - INTEGER,INTEGER
-Column 2 - 4,4
-Column 3 - 10,10
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - INTEGER,INTEGER
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 4,4
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 11 using getString(), getObject()
-Column 1 - INTEGER SIGNED,INTEGER SIGNED
-Column 2 - 4,4
-Column 3 - 10,10
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - INTEGER,INTEGER
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 4,4
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 12 using getString(), getObject()
-Column 1 - INTEGER UNSIGNED,INTEGER UNSIGNED
-Column 2 - 4,4
-Column 3 - 10,10
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 1,1
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - INTEGER,INTEGER
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - -401,-401
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 13 using getString(), getObject()
-Column 1 - SMALLINT,SMALLINT
-Column 2 - 5,5
-Column 3 - 5,5
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - SMALLINT,SMALLINT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 5,5
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 14 using getString(), getObject()
-Column 1 - SMALLINT SIGNED,SMALLINT SIGNED
-Column 2 - 5,5
-Column 3 - 5,5
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - SMALLINT,SMALLINT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 5,5
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 15 using getString(), getObject()
-Column 1 - SMALLINT UNSIGNED,SMALLINT UNSIGNED
-Column 2 - 5,5
-Column 3 - 5,5
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 1,1
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - SMALLINT,SMALLINT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - -502,-502
-Column 17 - null,null
-Column 18 - 10,10
-Column 19 - null,null
-
-Printing Row 16 using getString(), getObject()
-Column 1 - FLOAT,FLOAT
-Column 2 - 6,6
-Column 3 - 15,15
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - FLOAT,FLOAT
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 6,6
-Column 17 - null,null
-Column 18 - 2,2
-Column 19 - null,null
-
-Printing Row 17 using getString(), getObject()
-Column 1 - REAL,REAL
-Column 2 - 7,7
-Column 3 - 7,7
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - REAL,REAL
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 7,7
-Column 17 - null,null
-Column 18 - 2,2
-Column 19 - null,null
-
-Printing Row 18 using getString(), getObject()
-Column 1 - DOUBLE PRECISION,DOUBLE PRECISION
-Column 2 - 8,8
-Column 3 - 15,15
-Column 4 - null,null
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - 0,0
-Column 13 - DOUBLE,DOUBLE
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 8,8
-Column 17 - null,null
-Column 18 - 2,2
-Column 19 - null,null
-
-Printing Row 19 using getString(), getObject()
-Column 1 - VARCHAR,VARCHAR
-Column 2 - 12,12
-Column 3 - 32000,32000
-Column 4 - ','
-Column 5 - ','
-Column 6 - max length,max length
-Column 7 - 1,1
-Column 8 - 1,1
-Column 9 - 3,3
-Column 10 - null,null
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - VARCHAR,VARCHAR
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 12,12
-Column 17 - null,null
-Column 18 - null,null
-Column 19 - null,null
-
-Printing Row 20 using getString(), getObject()
-Column 1 - DATE,DATE
-Column 2 - 91,91
-Column 3 - 10,10
-Column 4 - {d ',{d '
-Column 5 - '},'}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - null,null
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - DATE,DATE
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 9,9
-Column 17 - 1,1
-Column 18 - null,null
-Column 19 - null,null
-
-Printing Row 21 using getString(), getObject()
-Column 1 - TIME,TIME
-Column 2 - 92,92
-Column 3 - 8,8
-Column 4 - {t ',{t '
-Column 5 - '},'}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - null,null
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - TIME,TIME
-Column 14 - null,null
-Column 15 - null,null
-Column 16 - 9,9
-Column 17 - 2,2
-Column 18 - null,null
-Column 19 - null,null
-
-Printing Row 22 using getString(), getObject()
-Column 1 - TIMESTAMP,TIMESTAMP
-Column 2 - 93,93
-Column 3 - 26,26
-Column 4 - {ts ',{ts '
-Column 5 - '},'}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - null,null
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - TIMESTAMP,TIMESTAMP
-Column 14 - 0,0
-Column 15 - 6,6
-Column 16 - 9,9
-Column 17 - 3,3
-Column 18 - null,null
-Column 19 - null,null
-
-Printing Row 23 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 101,101
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' YEAR},' YEAR}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 1,1
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 24 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 102,102
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' MONTH},' MONTH}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 2,2
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 25 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 103,103
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' DAY},' DAY}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 3,3
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 26 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 104,104
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' HOUR},' HOUR}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 4,4
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 27 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 105,105
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' MINUTE},' MINUTE}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 5,5
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 28 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 106,106
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' SECOND},' SECOND}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 6,6
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 29 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 107,107
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' YEAR TO MONTH},' YEAR TO MONTH}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 7,7
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 30 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 108,108
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' DAY TO HOUR},' DAY TO HOUR}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 8,8
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 31 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 109,109
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' DAY TO MINUTE},' DAY TO MINUTE}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 9,9
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 32 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 110,110
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' DAY TO SECOND},' DAY TO SECOND}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 10,10
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 33 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 111,111
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' HOUR TO MINUTE},' HOUR TO MINUTE}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 11,11
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 34 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 112,112
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' HOUR TO SECOND},' HOUR TO SECOND}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 12,12
-Column 18 - null,null
-Column 19 - 2,2
-
-Printing Row 35 using getString(), getObject()
-Column 1 - INTERVAL,INTERVAL
-Column 2 - 113,113
-Column 3 - 0,0
-Column 4 - {INTERVAL ',{INTERVAL '
-Column 5 - ' MINUTE TO SECOND},' MINUTE TO SECOND}
-Column 6 - null,null
-Column 7 - 1,1
-Column 8 - 0,0
-Column 9 - 2,2
-Column 10 - 0,0
-Column 11 - 0,0
-Column 12 - null,null
-Column 13 - INTERVAL,INTERVAL
-Column 14 - 0,0
-Column 15 - 0,0
-Column 16 - 100,100
-Column 17 - 13,13
-Column 18 - null,null
-Column 19 - 2,2
-
-End of Data
-
-getCatalogs()
-
-Printing ResultSetMetaData ...
-No. of Columns 1
-Column 1 Data Type: VARCHAR Name: TABLE_CAT
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - TRAFODION,TRAFODION
-
-End of Data
-
-getTables()
-
-Printing ResultSetMetaData ...
-No. of Columns 10
-Column 1 Data Type: VARCHAR Name: TABLE_CAT
-Column 2 Data Type: VARCHAR Name: TABLE_SCHEM
-Column 3 Data Type: VARCHAR Name: TABLE_NAME
-Column 4 Data Type: VARCHAR Name: TABLE_TYPE
-Column 5 Data Type: VARCHAR Name: REMARKS
-Column 6 Data Type: VARCHAR Name: TYPE_CAT
-Column 7 Data Type: VARCHAR Name: TYPE_SCHEM
-Column 8 Data Type: VARCHAR Name: TYPE_NAME
-Column 9 Data Type: VARCHAR Name: SELF_REFERENCING_COL_NAME
-Column 10 Data Type: VARCHAR Name: REF_GENERATION
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - TRAFODION,TRAFODION
-Column 2 - SEABASE,SEABASE
-Column 3 - DBMETASAMPLE,DBMETASAMPLE
-Column 4 - TABLE,TABLE
-Column 5 - null,null
-Column 6 - null,null
-Column 7 - null,null
-Column 8 - null,null
-Column 9 - null,null
-Column 10 - null,null
-
-End of Data
-
-getColumns()
-
-Printing ResultSetMetaData ...
-No. of Columns 18
-Column 1 Data Type: VARCHAR Name: TABLE_CAT
-Column 2 Data Type: VARCHAR Name: TABLE_SCHEM
-Column 3 Data Type: VARCHAR Name: TABLE_NAME
-Column 4 Data Type: VARCHAR Name: COLUMN_NAME
-Column 5 Data Type: SMALLINT Name: DATA_TYPE
-Column 6 Data Type: VARCHAR Name: TYPE_NAME
-Column 7 Data Type: INTEGER Name: COLUMN_SIZE
-Column 8 Data Type: INTEGER Name: BUFFER_LENGTH
-Column 9 Data Type: SMALLINT Name: DECIMAL_DIGITS
-Column 10 Data Type: SMALLINT Name: NUM_PREC_RADIX
-Column 11 Data Type: SMALLINT Name: NULLABLE
-Column 12 Data Type: VARCHAR Name: REMARKS
-Column 13 Data Type: VARCHAR Name: COLUMN_DEF
-Column 14 Data Type: SMALLINT Name: SQL_DATA_TYPE
-Column 15 Data Type: SMALLINT Name: SQL_DATETIME_SUB
-Column 16 Data Type: INTEGER Name: CHAR_OCTET_LENGTH
-Column 17 Data Type: INTEGER Name: ORDINAL_POSITION
-Column 18 Data Type: VARCHAR Name: IS_NULLABLE
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - TRAFODION,TRAFODION
-Column 2 - SEABASE,SEABASE
-Column 3 - DBMETASAMPLE,DBMETASAMPLE
-Column 4 - C1,C1
-Column 5 - 1,1
-Column 6 - CHAR,CHAR
-Column 7 - 20,20
-Column 8 - 20,20
-Column 9 - 0,0
-Column 10 - null,null
-Column 11 - 2,2
-Column 12 - null,null
-Column 13 - ,
-Column 14 - 1,1
-Column 15 - null,null
-Column 16 - 20,20
-Column 17 - 1,1
-Column 18 - YES,YES
-
-End of Data
-
-getProcedures()
-
-Printing ResultSetMetaData ...
-No. of Columns 8
-Column 1 Data Type: VARCHAR Name: PROCEDURE_CAT
-Column 2 Data Type: VARCHAR Name: PROCEDURE_SCHEM
-Column 3 Data Type: VARCHAR Name: PROCEDURE_NAME
-Column 4 Data Type: SMALLINT Name: NUM_INPUT_PARAMS
-Column 5 Data Type: SMALLINT Name: NUM_OUTPUT_PARAMS
-Column 6 Data Type: SMALLINT Name: NUM_RESULT_SETS
-Column 7 Data Type: VARCHAR Name: REMARKS
-Column 8 Data Type: SMALLINT Name: PROCEDURE_TYPE
-
-Fetching rows...
-
-End of Data
-=======================================================