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    }