sqoop-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cheol...@apache.org
Subject git commit: SQOOP-894: Increase counter and group name size in derby repository
Date Thu, 14 Feb 2013 18:04:15 GMT
Updated Branches:
  refs/heads/sqoop2 217cf297b -> c8af63092


SQOOP-894: Increase counter and group name size in derby repository

 (Jarcec Cecho via Cheolsoo Park)


Project: http://git-wip-us.apache.org/repos/asf/sqoop/repo
Commit: http://git-wip-us.apache.org/repos/asf/sqoop/commit/c8af6309
Tree: http://git-wip-us.apache.org/repos/asf/sqoop/tree/c8af6309
Diff: http://git-wip-us.apache.org/repos/asf/sqoop/diff/c8af6309

Branch: refs/heads/sqoop2
Commit: c8af63092d760e4ada3d4b5fd76c35d799b93d08
Parents: 217cf29
Author: Cheolsoo Park <cheolsoo@apache.org>
Authored: Thu Feb 14 09:59:44 2013 -0800
Committer: Cheolsoo Park <cheolsoo@apache.org>
Committed: Thu Feb 14 09:59:44 2013 -0800

----------------------------------------------------------------------
 .../sqoop/repository/derby/DerbySchemaQuery.java   |   16 +++++++-------
 1 files changed, 8 insertions(+), 8 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/sqoop/blob/c8af6309/repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
----------------------------------------------------------------------
diff --git a/repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
b/repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
index d94ecc5..314948c 100644
--- a/repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
+++ b/repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
@@ -146,7 +146,7 @@ import static org.apache.sqoop.repository.derby.DerbySchemaConstants.*;
  *    | SQ_COUNTER_GROUP           |
  *    +----------------------------+
  *    | SQG_ID: BIGINT PK          |
- *    | SQG_NAME: VARCHAR(50)      |
+ *    | SQG_NAME: VARCHAR(75)      |
  *    +----------------------------+
  * </pre>
  * </p>
@@ -157,7 +157,7 @@ import static org.apache.sqoop.repository.derby.DerbySchemaConstants.*;
  *    | SQ_COUNTER                 |
  *    +----------------------------+
  *    | SQR_ID: BIGINT PK          |
- *    | SQR_NAME: VARCHAR(50)      |
+ *    | SQR_NAME: VARCHAR(75)      |
  *    +----------------------------+
  * </pre>
  * </p>
@@ -284,7 +284,7 @@ public final class DerbySchemaQuery {
   public static final String QUERY_CREATE_TABLE_SQ_COUNTER_GROUP =
     "CREATE TABLE " + TABLE_SQ_COUNTER_GROUP + " ("
     + COLUMN_SQG_ID + " BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
"
-    + COLUMN_SQG_NAME + " VARCHAR(50), "
+    + COLUMN_SQG_NAME + " VARCHAR(75), "
     + "PRIMARY KEY (" + COLUMN_SQG_ID + "),"
     + "UNIQUE ( " + COLUMN_SQG_NAME + ")"
     + ")";
@@ -293,7 +293,7 @@ public final class DerbySchemaQuery {
   public static final String QUERY_CREATE_TABLE_SQ_COUNTER =
     "CREATE TABLE " + TABLE_SQ_COUNTER + " ("
     + COLUMN_SQR_ID + " BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
"
-    + COLUMN_SQR_NAME + " VARCHAR(50), "
+    + COLUMN_SQR_NAME + " VARCHAR(75), "
     + "PRIMARY KEY (" + COLUMN_SQR_ID + "), "
     + "UNIQUE ( " + COLUMN_SQR_NAME + ")"
     + ")";
@@ -586,13 +586,13 @@ public final class DerbySchemaQuery {
     + COLUMN_SQG_ID + ", "
     + COLUMN_SQG_NAME + " "
     + "FROM " + TABLE_SQ_COUNTER_GROUP + " "
-    + "WHERE " + COLUMN_SQG_NAME + " = ?";
+    + "WHERE " + COLUMN_SQG_NAME + " = substr(?, 1, 75)";
 
   // DML: Insert new counter group
   public static final String STMT_INSERT_COUNTER_GROUP =
     "INSERT INTO " + TABLE_SQ_COUNTER_GROUP + " ("
     + COLUMN_SQG_NAME + ") "
-    + "VALUES (?)";
+    + "VALUES (substr(?, 1, 75))";
 
   // DML: Select counter
   public static final String STMT_SELECT_COUNTER =
@@ -600,13 +600,13 @@ public final class DerbySchemaQuery {
     + COLUMN_SQR_ID + ", "
     + COLUMN_SQR_NAME + " "
     + "FROM " + TABLE_SQ_COUNTER + " "
-    + "WHERE " + COLUMN_SQR_NAME + " = ?";
+    + "WHERE " + COLUMN_SQR_NAME + " = substr(?, 1, 75)";
 
   // DML: Insert new counter
   public static final String STMT_INSERT_COUNTER =
     "INSERT INTO " + TABLE_SQ_COUNTER + " ("
     + COLUMN_SQR_NAME + ") "
-    + "VALUES (?)";
+    + "VALUES (substr(?, 1, 75))";
 
   // DML: Insert new counter submission
   public static final String STMT_INSERT_COUNTER_SUBMISSION =


Mime
View raw message