01: /*
02: * Copyright (c) 1998-2008 Caucho Technology -- all rights reserved
03: *
04: * This file is part of Resin(R) Open Source
05: *
06: * Each copy or derived work must preserve the copyright notice and this
07: * notice unmodified.
08: *
09: * 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: * Free SoftwareFoundation, Inc.
23: * 59 Temple Place, Suite 330
24: * Boston, MA 02111-1307 USA
25: *
26: * @author Scott Ferguson
27: */
28:
29: package com.caucho.jdbc;
30:
31: import com.caucho.util.Log;
32:
33: import javax.sql.DataSource;
34: import java.util.logging.Logger;
35:
36: /**
37: * Metadata for the MySQL database.
38: */
39: public class MysqlMetaData extends GenericMetaData {
40: private static final Logger log = Log.open(MysqlMetaData.class);
41:
42: protected MysqlMetaData(DataSource ds) {
43: super (ds);
44: }
45:
46: /**
47: * Returns the literal for FALSE.
48: */
49: public String getFalseLiteral() {
50: return "0";
51: }
52:
53: /**
54: * Returns true if identity is supported.
55: */
56: public boolean supportsIdentity() {
57: return true;
58: }
59:
60: /**
61: * Returns true if the POSITION function is supported.
62: */
63: public boolean supportsPositionFunction() {
64: return true;
65: }
66:
67: /**
68: * Returns true if table list with UPDATE is supported:
69: * UPDATE table1 a, table2 b SET ...
70: */
71: public boolean supportsUpdateTableList() {
72: return true;
73: }
74:
75: /**
76: * Returns the identity property
77: */
78: public String createIdentitySQL(String sqlType) {
79: return sqlType + " auto_increment";
80: }
81:
82: /**
83: * Returns a limit.
84: */
85: public String limit(String sql, int limit) {
86: if (limit < 0)
87: return sql;
88: else
89: return sql + " LIMIT " + limit;
90: }
91: }
|