KickJava   Java API By Example, From Geeks To Geeks.

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


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.util.logging.Logger JavaDoc;
36
37 /**
38  * Abstract way of grabbing data from the JDBC connection.
39  */
40 public class PostgresMetaData extends JdbcMetaData {
41   private static final Logger JavaDoc log = Log.open(PostgresMetaData.class);
42
43   protected PostgresMetaData(DataSource JavaDoc ds)
44   {
45     super(ds);
46   }
47
48   /**
49    * Returns true if sequences are supported.
50    */
51   public boolean supportsSequences()
52   {
53     return true;
54   }
55
56   /**
57    * Returns a sequence select expression.
58    */
59   public String JavaDoc createSequenceSQL(String JavaDoc name, int size)
60   {
61     if (size > 1)
62       return "CREATE SEQUENCE " + name + " INCREMENT " + size;
63     else
64       return "CREATE SEQUENCE " + name;
65   }
66
67   /**
68    * Returns a sequence select expression.
69    */
70   public String JavaDoc selectSequenceSQL(String JavaDoc name)
71   {
72     return "SELECT Nextval('" + name + "')";
73   }
74
75   /**
76    * Returns a sequence select expression.
77    */
78   public String JavaDoc testSequenceSQL(String JavaDoc name)
79   {
80     return "SELECT Currval('" + name + "')";
81   }
82
83   /**
84    * Returns the code to test for a boolean value for a term.
85    */
86   public String JavaDoc generateBoolean(String JavaDoc term)
87   {
88     return "(" + term + " = 't')";
89   }
90 }
91
Popular Tags