You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by ma...@apache.org on 2003/12/17 15:57:26 UTC

cvs commit: jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/builder OracleBuilder.java

matth       2003/12/17 06:57:26

  Modified:    sql/src/java/org/apache/commons/sql/builder
                        OracleBuilder.java
  Log:
  PR: 13370
  Submitted by: Joe@Germuska.com (Joe Germuska)
  
  Fixed type handling in Oracle.
  
  Revision  Changes    Path
  1.8       +18 -0     jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/builder/OracleBuilder.java
  
  Index: OracleBuilder.java
  ===================================================================
  RCS file: /home/cvs/jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/builder/OracleBuilder.java,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- OracleBuilder.java	16 Dec 2003 15:09:50 -0000	1.7
  +++ OracleBuilder.java	17 Dec 2003 14:57:26 -0000	1.8
  @@ -142,4 +142,22 @@
           print( "end" );
           printEndOfStatement();
       }
  +
  +
  +    /**
  +     * @return the full SQL type string, including size where appropriate.
  +     * Where necessary, translate for Oracle specific DDL requirements.
  +     */
  +    protected String getSqlType(Column column) {
  +      switch (column.getSQLTypeCode())
  +      {
  +        case java.sql.Types.INTEGER:
  +          return "INTEGER";
  +        case java.sql.Types.DATE:  
  +        case java.sql.Types.TIME:  
  +        case java.sql.Types.TIMESTAMP:  
  +          return "DATE";
  +        default: return column.getTypeString();
  +      }
  +    }  
   }
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org