KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > caucho > jdbc > OracleMetaData


1 /*
2  * Copyright (c) 1998-2006 Caucho Technology -- all rights reserved
3  *
4  * This file is part of Resin(R) Open Source
5  *
6  * Each copy or derived work must preserve the copyright notice and this
7  * notice unmodified.
8  *
9  * Resin Open Source is free software; you can redistribute it and/or modify
10  * it under the terms of the GNU General Public License as published by
11  * the Free Software Foundation; either version 2 of the License, or
12  * (at your option) any later version.
13  *
14  * Resin Open Source is distributed in the hope that it will be useful,
15  * but WITHOUT ANY WARRANTY; without even the implied warranty of
16  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty
17  * of NON-INFRINGEMENT. See the GNU General Public License for more
18  * details.
19  *
20  * You should have received a copy of the GNU General Public License
21  * along with Resin Open Source; if not, write to the
22  *
23  * Free Software Foundation, Inc.
24  * 59 Temple Place, Suite 330
25  * Boston, MA 02111-1307 USA
26  *
27  * @author Scott Ferguson
28  */
29
30 package com.caucho.jdbc;
31
32 import com.caucho.util.Log;
33
34 import javax.sql.DataSource JavaDoc;
35 import java.sql.Types JavaDoc;
36 import java.util.logging.Logger JavaDoc;
37
38 /**
39  * Abstract way of grabbing data from the JDBC connection.
40  */
41 public class OracleMetaData extends JdbcMetaData {
42   private static final Logger JavaDoc log = Log.open(OracleMetaData.class);
43
44   protected OracleMetaData(DataSource JavaDoc ds)
45   {
46     super(ds);
47   }
48
49   /**
50    * True if blobs must be truncated on delete.
51    */
52   public boolean isTruncateBlobBeforeDelete()
53   {
54     return true;
55   }
56   
57   /**
58    * Returns the SQL for the table with the given SQL type.
59    */
60   public String JavaDoc getCreateColumnSQL(int sqlType, int length, int precision, int scale)
61   {
62     // the oracle metadata doesn't return a proper value for data/time
63 switch (sqlType) {
64     case Types.DATE:
65     case Types.TIME:
66       return "DATE";
67     case Types.DOUBLE:
68       return "DOUBLE PRECISION";
69     }
70
71     return super.getCreateColumnSQL(sqlType, length, precision, scale);
72   }
73
74   /**
75    * Returns true if sequences are supported.
76    */
77   public boolean supportsSequences()
78   {
79     return true;
80   }
81
82   /**
83    * Returns a sequence select expression.
84    */
85   public String JavaDoc createSequenceSQL(String JavaDoc name, int size)
86   {
87     if (size > 1)
88       return "CREATE SEQUENCE " + name + " INCREMENT BY " + size;
89     else
90       return "CREATE SEQUENCE " + name;
91   }
92
93   /**
94    * Returns a sequence select expression.
95    */
96   public String JavaDoc selectSequenceSQL(String JavaDoc name)
97   {
98     return "SELECT " + name + ".nextval FROM DUAL";
99   }
100 }
101
Popular Tags