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:57 UTC
[18/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/jdbc_type4/samples/PreparedStatementSample/PreparedStatementSample.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/PreparedStatementSample/PreparedStatementSample.java b/core/conn/jdbc_type4/samples/PreparedStatementSample/PreparedStatementSample.java
deleted file mode 100755
index b086103..0000000
--- a/core/conn/jdbc_type4/samples/PreparedStatementSample/PreparedStatementSample.java
+++ /dev/null
@@ -1,151 +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 PreparedStatementSample
-{
- public static void main(String args[])
- {
-
- Connection connection;
- Statement stmt;
- PreparedStatement pStmt;
- ResultSet rs;
- DatabaseMetaData dbMeta;
- int rowNo;
- String table = "PreparedStatementSample";
-
- try
- {
- connection = sampleUtils.getPropertiesConnection();
- sampleUtils.dropTable(connection, table);
- sampleUtils.initialData(connection, table);
- sampleUtils.initialCurrentData(connection, table);
-
-
- for (int i = 0; i < 7; i++)
- {
- switch (i)
- {
- case 0:
- System.out.println("");
- System.out.println("Simple Select ");
- stmt = connection.createStatement();
- rs = stmt.executeQuery("select * from " + table);
- break;
- case 1:
- System.out.println("");
- System.out.println("Parameterized Select - CHAR");
- pStmt = connection.prepareStatement("select c1, c2 from " + table + " where c1 = ?");
- pStmt.setString(1, "Selva");
- rs = pStmt.executeQuery();
- break;
- case 2:
- System.out.println("");
- System.out.println("Parameterized Select - INT");
- pStmt = connection.prepareStatement("select c1, c2, c3 from " + table + " where c2 = ? or c2 = ?");
- pStmt.setInt(1, 100);
- pStmt.setInt(2, -100);
- rs = pStmt.executeQuery();
- break;
- case 3:
- System.out.println("");
- System.out.println("Parameterized Select - TIMESTAMP");
- pStmt = connection.prepareStatement("select c1, c2, c3, c10 from " + table + " where c10 = ?");
- pStmt.setTimestamp(1, Timestamp.valueOf("2000-05-06 10:11:12.0"));
- rs = pStmt.executeQuery();
- break;
- case 4:
- System.out.println("");
- System.out.println("Parameterized Select - DECIMAL");
- pStmt = connection.prepareStatement("select c1, c2, c3, c7 from " + table + " where c7 = ? or c7 = ?");
- pStmt.setBigDecimal(1, new BigDecimal("100.12"));
- pStmt.setBigDecimal(2, new BigDecimal("-100.12"));
- rs = pStmt.executeQuery();
- break;
- case 5:
- System.out.println("");
- System.out.println("Parameterized Select - NUMERIC");
- pStmt = connection.prepareStatement("select c1, c2, c3, c6 from " + table + " where c6 = ? or c6 = ?");
- pStmt.setBigDecimal(1, new BigDecimal("100.12"));
- pStmt.setBigDecimal(2, new BigDecimal("-100.12"));
- rs = pStmt.executeQuery();
- break;
- case 6:
- System.out.println("");
- System.out.println("Parameterized Select - DATE");
- pStmt = connection.prepareStatement(
- "select c11, c12 from " + table + " where c8 = ?");
- pStmt.setDate(1, Date.valueOf("2000-05-06"));
- rs = pStmt.executeQuery();
- 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/PreparedStatementSample/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/PreparedStatementSample/README b/core/conn/jdbc_type4/samples/PreparedStatementSample/README
deleted file mode 100755
index 55c7252..0000000
--- a/core/conn/jdbc_type4/samples/PreparedStatementSample/README
+++ /dev/null
@@ -1,232 +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 PreparedStatementSample
-=========================
-On Windows Platform:
-%JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties PreparedStatementSample
-
-On Linux:
-$JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties PreparedStatementSample
-
-
-Output of the execution would look like:
-========================================
-<DATE, TITME> common.sampleUtils getPropertiesConnection
-INFO: DriverManager.getConnection(url, props) passed
-
-Inserting TimeStamp
-
-Simple Select
-
-Printing ResultSetMetaData ...
-No. of Columns 12
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: BIGINT Name: C4
-Column 5 Data Type: VARCHAR Name: C5
-Column 6 Data Type: NUMERIC Name: C6
-Column 7 Data Type: DECIMAL Name: C7
-Column 8 Data Type: DATE Name: C8
-Column 9 Data Type: TIME Name: C9
-Column 10 Data Type: TIMESTAMP Name: C10
-Column 11 Data Type: REAL Name: C11
-Column 12 Data Type: DOUBLE PRECISION Name: C12
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 123456789012,123456789012
-Column 5 - Selva,Selva
-Column 6 - 100.12,100.12
-Column 7 - 100.12,100.12
-Column 8 - 2000-05-06,2000-05-06
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - 100.12,100.12
-Column 12 - 100.12,100.12
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2000-05-16,2000-05-16
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2004-04-14,2004-04-14
-Column 9 - 17:46:02,17:46:02
-Column 10 - 2004-04-14 17:46:02.74,2004-04-14 17:46:02.74
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-End of Data
-
-Parameterized Select - CHAR
-
-Printing ResultSetMetaData ...
-No. of Columns 2
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-
-Fetching rows...
-
-End of Data
-
-Parameterized Select - INT
-
-Printing ResultSetMetaData ...
-No. of Columns 3
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-
-End of Data
-
-Parameterized Select - TIMESTAMP
-
-Printing ResultSetMetaData ...
-No. of Columns 4
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: TIMESTAMP Name: C10
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-
-End of Data
-
-Parameterized Select - DECIMAL
-
-Printing ResultSetMetaData ...
-No. of Columns 4
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: DECIMAL Name: C7
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 100.12,100.12
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -100.12,-100.12
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -100.12,-100.12
-
-End of Data
-
-Parameterized Select - NUMERIC
-
-Printing ResultSetMetaData ...
-No. of Columns 4
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: NUMERIC Name: C6
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 100.12,100.12
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -100.12,-100.12
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -100.12,-100.12
-
-End of Data
-
-Parameterized Select - DATE
-
-Printing ResultSetMetaData ...
-No. of Columns 2
-Column 1 Data Type: REAL Name: C11
-Column 2 Data Type: DOUBLE PRECISION Name: C12
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - 100.12,100.12
-Column 2 - 100.12,100.12
-
-End of Data
-===============================================
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/README b/core/conn/jdbc_type4/samples/README
deleted file mode 100755
index 916c8d2..0000000
--- a/core/conn/jdbc_type4/samples/README
+++ /dev/null
@@ -1,47 +0,0 @@
-This is samples README file.
-
-To setup the enviornment
-========================
- On UNIX platform:
- 1. export JAVA_HOME=<java home on your system>
-
- On WINDOWS platform command windows:
- 1. set JAVA_HOME=<java home on your system>
-
-
-To Configure samples
-====================
- Edit t4jdbc.properties file. Set the following values to your environment.
-
- catalog : SQL catalog - must exist on the database
- Please refer to the SQL documentation on how to create the catalog.
- schema : SQL schema - must exist on the database
- Please refer to the SQL documentation on how to create the schema.
-
- Example of creating catalog/schema:
- >>create catalog mycat;
- >>create schema mycat.myschema;
-
- user : Database user name
- password : Database text password
- url : jdbc:t4jdbc://<Database ip or name>:<port number where DCS is running>/:
-
- Example of a t4jdbc.properties file:
-
- catalog = CAT
- schema = SCH
- url = jdbc:t4jdbc://www.mymachine.net:61234/:
- user = software.john
- password = abcd
-
-
-
-To run the samples
-==================
- Follow the README file instructions in the following directories.
- 1. StatementSample
- 2. PreparedStatementSample
- 3. ResultSetSample
- 4. DBMetaSample
-
- NOTE: All samples create, populate and drop sample tables.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/ResultSetSample/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/ResultSetSample/README b/core/conn/jdbc_type4/samples/ResultSetSample/README
deleted file mode 100755
index 5a1d99e..0000000
--- a/core/conn/jdbc_type4/samples/ResultSetSample/README
+++ /dev/null
@@ -1,91 +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 ResultSetSample
-=========================
-On Windows Platform:
-%JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties ResultSetSample
-
-On Linux:
-$JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties ResultSetSample
-
-
-Output of the execution would look like:
-========================================
-<DATE, TIME> common.sampleUtils getPropertiesConnection
-INFO: DriverManager.getConnection(url, props) passed
-
-Inserting TimeStamp
-
-Simple Select
-
-Printing ResultSetMetaData ...
-No. of Columns 12
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: BIGINT Name: C4
-Column 5 Data Type: VARCHAR Name: C5
-Column 6 Data Type: NUMERIC Name: C6
-Column 7 Data Type: DECIMAL Name: C7
-Column 8 Data Type: DATE Name: C8
-Column 9 Data Type: TIME Name: C9
-Column 10 Data Type: TIMESTAMP Name: C10
-Column 11 Data Type: REAL Name: C11
-Column 12 Data Type: DOUBLE PRECISION Name: C12
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 123456789012,123456789012
-Column 5 - Selva,Selva
-Column 6 - 100.12,100.12
-Column 7 - 100.12,100.12
-Column 8 - 2000-05-06,2000-05-06
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - 100.12,100.12
-Column 12 - 100.12,100.12
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2000-05-16,2000-05-16
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2004-04-14,2004-04-14
-Column 9 - 16:19:47,16:19:47
-Column 10 - 2004-04-14 16:19:47.003,2004-04-14 16:19:47.003
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-End of Data
-========================================
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/ResultSetSample/ResultSetSample.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/ResultSetSample/ResultSetSample.java b/core/conn/jdbc_type4/samples/ResultSetSample/ResultSetSample.java
deleted file mode 100755
index 47b0b4c..0000000
--- a/core/conn/jdbc_type4/samples/ResultSetSample/ResultSetSample.java
+++ /dev/null
@@ -1,104 +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 ResultSetSample
-{
- public static void main(String args[])
- {
-
- Connection connection;
- Statement stmt;
- PreparedStatement pStmt;
- ResultSet rs;
- DatabaseMetaData dbMeta;
- int rowNo;
- String table = "ResultSetSample";
-
- try
- {
- connection = sampleUtils.getPropertiesConnection();
- sampleUtils.dropTable(connection, table);
- sampleUtils.initialData(connection, table);
- sampleUtils.initialCurrentData(connection, table);
-
- for (int i = 0; i < 10; i++)
- {
- switch (i)
- {
- case 0:
- System.out.println("");
- System.out.println("Simple Select ");
- stmt = connection.createStatement();
- rs = stmt.executeQuery("select * from " + table);
- 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/StatementSample/README
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/StatementSample/README b/core/conn/jdbc_type4/samples/StatementSample/README
deleted file mode 100755
index 159f349..0000000
--- a/core/conn/jdbc_type4/samples/StatementSample/README
+++ /dev/null
@@ -1,92 +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 StatementSample
-=========================
-On Windows Platform:
-%JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties StatementSample
-
-On Linux:
-$JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties StatementSample
-
-
-Output of the execution would look like:
-========================================
-
-<DATE, TIME> common.sampleUtils getPropertiesConnection
-INFO: DriverManager.getConnection(url, props) passed
-
-Inserting TimeStamp
-
-Simple Select
-
-Printing ResultSetMetaData ...
-No. of Columns 12
-Column 1 Data Type: CHAR Name: C1
-Column 2 Data Type: SMALLINT Name: C2
-Column 3 Data Type: INTEGER Name: C3
-Column 4 Data Type: BIGINT Name: C4
-Column 5 Data Type: VARCHAR Name: C5
-Column 6 Data Type: NUMERIC Name: C6
-Column 7 Data Type: DECIMAL Name: C7
-Column 8 Data Type: DATE Name: C8
-Column 9 Data Type: TIME Name: C9
-Column 10 Data Type: TIMESTAMP Name: C10
-Column 11 Data Type: REAL Name: C11
-Column 12 Data Type: DOUBLE PRECISION Name: C12
-
-Fetching rows...
-
-Printing Row 1 using getString(), getObject()
-Column 1 - Row1 ,Row1
-Column 2 - 100,100
-Column 3 - 12345678,12345678
-Column 4 - 123456789012,123456789012
-Column 5 - Selva,Selva
-Column 6 - 100.12,100.12
-Column 7 - 100.12,100.12
-Column 8 - 2000-05-06,2000-05-06
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - 100.12,100.12
-Column 12 - 100.12,100.12
-
-Printing Row 2 using getString(), getObject()
-Column 1 - Row2 ,Row2
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2000-05-16,2000-05-16
-Column 9 - 10:11:12,10:11:12
-Column 10 - 2000-05-06 10:11:12.0,2000-05-06 10:11:12.0
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-Printing Row 3 using getString(), getObject()
-Column 1 - TimeStamp ,TimeStamp
-Column 2 - -100,-100
-Column 3 - -12345678,-12345678
-Column 4 - -123456789012,-123456789012
-Column 5 - Selva,Selva
-Column 6 - -100.12,-100.12
-Column 7 - -100.12,-100.12
-Column 8 - 2004-04-14,2004-04-14
-Column 9 - 15:43:36,15:43:36
-Column 10 - 2004-04-14 15:43:36.167,2004-04-14 15:43:36.167
-Column 11 - -100.12,-100.12
-Column 12 - -100.12,-100.12
-
-End of Data
--------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/StatementSample/StatementSample.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/StatementSample/StatementSample.java b/core/conn/jdbc_type4/samples/StatementSample/StatementSample.java
deleted file mode 100755
index 765d9d4..0000000
--- a/core/conn/jdbc_type4/samples/StatementSample/StatementSample.java
+++ /dev/null
@@ -1,104 +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 StatementSample
-{
- public static void main(String args[])
- {
-
- Connection connection;
- Statement stmt;
- PreparedStatement pStmt;
- ResultSet rs;
- DatabaseMetaData dbMeta;
- int rowNo;
- String table = "StatementSample";
-
- try
- {
- connection = sampleUtils.getPropertiesConnection();
- sampleUtils.dropTable(connection, table);
- sampleUtils.initialData(connection, table);
- sampleUtils.initialCurrentData(connection, table);
-
- for (int i = 0; i < 1; i++)
- {
- switch (i)
- {
- case 0:
- System.out.println("");
- System.out.println("Simple Select ");
- stmt = connection.createStatement();
- rs = stmt.executeQuery("select * from " + table);
- 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/build.xml
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/build.xml b/core/conn/jdbc_type4/samples/build.xml
deleted file mode 100644
index 663e2fc..0000000
--- a/core/conn/jdbc_type4/samples/build.xml
+++ /dev/null
@@ -1,44 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-<!-- @@@ 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 @@@ -->
-
-<project name="jdbct4" default="deploy">
- <tstamp>
- <format property="now.timestamp" pattern="yyyy_MM_dd" locale="en" />
- </tstamp>
-
- <target name="init">
- <mkdir dir="target"/>
- <mkdir dir="target/classes"/>
- </target>
-
-
- <target name="deploy" depends="clean,init">
- <javac srcdir="CallableStatementSample" destdir="target/classes" includes="**/IntegerSPJ.java"></javac>
- <jar basedir="target/classes" includes="IntegerSPJ.class" destfile="target/qaspj.jar"></jar>
- </target>
-
- <target name="clean">
- <delete dir="target" deleteonexit="true">
- </delete>
- </target>
-</project>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/common/sampleUtils.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/common/sampleUtils.java b/core/conn/jdbc_type4/samples/common/sampleUtils.java
deleted file mode 100755
index f234d28..0000000
--- a/core/conn/jdbc_type4/samples/common/sampleUtils.java
+++ /dev/null
@@ -1,268 +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 @@@
-package common;
-
-import java.sql.Date;
-import java.sql.Time;
-import java.sql.Timestamp;
-import java.sql.SQLException;
-import java.sql.Statement;
-import java.sql.PreparedStatement;
-import java.sql.Connection;
-import java.sql.DriverManager;
-import java.util.*;
-import java.io.*;
-import java.util.logging.*;
-import java.net.*;
-
-
-public class sampleUtils
-{
- static String url;
- static String usr;
- static String pwd;
- public static Properties props;
-
- //------------------------------------------------------------------------
- static
- {
- try
- {
- String propFile = System.getProperty("t4jdbc.properties");
- if (propFile != null)
- {
- FileInputStream fs = new FileInputStream(new File(propFile));
- props = new Properties();
- props.load(fs);
-
- url = props.getProperty("url");
- usr = props.getProperty("user");
- pwd = props.getProperty("password");
- } else {
- System.out.println("Error: t4jdbc.properties is not set. Exiting.");
- System.exit(0);
- }
- }
- catch (Exception e)
- {
- e.printStackTrace();
- System.out.println(e.getMessage());
- }
-
- try
- {
- Class.forName("org.trafodion.jdbc.t4.T4Driver");
- Logger.global.setLevel(Level.FINEST);
- } catch (Exception e) {
- e.printStackTrace();
- System.out.println(e.getMessage());
- System.exit(0);
- }
- }
-
- //------------------------------------------------------------------------
- static void checkprops() throws SQLException
- {
- if (props == null)
- throw new SQLException ("Error: t4jdbc.properties is null. Exiting.");
- }
-
- //------------------------------------------------------------------------
- public static Connection getUserConnection() throws SQLException
- {
- Connection connection = null;
- checkprops();
-
- Logger.global.log(Level.FINE,"DriverManager.getConnection(url, usr, pwd)");
- connection = DriverManager.getConnection(url, usr, pwd);
- Logger.global.log(Level.INFO, "DriverManager.getConnection(url, usr, pwd) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- return connection;
- }
-
-
- //------------------------------------------------------------------------
- public static Connection getPropertiesConnection() throws SQLException
- {
-
- Connection connection = null;
- checkprops();
-
- Logger.global.log(Level.FINE, "DriverManager.getConnection(url, props)");
- Logger.global.log(Level.FINEST, "Properties = " + props);
- connection = DriverManager.getConnection(url, props);
- Logger.global.log(Level.INFO, "DriverManager.getConnection(url, props) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- return connection;
- }
-
- //------------------------------------------------------------------------
- public static Connection getUrlConnection() throws SQLException
- {
- Connection connection = null;
- checkprops();
-
- Logger.global.log(Level.FINE, "DriverManager.getConnection(url)");
- connection = DriverManager.getConnection(url);
- Logger.global.log(Level.INFO, "DriverManager.getConnection(url) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- return connection;
- }
-
- //------------------------------------------------------------------------
- public static Connection getUrlConnection(String newUrl) throws SQLException
- {
- Connection connection = null;
- checkprops();
-
- Logger.global.log(Level.FINE, "DriverManager.getConnection(newUrl) newUrl = " + newUrl);
- connection = DriverManager.getConnection(newUrl);
- Logger.global.log(Level.INFO, "DriverManager.getConnection(newUrl) passed mewUrl = " + newUrl);
- Logger.global.log(Level.FINE, "==============\n\n");
-
- return connection;
- }
-
- //------------------------------------------------------------------------
- public static void main(String args[])
- {
-
- Connection connection, connection1, connection2;
-
- try
- {
- connection = getUserConnection();
- connection1 = getPropertiesConnection();
- connection2 = getUrlConnection();
-
- Logger.global.log(Level.INFO, "testing valid setCatalog");
- connection.setCatalog("Velu");
- Logger.global.log(Level.INFO, "testing valid setCatalog done");
-
- Logger.global.log(Level.INFO, "testing invalid setTransactionIsolation");
- connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
- Logger.global.log(Level.INFO, "testing invalid TransactionIsolation done");
-
- Logger.global.log(Level.FINE, "testing connection.close for (url)");
- connection.close();
- Logger.global.log(Level.INFO, "testing connection.close for (url) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- Logger.global.log(Level.FINE, "testing connection.close for (url, usr, pwd)");
- connection1.close();
- Logger.global.log(Level.INFO, "testing connection.close for (url) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- Logger.global.log(Level.FINE, "testing connection.close for (url, info)");
- connection2.close();
- Logger.global.log(Level.INFO, "testing connection.close for (url) passed");
- Logger.global.log(Level.FINE, "==============\n\n");
-
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- }
-
- public static void dropTable(Connection conn, String table)
- {
- Statement stmt = null;
-
- try
- {
- stmt = conn.createStatement();
- stmt.executeUpdate("drop table " + table);
- }
- catch (SQLException e)
- {
- Logger.global.log(Level.FINE, "Drop table failed for = " + table);
- Logger.global.log(Level.FINE, "==============\n\n");
- } finally {
- try {
- stmt.close();
- } catch (Exception ex) {}
- }
- }
-
- public static void initialData(Connection conn, String table) throws SQLException
- {
- Statement stmt = null;
-
- try
- {
- stmt = conn.createStatement();
- stmt.executeUpdate("create table " + table + " (c1 char(20), c2 smallint, c3 integer, c4 largeint, c5 varchar(120), c6 numeric(10,2), c7 decimal(10,2),c8 date, c9 time, c10 timestamp, c11 real, c12 double precision) NO PARTITION");
-
- stmt.executeUpdate("insert into " + table + " values('Row1', 100, 12345678, 123456789012, 'Selva', 100.12, 100.12, {d '2000-05-06'}, {t '10:11:12'}, {ts '2000-05-06 10:11:12.0'}, 100.12, 100.12)");
-
- stmt.executeUpdate("insert into " + table + " values('Row2', -100, -12345678, -123456789012, 'Selva', -100.12, -100.12, {d '2000-05-16'}, {t '10:11:12'}, {ts '2000-05-06 10:11:12'}, -100.12, -100.12)");
- stmt.close();
-
- }
- catch (SQLException e)
- {
- Logger.global.log(Level.FINE, "InitialData failed = " + e);
- Logger.global.log(Level.FINE, "==============\n\n");
- try {
- stmt.close();
- } catch (Exception ex) {}
- throw e;
- }
- }
-
- public static void initialCurrentData(Connection conn, String table) throws SQLException
- {
- PreparedStatement pStmt = null;
-
- try
- {
- System.out.println("");
- System.out.println("Inserting TimeStamp ");
- pStmt = conn.prepareStatement(
- "insert into " + table + " values('TimeStamp', -100, -12345678, -123456789012, 'Selva', -100.12, -100.12, ?, ?, ?, -100.12, -100.12)"
- );
-
- pStmt.setDate(1, new Date(new java.util.Date().getTime()));
- pStmt.setTime(2, new Time(new java.util.Date().getTime()));
- Timestamp t1 = new Timestamp( (new java.util.Date()).getTime());
- pStmt.setTimestamp(3, t1);
- if (pStmt.executeUpdate() != 1)
- {
- System.out.println("executeUpdate of TimeStamp failed");
- }
- pStmt.close();
-
- }
- catch (SQLException e)
- {
- Logger.global.log(Level.FINE, "InitialCurrentData failed =" + e);
- Logger.global.log(Level.FINE, "==============\n\n");
- try {
- pStmt.close();
- } catch (Exception ex) {}
- throw e;
- }
- }
-}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/samples/t4jdbc.properties
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/samples/t4jdbc.properties b/core/conn/jdbc_type4/samples/t4jdbc.properties
deleted file mode 100755
index d4c1f98..0000000
--- a/core/conn/jdbc_type4/samples/t4jdbc.properties
+++ /dev/null
@@ -1,26 +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 @@@
-
-catalog = TRAFODION
-schema = SCH
-url = jdbc:t4jdbc://server:port/:
-user = usr
-password = pwd
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/src/T4Messages.properties
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/src/T4Messages.properties b/core/conn/jdbc_type4/src/T4Messages.properties
deleted file mode 100644
index 24d6fb1..0000000
--- a/core/conn/jdbc_type4/src/T4Messages.properties
+++ /dev/null
@@ -1,686 +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 @@@
-##############################################################
-
-#
-# Messages for T2 Driver
-#
-
-unsupported_feature_msg=Unsupported feature - {0}
-unsupported_feature_sqlstate=HYC00
-unsupported_feature_sqlcode=29001
-
-invalid_connection_msg=Connection does not exist
-invalid_connection_sqlstate=08003
-invalid_connection_sqlcode=29002
-
-invalid_statement_msg=Statement does not exist
-invalid_statement_sqlstate=HY000
-invalid_statement_sqlcode=29003
-
-invalid_transaction_isolation_msg=Invalid transaction isolation value
-invalid_transaction_isolation_sqlstate=HY024
-invalid_transaction_isolation_sqlcode=29004
-
-invalid_resultset_type_msg=Invalid ResultSet Type
-invalid_resultset_type_sqlstate=HY024
-invalid_resultset_type_sqlcode=29005
-
-invalid_resultset_concurrency_msg=Invalid Result Set Concurrency
-invalid_resultset_concurrency_sqlstate=HY000
-invalid_resultset_concurrency_sqlcode=29006
-
-invalid_desc_index_msg=Invalid descriptor index
-invalid_desc_index_sqlstate=07009
-invalid_desc_index_sqlcode=29007
-
-invalid_cursor_state_msg=Invalid cursor State
-invalid_cursor_state_sqlstate=24000
-invalid_cursor_state_sqlcode=29008
-
-invalid_cursor_position_msg=Invalid cursor position
-invalid_cursor_position_sqlstate=HY109
-invalid_cursor_position_sqlcode=29009
-
-invalid_column_name_msg=Invalid column name
-invalid_column_name_sqlstate=07009
-invalid_column_name_sqlcode=29010
-
-invalid_column_index_msg=Invalid column index or descriptor index
-invalid_column_index_sqlstate=07009
-invalid_column_index_sqlcode=29011
-
-restricted_data_type_msg=Restricted data type attribute violation
-restricted_data_type_sqlstate=07006
-restricted_data_type_sqlcode=29012
-
-invalid_fetch_size_msg=Fetch size is less than 0
-invalid_fetch_size_sqlstate=HY024
-invalid_fetch_size_sqlcode=29013
-
-fetch_output_inconsistent_msg=General Error - Programming error in next()
-fetch_output_inconsistent_sqlstate=HY000
-fetch_output_inconsistent_sqlcode=29014
-
-invalid_fetch_direction_msg=Invalid fetch direction
-invalid_fetch_direction_sqlstate=HY024
-invalid_fetch_direction_sqlcode=29015
-
-reverse_fetch_not_supported_msg=ResultSet.FETCH_REVERSE not supported
-reverse_fetch_not_supported_sqlstate=HYC00
-reverse_fetch_not_supported_sqlcode=29016
-
-datatype_not_supported_msg=SQL Data type not supported
-datatype_not_supported_sqlstate=HY004
-datatype_not_supported_sqlcode=29017
-
-invalid_cast_specification_msg=Invalid character value in cast specification
-invalid_cast_specification_sqlstate=22018
-invalid_cast_specification_sqlcode=29018
-
-parameter_not_set_msg=Parameter {0, number, integer} for {1, number, integer} set of parameters is not set
-parameter_not_set_sqlstate=07002
-parameter_not_set_sqlcode=29019
-
-invalid_parameter_index_msg=Invalid Parameter Index
-invalid_parameter_index_sqlstate=07009
-invalid_parameter_index_sqlcode=29020
-
-object_type_not_supported_msg=Object Type Not Supported
-object_type_not_supported_sqlstate=HY004
-object_type_not_supported_sqlcode=29021
-
-function_sequence_error_msg=Function Sequence Error
-function_sequence_error_sqlstate=HY010
-function_sequence_error_sqlcode=29022
-
-commit_not_allowed_msg=Commit not allowed in Transaction Aware driver
-commit_not_allowd_sqlstate=HY000
-commit_not_allowd_sqlcode=29023
-
-rollback_not_allowed_msg=Rollback not allowed in Transaction Aware Driver
-rollback_not_allowed_sqlstate=HY000
-rollback_not_allowed_sqlcode=29024
-
-setautocommit_not_allowed_msg=SetAutoCommit not allowed in Transaction Aware Driver
-setautocommit_not_allowed_sqlstate=HY000
-setautocommit_not_allowed_sqlcode=29025
-
-invalid_commit_mode_msg=Transaction can't be committed or rolled back when AutoCommit mode is on
-invalid_commit_mode_sqlstate=HY000
-invalid_commit_mode_sqlcode=29026
-
-autocommit_txn_in_progress_msg=SetAutoCommit not possible, since a transaction is active
-autocommit_txn_in_progress_sqlstate=HY011
-autocommit_txn_in_progress_sqlcode=29027
-
-read_only_connect_msg=Connection is set to read only
-read_only_connect_sqlstate=HY000
-read_only_connect_sqlcode=29028
-
-txn_isolation_txn_in_progress_msg=SetTransactionIsolation not possible, since a transaction is active
-txn_isolation_txn_in_progress_sqlstate=HY011
-txn_isolation_txn_in_progress_sqlcode=29029
-
-forward_only_cursor_msg=Result Set type is TYPE_FORWARD_ONLY
-forward_only_cursor_sqlstate=HY109
-forward_only_cursor_sqlcode=29029
-
-read_only_concur_msg=Result Set Concurrecy is CONCUR_READ_ONLY
-read_only_concur_sqlstate=HY109
-read_only_concur_sqlcode=29030
-
-select_in_batch_not_supported_msg=SELECT sql statements in batch is illgeal
-select_in_batch_not_supported_sqlstate=HY000
-select_in_batch_not_supported_sqlcode=29031
-
-row_modified_msg=The row is modified since it is last read
-row_modified_sqlstate=23000
-row_modified_sqlcode=29032
-
-primary_key_not_updateable_msg=The primary key column value can't be updated
-primary_key_not_updateable_sqlstate=23000
-primary_key_not_updateable_sqlcode=29033
-
-deprecated_method_msg=The method {0} is deprecated
-deprecated_method_sqlstate=HY000
-deprecated_method_sqlcode=29034
-
-io_exception_msg=IO Exception occurred {0}
-io_exception_sqlstate=HY000
-io_exception_sqlcode=29035
-
-unsupported_encoding_msg=Unsupported encoding {0}
-unsupported_encoding_sqlstate=HY000
-unsupported_encoding_sqlcode=29036
-
-forward_only_cursor_msg=The Result Set Type is TYPE_FORWARD_ONLY
-forward_only_cursor_sqlstate=HY106
-forward_only_cursor_sqlcode=29037
-
-invalid_row_number_msg=The row number is not valid
-invalid_row_number_sqlstate=HY107
-invalid_row_number_sqlcode=29038
-
-read_only_concur_msg=The concurrency mode of the result set is CONCUR_READ_ONLY
-read_only_concur_sqlstate=HY092
-read_only_concur_sqlcode=29039
-
-invalid_operation_msg=Operation invalid, since the current row is insert row
-invalid_operation_sqlstate=HY000
-invalid_operation_sqlcode=29040
-
-no_primary_key_msg=Operation not allowed since there is no primary key for the table
-no_primary_key_sqlstate=HY000
-no_primary_key_sqlcode=29041
-
-invalid_fetchSize_value_msg=Fetch size value is not valid
-invalid_fetchSize_value_sqlstate=HY000
-invalid_fetchSize_value_sqlcode=29042
-
-invalid_maxRows_value_msg=Max rows value is not valid
-invalid_maxRows_value_sqlstate=HY000
-invalid_maxRows_value_sqlcode=29043
-
-invalid_queryTimeout_value_msg=Query timeout value is not valid
-invalid_queryTimeout_value_sqlstate=HY000
-invalid_queryTimeout_value_sqlcode=29044
-
-data_truncation_msg=Fractional truncation
-data_truncation_sqlstate=01S07
-data_truncation_sqlcode=29045
-
-numeric_out_of_range_msg=Numeric value out of range
-numeric_out_of_range_sqlstate=22003
-numeric_out_of_range_sqlcode=29046
-
-batch_command_failed_msg=Batch Update Failed, See next exception for details
-batch_command_failed_sqlstate=HY000
-batch_command_failed_sqlcode=29047
-
-invalid_use_of_null_msg=Invalid use of null
-invalid_use_of_null_sqlstate=HY009
-invalid_use_of_null_sqlcode=29048
-
-invalid_transaction_state_msg=Invalid transaction state
-invalid_transaction_state_sqlstate=25000
-invalid_transaction_state_sqlcode=29049
-
-invalid_row_msg=Row value out of range
-invalid_row_sqlstate=HY107
-invalid_row_sqlcode=29050
-
-scrollResultSetChanged_msg=Result Set Type changed to TYPE_SCROLL_INSENSITIVE
-scrollResultSetChanged_sqlstate=01S02
-scrollResultSetChanged_sqlcode=29051
-
-invalid_holdability_state_msg=Invalid cursor holdability
-invalid_holdability_state_sqlstate=25000
-invalid_holdability_state_sqlcode=29052
-
-select_invalid_msg=Select SQL statement is invalid in executeUpdate() method
-select_invalid_sqlstate=HY000
-select_invalid_sqlcode=29053
-
-non_select_invalid_msg=Non-Select SQL statement is invalid in executeQuery() method
-non_select_invalid_sqlstate=HY000
-non_select_invalid_sqlcode=29054
-
-connection_in_use_msg=Connection is in use
-connection_in_use_sqlstate=HY000
-connection_in_use_sqlcode=29055
-
-stmt_closed_msg=Statement is already closed
-stmt_closed_sqlstate=HY000
-stmt_closed_sqlcode=29056
-
-auto_generated_keys_not_supported_msg=Auto generated keys not supported
-auto_generated_keys_not_supported_sqlstate=HY000
-auto_generated_keys_not_supported_sqlcode=29057
-
-null_pooled_connection_msg=Connection is not associated with a PooledConnection object
-null_pooled_connection_sqlstate=HY000
-null_pooled_connection_sqlcode=29058
-
-#
-# New messages for T4 driver
-#
-
-internal_error_msg=An internal error occurred
-internal_error_sqlstate=HY000
-internal_error_sqlcode=29100
-
-contact_hp_error_msg=Contact your service provider
-contact_hp_error_sqlstate=HY000
-contact_hp_error_sqlcode=29101
-
-address_parsing_error_msg=Error while parsing address {0}
-address_parsing_error_sqlstate=HY000
-address_parsing_error_sqlcode=29102
-
-address_null_error_msg=Address is null
-address_null_error_sqlstate=HY000
-address_null_error_sqlcode=29103
-
-odbc_server_suffix_error_msg=Expected suffix: {0}
-odbc_server_suffix_error_sqlstate=HY000
-odbc_server_suffix_error_sqlcode=29104
-
-unknown_prefix_error_msg=Unknown prefix for address
-unknown_prefix_error_sqlstate=HY000
-unknown_prefix_error_sqlcode=29105
-
-jdbc_address_error_msg=Expected address format: jdbc:subprotocol:subname
-jdbc_address_error_sqlstate=HY000
-jdbc_address_error_sqlcode=29106
-
-min_address_length_error_msg=Address is not long enough to be a valid address
-min_address_length_error_sqlstate=HY000
-min_address_length_error_sqlcode=29107
-
-address_format_1_error_msg=Expecting \\<machine name>.<process name>/<port number>
-address_format_1_error_sqlstate=HY000
-address_format_1_error_sqlcode=29108
-
-address_format_2_error_msg=//<{IP Address|Machine Name}[:port]>/<database name>
-address_format_2_error_sqlstate=HY000
-address_format_2_error_sqlcode=29109
-
-missing ip_or_name_error_msg=Address is missing an IP address or machine name
-missing ip_or_name_error_sqlstate=HY000
-missing ip_or_name_error_sqlcode=29110
-
-address_lookup_error_msg=Unable to evaluate address {0} Cause: {1}
-address_lookup_error_sqlstate=HY000
-address_lookup_error_sqlcode=29111
-
-address_missing_close_bracket_msg=Missing ']'
-address_missing_close_bracket_sqlstate=HY000
-address_missing_close_bracket_sqlcode=29112
-
-socket_open_error_msg=error while opening socket. Cause: {0}
-socket_open_error_sqlstate=HY000
-socket_open_error_sqlcode=29113
-
-socket_write_error_msg=error while writing to socket
-socket_write_error_sqlstate=HY000
-socket_write_error_sqlcode=29114
-
-socket_read_error_msg=error while reading from socket. Cause: {0}
-socket_read_error_sqlstate=HY000
-socket_read_error_sqlcode=29115
-
-socket_is_closed_error_msg=Socket is closed
-socket_is_closed_error_sqlstate=HY000
-socket_is_closed_error_sqlcode=29116
-
-session_close_error_msg=Error while closing session. Cause: {0}
-session_close_error_sqlstate=HY000
-session_close_error_sqlcode=29117
-
-bad_map_ptr=A write to a bad map pointer occurred
-bad_map_ptr_sqlstate=HY000
-bad_map_ptr_sqlcode=29118
-
-bad_par_ptr=A write to a bad par pointer occurred
-bad_par_ptr_sqlstate=HY000
-bad_par_ptr_sqlcode=29119
-
-dcs_connect_message_error_msg=An dcs server connect message error occurred. Cause: {0}
-dcs_connect_message_error_sqlstate=HY000
-dcs_connect_message_error_sqlcode=29120
-
-close_message_error_msg=A close message error occurred. Cause: {0}
-close_message_error_sqlstate=HY000
-close_message_error_sqlcode=29121
-
-end_transaction_message_error_msg=An end transaction message error occurred. Cause: {0}
-end_transaction_message_error_sqlstate=HY000
-end_transaction_message_error_sqlcode=29122
-
-execute_call_message_error_msg=An execute call message error occurred. Cause: {0}
-execute_call_message_error_sqlstate=HY000
-execute_call_message_error_sqlcode=29123
-
-execute_direct_message_error_msg=An execute direct message error occurred. Cause: {0}
-execute_direct_message_error_sqlstate=HY000
-execute_direct_message_error_sqlcode=29124
-
-execute_direct_rowset_message_error_msg=An execute direct rowset message error occurred. Cause: {0}
-execute_direct_rowset_message_error_sqlstate=HY000
-execute_direct_rowset_message_error_sqlcode=29125
-
-execute_n_message_error_msg =An execute N message error occurred. Cause: {0}
-execute_n_message_error_sqlstate=HY000
-execute_n_message_error_sqlcode=29126
-
-execute_rowset_message_error_msg=An execute rowset message error occurred. Cause: {0}
-execute_rowset_message_error_sqlstate=HY000
-execute_rowset_message_error_sqlcode=29127
-
-fetch_perf_message_error_msg=A fetch perf message error occurred. Cause: {0}
-fetch_perf_message_error_sqlstate=HY000
-fetch_perf_message_error_sqlcode=29128
-
-fetch_rowset_message_error_msg=A fetch rowset message error occurred. Cause: {0}
-fetch_rowset_message_error_sqlstate=HY000
-fetch_rowset_message_error_sqlcode=29129
-
-get_sql_catalogs_message_error_msg=A get sql catalogs message error occurred. Cause: {0}
-get_sql_catalogs_message_error_sqlstate=HY000
-get_sql_catalogs_message_error_sqlcode=29130
-
-initialize_dialogue_message_error=An initialize dialogue message error occurred. Cause: {0}
-initialize_dialogue_message_error_sqlstate=HY000
-initialize_dialogue_message_error_sqlcode=29131
-
-prepare_message_error_msg=A prepare message error occurred. Cause: {0}
-prepare_message_error_sqlstate=HY000
-prepare_message_error_sqlcode=29132
-
-prepare_rowset_message_error_msg=A prepare rowset message error occurred. Cause: {0}
-prepare_rowset_message_error_sqlstate=HY000
-prepare_rowset_message_error_sqlcode=29133
-
-set_connection_option_message_error_msg=A set connection option message error occurred. Cause: {0}
-set_connection_option_message_error_sqlstate=HY000
-set_connection_option_message_error_sqlcode=29134
-
-terminate_dialogue_message_error_msg=A terminate dialogue message error occurred: Cause {0}
-terminate_dialogue_message_error_sqlstate=HY000
-terminate_dialogue_message_error_sqlcode=29135
-
-dcs_connect_reply_error_msg=An dcs server connect reply error occurred. Exception: {0} Exception detail: {1} Error text/code: {2}
-dcs_connect_reply_error_sqlstate=HY000
-dcs_connect_reply_error_sqlcode=29136
-
-close_reply_error_msg=A close reply error occurred
-close_reply_error_sqlstate=HY000
-close_reply_error_sqlcode=29137
-
-end_transaction_reply_error_msg=An end transaction reply error occurred
-end_transaction_reply_error_sqlstate=HY000
-end_transaction_reply_error_sqlcode=29138
-
-execute_call_reply_error_msg=An execute call reply error occurred
-execute_call_reply_error_sqlstate=HY000
-execute_call_reply_error_sqlcode=29139
-
-execute_direct_reply_error_msg=An execute direct reply error occurred
-execute_direct_reply_error_sqlstate=HY000
-execute_direct_reply_error_sqlcode=29140
-
-execute_direct_rowset_reply_error_msg=An execute direct rowset reply error occurred
-execute_direct_rowset_reply_error_sqlstate=HY000
-execute_direct_rowset_reply_error_sqlcode=29141
-
-execute_n_reply_error_msg=An execute N reply error occurred
-execute_n_reply_error_sqlstate=HY000
-execute_n_reply_error_sqlcode=29142
-
-execute_rowset_reply_error_msg=An execute rowset reply error occurred
-execute_rowset_reply_error_sqlstate=HY000
-execute_rowset_reply_error_sqlcode=29143
-
-fetch_perf_reply_error_msg=A fetch perf reply error occurred
-fetch_perf_reply_error_sqlstate=HY000
-fetch_perf_reply_error_sqlcode=29144
-
-fetch_rowset_reply_error_msg=A fetch rowset reply error occurred
-fetch_rowset_reply_error_sqlstate=HY000
-fetch_rowset_reply_error_sqlcode=29145
-
-get_sql_catalogs_reply_error_msg=A get sql catalogs reply error occurred
-get_sql_catalogs_reply_error_sqlstate=HY000
-get_sql_catalogs_reply_error_sqlcode=29146
-
-initialize_dialogue_reply_error_msg=An initialize dialogue reply error occurred
-initialize_dialogue_reply_error_sqlstate=HY000
-initialize_dialogue_reply_error_sqlcode=29147
-
-prepare_reply_error_msg=A prepare reply error occurred
-prepare_reply_error_sqlstate=HY000
-prepare_reply_error_sqlcode=29148
-
-prepare_rowset_reply_error_msg=A prepare rowset reply error occurred
-prepare_rowset_reply_error_sqlstate=HY000
-prepare_rowset_reply_error_sqlcode=29149
-
-set_connection_option_reply_error_msg=A set connection option reply error occurred
-set_connection_option_reply_error_sqlstate=HY000
-set_connection_option_reply_error_sqlcode=29150
-
-terminate_dialogue_reply_error_msg=A terminate dialogue reply error occurred
-terminate_dialogue_reply_error_sqlstate=HY000
-terminate_dialogue_reply_error_sqlcode=29151
-
-ids_port_not_available_msg=No more ports available to start NDCS servers
-ids_port_not_available_sqlstate=HY000
-ids_port_not_available_sqlcode=29152
-
-ids_28_000_msg=Invalid authorization specification
-ids_28_000_sqlstate=HY000
-ids_28_000_sqlcode=29153
-
-ids_s1_t00_msg=Timeout expired
-ids_s1_t00_sqlstate=HY000
-ids_s1_t00_sqlcode=29154
-
-unknown_message_type_error_msg=Unknown message type
-unknown_message_type_error_sqlstate=HY000
-unknown_message_type_error_sqlcode=29155
-
-driver_err_error_from_server_msg=An error was returned from the server. Error: {0} Error detail: {1}
-driver_err_error_from_server_sqlstate=HY000
-driver_err_error_from_server_sqlcode=29156
-
-problem_with_server_read_msg=There was a problem reading from the server
-problem_with_server_read_sqlstate=HY000
-problem_with_server_read_sqlcode=29157
-
-wrong_header_version_msg=The message header contained the wrong version: {0}
-wrong_header_version_sqlstate=HY000
-wrong_header_version_sqlcode=29158
-
-wrong_header_signature_msg=The message header contained the wrong signature. Expected: {0} Actual: {1}
-wrong_header_signature_sqlstate=HY000
-wrong_header_signature_sqlcode=29159
-
-header_not_long_enough_msg=The message header was not long enough
-header_not_long_enough_sqlstate=HY000
-header_not_long_enough_sqlcode=29160
-
-ids_unable_to_logon_msg=Unable to authenticate the user because of an NT error: {0}
-ids_unable_to_logon_sqlstate=S1000
-ids_unable_to_logon_sqlcode=29161
-
-ids_program_error_msg=Unexpected programming exception has been found: {0}. Check the server event log on node {1} for details.
-ids_program_error_sqlstate=S1000
-ids_program_error_sqlcode=29162
-
-ids_dcs_srvr_not_available_msg=DCS Services not yet available: {0}
-ids_dcs_srvr_not_available_sqlstate=08001
-ids_dcs_srvr_not_available_sqlcode=29163
-
-ids_ds_not_available_msg=DataSource not yet available or not found: {0}
-ids_ds_not_available_sqlstate=08001
-ids_ds_not_available_sqlcode=29164
-
-unknown_connect_error_msg=Unknown connect reply error: {0}
-unknown_connect_error_sqlstate=HY000
-unknown_connect_error_sqlcode= 29165
-
-ids_08_004_01_msg=Data source rejected establishment of connection since the NDCS Server is connected to a different client now
-ids_08_004_01_sqlstate=08004
-ids_08_004_01_sqlcode=HY000
-
-ids_transaction_error_msg=A TIP transaction error {0} has been detected. Check the server event log on Node {1} for Transaction Error details.
-ids_transaction_error_sqlstate=S1000
-ids_transaction_error_sqlcode=HY000
-
-ids_08_s01_msg=Communication link failure. The server timed out or disappeared.
-ids_08_s01_sqlstate=08S01
-ids_08_s01_sqlcode=01032
-
-ids_s1_008_msg=Operation cancelled.
-ids_s1_008_sqlstate=S1008
-ids_s1_008_sqlcode=01118
-
-ids_25_000_msg=Invalid transaction state.
-ids_25_000_sqlstate=25000
-ids_25_000_sqlcode=01056
-
-internal_error_method_not_implemented_msg=Internal error. This method is not implemented.
-internal_error_method_not_implemented_sqlstate=HY000
-internal_error_method_not_implemented_sqlcode=29166
-
-internal_error_inconsistency_check_msg=Internal error. An internal index failed consistency check.
-internal_error_inconsistency_check_sqlstate=HY000
-internal_error_inconsistency_check_sqlcode=29167
-
-ids_unknown_reply_error_msg=Unknown reply message error: {0} error detail: {1}
-ids_unknown_reply_error_sqlstate=HY000
-ids_unknown_reply_error_sqlcode=29168
-
-ids_retry_attempt_exceeded_msg=Retry attempts to connect to the datasource failed. Maybe NDCS server is not available.
-ids_retry_attempt_exceeded_sqlstate=08001
-ids_retry_attempt_exceeded_sqlcode=HY000
-
-invalid_property_msg=Invalid connection property setting: {0}
-invalid_property_sqlstate=HY000
-invalid_property_sqlcode=29169
-
-invalid_parameter_value_msg=Invalid Parameter Value: {0}
-invalid_parameter_value_sqlstate=HY000
-invalid_parameter_value_sqlcode=29170
-
-resource_governing_msg=Failed since resource governing policy is hit
-resource_governing_sqlstate=S1000
-resource_governing_sqlcode=29171
-
-translation_of_parameter_failed_msg=Translation of parameter to {0} failed. Cause: {1}
-translation_of_parameter_failed_sqlstate=HY000
-translation_of_parameter_failed_sqlcode=29172
-
-#
-# New Messages for LOB Support From Type 2
-#
-
-no_blobTableName_msg='blobTableName' property is not set or set to null value or set to invalid value
-no_blobTableName_sqlstate=HY000
-no_blobTableName_sqlcode=29059
-
-no_clobTableName_msg='clobTableName' property is not set or set to null value or set to invalid value
-no_clobTableName_sqlstate=HY000
-no_clobTableName_sqlcode=29060
-
-invalid_lob_commit_state_msg=Autocommit is on and LOB objects are involved
-invalid_lob_commit_state_sqlstate=HY000
-invalid_lob_commit_state_sqlcode=29069
-
-lob_not_current_msg=Lob object {0} is not current
-lob_not_current_sqlstate=HY000
-lob_not_current_sqlcode=29061
-
-invalid_input_value_msg=Invalid input value in the method {0}
-invalid_input_value_sqlstate=07009
-invalid_input_value_sqlcode=29067
-
-invalid_position_value_msg=The value for position can be any value between 1 and one more than the length of the lob data
-invalid_position_value_sqlstate=07009
-invalid_position_value_sqlcode=29068
-
-problem_with_logging_msg=There was a problem while logging: {0}
-problem_with_logging_sqlstate=HY000
-problem_with_logging_sqlcode=29070
-
-initial_pool_creation_error_msg=Error occurred while creating the initial pool of {0} connection(s)
-initial_pool_creation_error_sqlstate=HY000
-initial_pool_creation_error_sqlcode=29173
-
-resultSet_updateRow_with_autocommit_msg=Autocommit is on and updateRow was called on the ResultSet object
-resultSet_updateRow_with_autocommit_sqlstate=HY000
-resultSet_updateRow_with_autocommit_sqlcode=29174
-
-unknown_error_msg=Unknown Error {0}
-unknown_error_sqlstate=HY000
-unknown_error_sqlcode=29175
-
-fill_in_SQL_Values_msg=Failed while converting objects to SQL values.
-fill_in_SQL_Values_sqlstate=HY000
-fill_in_SQL_Values_sqlcode=29176
-
-null_data_msg=Data cannot be null.
-null_data_sqlstate=HY000
-null_data_sqlcode=29177
-
-no_column_value_specified_msg=No column value has been inserted
-no_column_value_specified_sqlstate=HY000
-no_column_value_specified_sqlcode=29178
-
-
-execute_2_message_error_msg =An Execute2 message error occurred. Cause: {0}
-execute_2_message_error_sqlstate=HY000
-execute_2_message_error_sqlcode=29179
-
-infostats_invalid_error_msg=INFOSTATS command is supported only via the Statement.execute(String sql) method.
-infostats_invalid_error_sqlstate=HY000
-infostats_invalid_error_sqlcode=29180
-
-dcs_cancel_message_error_msg=A dcs server cancel message error occurred. Cause: {0}
-dcs_cancel_message_error_sqlstate=HY000
-dcs_cancel_message_error_sqlcode=29181
-
-connected_to_Default_DS_msg= General warning. Connected to the default data source: {0}
-connected_to_Default_DS_sqlstate=HY000
-connected_to_Default_DS_sqlcode=29182
-
-invalid_string_parameter_msg=Invalid Parameter Value: {0}
-invalid_string_parameter_sqlstate=22001
-invalid_string_parameter_sqlcode=29183
-
-null_parameter_for_not_null_column_msg=NULL cannot be assigned to a NOT NULL column, parameter {0}.
-null_parameter_for_not_null_column_sqlstate=23000
-null_parameter_for_not_null_column_sqlcode=29184
-
-security_error_msg=A Security Exception Occurred: {0}
-security_error_sqlstate=HY000
-security_error_sqlcode=29185
-
-certificate_download_error_msg=An error occurred while downloading the certificate: {0}
-certificate_download_error_sqlstate=HY000
-certificate_download_error_sqlcode=29186
-
-data_truncation_exceed_msg=The data length {0} exceeds the max length {1}
-data_truncation_exceed_sqlstate=HY000
-data_truncation_exceed_sqlcode=29187
-
-numeric_out_of_range_d_msg=Numeric value {0} is out of range [{1}, {2}]
-numeric_out_of_range_d_sqlstate=22003
-numeric_out_of_range_d_sqlcode=29188
-
-cursor_is_before_first_row_msg=The cursor is before the first row, therefore no data can be retrieved
-cursor_is_before_first_row_sqlstate=HY109
-cursor_is_before_first_row_sqlcode=29189
-
-cursor_after_last_row_msg=The cursor is after last row, which could be due to the result set containing no rows, or all rows have been retrieved.
-cursor_after_last_row_sqlstate=HY109
-cursor_after_last_row_sqlcode=29190
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Address.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Address.java b/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Address.java
deleted file mode 100644
index d486f57..0000000
--- a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Address.java
+++ /dev/null
@@ -1,117 +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 @@@
-
-package org.trafodion.jdbc.t4;
-
-/**********************************************************
- * This class represents an address reference.
- *
- *
- **********************************************************/
-
-import java.net.InetAddress;
-import java.sql.SQLException;
-import java.util.Locale;
-import java.util.Properties;
-
-abstract class Address {
- protected Locale m_locale;
- protected T4Properties m_t4props;
- protected String m_ipAddress;
- protected String m_machineName;
- protected String m_processName;
- protected Integer m_portNumber;
- protected Properties m_properties;
- InetAddress[] m_inetAddrs;
- protected int m_type;
- protected String m_url;
- protected InputOutput m_io;
-
- /**
- * The constructor.
- *
- * @param addr
- * The addr has two forms:
- *
- * DriverManager getConnection addr parameter format for connecting via the
- * Fast JDBC Type 3 driver.
- *
- * jdbc:subprotocol:subname
- *
- * Where:
- *
- * subprotocol = t4jdbc
- *
- * subname = //<{IP Address|Machine Name}[:port]>/<database name>
- *
- * Example: jdbc:t4jdbc://130.168.200.30:1433/database1
- *
- *
- * ODBC server connect format returned by the ODBC Association Server.
- *
- * TCP:\<{IP Address|Machine Name}>.<Process Name>/<port>:ODBC
- *
- */
-
- // ----------------------------------------------------------
- Address(T4Properties t4props, Locale locale, String addr) throws SQLException {
- m_t4props = t4props;
- m_locale = locale;
- m_url = addr;
- }
-
- abstract String recreateAddress();
-
- // ----------------------------------------------------------
- String getIPorName() {
- if (m_machineName != null) {
- return m_machineName;
- } else {
- return m_ipAddress;
- }
- } // end getIPorName
-
- protected boolean validateAddress() throws SQLException {
- String IPorName = getIPorName();
- try {
- m_inetAddrs = InetAddress.getAllByName(IPorName);
- } catch (Exception e) {
- SQLException se = HPT4Messages.createSQLException(m_t4props, m_locale, "address_lookup_error", m_url, e
- .getMessage());
- se.initCause(e);
- throw se;
- }
- return true;
- }
-
- // ----------------------------------------------------------
- Integer getPort() {
- return m_portNumber;
- } // end getIPorName
-
- void setInputOutput() {
- m_io = new InputOutput(m_locale, this);
- }
-
- InputOutput getInputOutput() {
- return m_io;
- }
-} // end class Address
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/BaseRow.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/BaseRow.java b/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/BaseRow.java
deleted file mode 100644
index 3d28248..0000000
--- a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/BaseRow.java
+++ /dev/null
@@ -1,65 +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 @@@
-
-/*
- * Copyright (c) 2003, Oracle and/or its affiliates. All rights reserved.
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * This code is free software; you can redistribute it and/or modify it
- * under the terms of the GNU General Public License version 2 only, as
- * published by the Free Software Foundation. Oracle designates this
- * particular file as subject to the "Classpath" exception as provided
- * by Oracle in the LICENSE file that accompanied this code.
- * This code is distributed in the hope that it will be useful, but WITHOUT
- * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
- * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
- * version 2 for more details (a copy is included in the LICENSE file that
- * accompanied this code).
- *
- * You should have received a copy of the GNU General Public License version
- * 2 along with this work; if not, write to the Free Software Foundation,
- * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
- *
- * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
- * or visit www.oracle.com if you need additional information or have any
- * questions.
- */
-
-package org.trafodion.jdbc.t4;
-
-import java.io.Serializable;
-import java.sql.SQLException;
-
-abstract class BaseRow implements Serializable, Cloneable {
-
- protected Object origVals[];
-
- BaseRow() {
- }
-
- protected abstract Object getColumnObject(int i) throws SQLException;
-
- protected Object[] getOrigRow() {
- return origVals;
- }
-
- protected abstract void setColumnObject(int i, Object obj) throws SQLException;
-}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/72e17019/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Bytes.java
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Bytes.java b/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Bytes.java
deleted file mode 100644
index 78803c3..0000000
--- a/core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/Bytes.java
+++ /dev/null
@@ -1,269 +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 @@@
-
-package org.trafodion.jdbc.t4;
-
-/**
- * <code>Bytes</code> contains a set of static methods used for byte
- * manipulation. There are three basic types of methods:
- * <ul>
- * <li>extract</li>
- * <li>insert</li>
- * <li>create</li>
- * </ul>
- * <p>
- * Extract methods will copy from a raw byte array into a basic Java type.
- * Insert methods will copy from a basic Java type into a raw byte array. Create
- * methods will copy from a basic Java type into a new raw byte array which is
- * returned to the user.
- *
- * As Java is always BigEndian, set the swap parameter to <code>true</code> to
- * convert to and from LittleEndian.
- *
- * There is no error checking in order to improve performance. Length checking
- * should be done before calling these methods or the resulting exceptions
- * should be handled by the user.
- *
- */
-class Bytes {
-
- static short extractShort(byte[] array, int offset, boolean swap) {
- short value;
-
- if (swap) {
- value = (short) (((array[offset]) & 0x00ff) | ((array[offset + 1] << 8) & 0xff00));
- } else {
- value = (short) (((array[offset + 1]) & 0x00ff) | ((array[offset] << 8) & 0xff00));
- }
-
- return value;
- }
-
- static int extractUShort(byte[] array, int offset, boolean swap) {
- int value;
-
- if (swap) {
- value = ((array[offset]) & 0x00ff) | ((array[offset + 1] << 8) & 0xff00);
- } else {
- value = ((array[offset + 1]) & 0x00ff) | ((array[offset] << 8) & 0xff00);
- }
-
- return value & 0xffff;
- }
-
- static int extractInt(byte[] array, int offset, boolean swap) {
- int value;
-
- if (swap) {
- value = ((array[offset]) & 0x000000ff) | ((array[offset + 1] << 8) & 0x0000ff00)
- | ((array[offset + 2] << 16) & 0x00ff0000) | ((array[offset + 3] << 24) & 0xff000000);
- } else {
- value = ((array[offset + 3]) & 0x000000ff) | ((array[offset + 2] << 8) & 0x0000ff00)
- | ((array[offset + 1] << 16) & 0x00ff0000) | ((array[offset] << 24) & 0xff000000);
- }
-
- return value;
- }
-
- static long extractUInt(byte[] array, int offset, boolean swap) {
- long value;
-
- if (swap) {
- value = ((array[offset]) & 0x000000ff) | ((array[offset + 1] << 8) & 0x0000ff00)
- | ((array[offset + 2] << 16) & 0x00ff0000) | ((array[offset + 3] << 24) & 0xff000000);
- } else {
- value = ((array[offset + 3]) & 0x000000ff) | ((array[offset + 2] << 8) & 0x0000ff00)
- | ((array[offset + 1] << 16) & 0x00ff0000) | ((array[offset] << 24) & 0xff000000);
- }
-
- return value & 0xffffffffL;
- }
-
- static long extractLong(byte[] array, int offset, boolean swap) {
- long value = 0;
- int i=offset;
-
- if(swap) {
- for (int shift = 0; shift < 64; shift += 8) {
- value |= ( (long)( array[i] & 0xff ) ) << shift;
- i++;
- }
-
- }else {
- for (int shift = 56; shift >= 0; shift -= 8) {
- value |= ( (long)( array[i] & 0xff ) ) << shift;
- i++;
- }
- }
-
- return value;
- }
-
- static int insertShort(byte[] array, int offset, short value, boolean swap) {
- if (swap) {
- array[offset + 1] = (byte) ((value >>> 8) & 0xff);
- array[offset] = (byte) ((value) & 0xff);
- } else {
- array[offset] = (byte) ((value >>> 8) & 0xff);
- array[offset + 1] = (byte) ((value) & 0xff);
- }
-
- return offset + 2;
- }
-
- /*
- * static int insertUShort(byte[] array, int offset, int value, boolean
- * swap) {
- *
- * return offset + 2; }
- */
-
- static int insertInt(byte[] array, int offset, int value, boolean swap) {
- if (swap) {
- array[offset + 3] = (byte) ((value >>> 24) & 0xff);
- array[offset + 2] = (byte) ((value >>> 16) & 0xff);
- array[offset + 1] = (byte) ((value >>> 8) & 0xff);
- array[offset] = (byte) ((value) & 0xff);
- } else {
- array[offset] = (byte) ((value >>> 24) & 0xff);
- array[offset + 1] = (byte) ((value >>> 16) & 0xff);
- array[offset + 2] = (byte) ((value >>> 8) & 0xff);
- array[offset + 3] = (byte) ((value) & 0xff);
- }
-
- return offset + 4;
- }
-
- /*
- * static int insertUInt(byte[] array, int offset, long value, boolean swap) {
- * return offset + 4; }
- */
-
- static int insertLong(byte[] array, int offset, long value, boolean swap) {
- if (swap) {
- array[offset + 7] = (byte) ((value >>> 56) & 0xff);
- array[offset + 6] = (byte) ((value >>> 48) & 0xff);
- array[offset + 5] = (byte) ((value >>> 40) & 0xff);
- array[offset + 4] = (byte) ((value >>> 32) & 0xff);
- array[offset + 3] = (byte) ((value >>> 24) & 0xff);
- array[offset + 2] = (byte) ((value >>> 16) & 0xff);
- array[offset + 1] = (byte) ((value >>> 8) & 0xff);
- array[offset] = (byte) ((value) & 0xff);
- } else {
- array[offset] = (byte) ((value >>> 56) & 0xff);
- array[offset + 1] = (byte) ((value >>> 48) & 0xff);
- array[offset + 2] = (byte) ((value >>> 40) & 0xff);
- array[offset + 3] = (byte) ((value >>> 32) & 0xff);
- array[offset + 4] = (byte) ((value >>> 24) & 0xff);
- array[offset + 5] = (byte) ((value >>> 16) & 0xff);
- array[offset + 6] = (byte) ((value >>> 8) & 0xff);
- array[offset + 7] = (byte) ((value) & 0xff);
- }
-
- return offset + 8;
- }
-
- static byte[] createShortBytes(short value, boolean swap) {
- byte[] b = new byte[2];
- Bytes.insertShort(b, 0, value, swap);
-
- return b;
- }
-
- /*
- * static byte[] createUShortBytes(int value, boolean swap) { byte[] b = new
- * byte[2]; Bytes.insertUShort(b, 0, value, swap);
- *
- * return b; }
- */
-
- static byte[] createIntBytes(int value, boolean swap) {
- byte[] b = new byte[4];
- Bytes.insertInt(b, 0, value, swap);
-
-
- return b;
- }
-
- /*
- * static byte[] createUIntBytes(long value, boolean swap) { byte[] b = new
- * byte[4]; Bytes.insertUInt(b, 0, value, swap);
- *
- * return b; }
- */
-
- static byte[] createLongBytes(long value, boolean swap) {
- byte[] b = new byte[8];
- Bytes.insertLong(b, 0, value, swap);
-
- return b;
- }
-
- // -------------------------------------------------------------
- // -------------------------------------------------------------
- // ---------------TODO: get rid of these methods!---------------
- // -------------------------------------------------------------
- // -------------------------------------------------------------
-
- /**
- * @deprecated
- */
- static char[] read_chars(byte[] buffer, int index) {
- int len = 0;
-
- // find the null terminator
- while (buffer[index + len] != 0) {
- len = len + 1;
- }
-
- char[] temp1 = read_chars(buffer, index, len);
-
- return temp1;
- } // end read_chars
-
- /**
- * @deprecated
- */
- static char[] read_chars(byte[] buffer, int index, int tLen) {
- char[] la_chars;
- int len = tLen;
-
- if (len == -1) // must find null to get length
- {
- int ii = index;
- while (buffer[ii] != (byte) 0) {
- ii = ii + 1;
- }
- len = ii - index;
- }
-
- la_chars = new char[len];
-
- int i = 0;
- while (i < len) {
- la_chars[i] = (char) (buffer[index] & 0xff);
- i = i + 1;
- index = index + 1;
- }
-
- return la_chars;
- } // end read_chars
-}