001 package railo.runtime.db; 002 003 import java.sql.Types; 004 005 006 public interface CFTypes { 007 //public static final int BFILE=-13;//OracleTypes.BFILE; 008 public static final int CURSOR=-10;//OracleTypes.CURSOR; 009 public static final int OPAQUE=2007; 010 public static final int BFILE=-13; 011 public static final int BINARY_DOUBLE=101; 012 public static final int BINARY_FLOAT=100; 013 public static final int FIXED_CHAR=999; 014 public static final int INTERVALDS=-104; 015 public static final int INTERVALYM=-103; 016 public static final int JAVA_STRUCT=2008; 017 public static final int NUMBER=Types.NUMERIC; 018 public static final int PLSQL_INDEX_TABLE=-14; 019 public static final int RAW=-2; 020 public static final int ROWID=-8; 021 public static final int TIMESTAMPLTZ=-102; 022 public static final int TIMESTAMPNS=-100; 023 public static final int TIMESTAMPTZ=-101; 024 public static final int VARCHAR2=-100; 025 026 /** 027 * <P>The constant in the Java programming language, sometimes referred 028 * to as a type code, that identifies the generic SQL type 029 * <code>BIT</code>. 030 */ 031 public final static int BIT = -7; 032 033 /** 034 * <P>The constant in the Java programming language, sometimes referred 035 * to as a type code, that identifies the generic SQL type 036 * <code>TINYINT</code>. 037 */ 038 public final static int TINYINT = -6; 039 040 /** 041 * <P>The constant in the Java programming language, sometimes referred 042 * to as a type code, that identifies the generic SQL type 043 * <code>SMALLINT</code>. 044 */ 045 public final static int SMALLINT = 5; 046 047 /** 048 * <P>The constant in the Java programming language, sometimes referred 049 * to as a type code, that identifies the generic SQL type 050 * <code>INTEGER</code>. 051 */ 052 public final static int INTEGER = 4; 053 054 /** 055 * <P>The constant in the Java programming language, sometimes referred 056 * to as a type code, that identifies the generic SQL type 057 * <code>BIGINT</code>. 058 */ 059 public final static int BIGINT = -5; 060 061 /** 062 * <P>The constant in the Java programming language, sometimes referred 063 * to as a type code, that identifies the generic SQL type 064 * <code>FLOAT</code>. 065 */ 066 public final static int FLOAT = 6; 067 068 /** 069 * <P>The constant in the Java programming language, sometimes referred 070 * to as a type code, that identifies the generic SQL type 071 * <code>REAL</code>. 072 */ 073 public final static int REAL = 7; 074 075 076 /** 077 * <P>The constant in the Java programming language, sometimes referred 078 * to as a type code, that identifies the generic SQL type 079 * <code>DOUBLE</code>. 080 */ 081 public final static int DOUBLE = 8; 082 083 /** 084 * <P>The constant in the Java programming language, sometimes referred 085 * to as a type code, that identifies the generic SQL type 086 * <code>NUMERIC</code>. 087 */ 088 public final static int NUMERIC = 2; 089 090 /** 091 * <P>The constant in the Java programming language, sometimes referred 092 * to as a type code, that identifies the generic SQL type 093 * <code>DECIMAL</code>. 094 */ 095 public final static int DECIMAL = 3; 096 097 /** 098 * <P>The constant in the Java programming language, sometimes referred 099 * to as a type code, that identifies the generic SQL type 100 * <code>CHAR</code>. 101 */ 102 public final static int CHAR = 1; 103 104 /** 105 * <P>The constant in the Java programming language, sometimes referred 106 * to as a type code, that identifies the generic SQL type 107 * <code>VARCHAR</code>. 108 */ 109 public final static int VARCHAR = 12; 110 111 /** 112 * <P>The constant in the Java programming language, sometimes referred 113 * to as a type code, that identifies the generic SQL type 114 * <code>LONGVARCHAR</code>. 115 */ 116 public final static int LONGVARCHAR = -1; 117 118 119 /** 120 * <P>The constant in the Java programming language, sometimes referred 121 * to as a type code, that identifies the generic SQL type 122 * <code>DATE</code>. 123 */ 124 public final static int DATE = 91; 125 126 /** 127 * <P>The constant in the Java programming language, sometimes referred 128 * to as a type code, that identifies the generic SQL type 129 * <code>TIME</code>. 130 */ 131 public final static int TIME = 92; 132 133 /** 134 * <P>The constant in the Java programming language, sometimes referred 135 * to as a type code, that identifies the generic SQL type 136 * <code>TIMESTAMP</code>. 137 */ 138 public final static int TIMESTAMP = 93; 139 140 141 /** 142 * <P>The constant in the Java programming language, sometimes referred 143 * to as a type code, that identifies the generic SQL type 144 * <code>BINARY</code>. 145 */ 146 public final static int BINARY = -2; 147 148 /** 149 * <P>The constant in the Java programming language, sometimes referred 150 * to as a type code, that identifies the generic SQL type 151 * <code>VARBINARY</code>. 152 */ 153 public final static int VARBINARY = -3; 154 155 /** 156 * <P>The constant in the Java programming language, sometimes referred 157 * to as a type code, that identifies the generic SQL type 158 * <code>LONGVARBINARY</code>. 159 */ 160 public final static int LONGVARBINARY = -4; 161 162 /** 163 * <P>The constant in the Java programming language, sometimes referred 164 * to as a type code, that identifies the generic SQL type 165 * <code>NULL</code>. 166 */ 167 public final static int NULL = 0; 168 169 /** 170 * The constant in the Java programming language that indicates 171 * that the SQL type is database-specific and 172 * gets mapped to a Java object that can be accessed via 173 * the methods <code>getObject</code> and <code>setObject</code>. 174 */ 175 public final static int OTHER = 1111; 176 177 178 179 /** 180 * The constant in the Java programming language, sometimes referred to 181 * as a type code, that identifies the generic SQL type 182 * <code>JAVA_OBJECT</code>. 183 * @since 1.2 184 */ 185 public final static int JAVA_OBJECT = 2000; 186 187 /** 188 * The constant in the Java programming language, sometimes referred to 189 * as a type code, that identifies the generic SQL type 190 * <code>DISTINCT</code>. 191 * @since 1.2 192 */ 193 public final static int DISTINCT = 2001; 194 195 /** 196 * The constant in the Java programming language, sometimes referred to 197 * as a type code, that identifies the generic SQL type 198 * <code>STRUCT</code>. 199 * @since 1.2 200 */ 201 public final static int STRUCT = 2002; 202 203 /** 204 * The constant in the Java programming language, sometimes referred to 205 * as a type code, that identifies the generic SQL type 206 * <code>ARRAY</code>. 207 * @since 1.2 208 */ 209 public final static int ARRAY = 2003; 210 211 /** 212 * The constant in the Java programming language, sometimes referred to 213 * as a type code, that identifies the generic SQL type 214 * <code>BLOB</code>. 215 * @since 1.2 216 */ 217 public final static int BLOB = 2004; 218 219 /** 220 * The constant in the Java programming language, sometimes referred to 221 * as a type code, that identifies the generic SQL type 222 * <code>CLOB</code>. 223 * @since 1.2 224 */ 225 public final static int CLOB = 2005; 226 227 /** 228 * The constant in the Java programming language, sometimes referred to 229 * as a type code, that identifies the generic SQL type 230 * <code>REF</code>. 231 * @since 1.2 232 */ 233 public final static int REF = 2006; 234 235 /** 236 * The constant in the Java programming language, somtimes referred to 237 * as a type code, that identifies the generic SQL type <code>DATALINK</code>. 238 * 239 * @since 1.4 240 */ 241 public final static int DATALINK = 70; 242 243 /** 244 * The constant in the Java programming language, somtimes referred to 245 * as a type code, that identifies the generic SQL type <code>BOOLEAN</code>. 246 * 247 * @since 1.4 248 */ 249 public final static int BOOLEAN = 16; 250 251 public static final int IDSTAMP = CHAR;//TODO is this right? 252 }