com.sun.jdo.spi.persistence.generator.database.DERBY.properties Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of payara-embedded-web Show documentation
Embedded-Web Distribution of the Payara Project
There is a newer version: 6.2024.6
#
# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
#
# Copyright (c) 1997-2010 Oracle and/or its affiliates. All rights reserved.
#
# The contents of this file are subject to the terms of either the GNU
# General Public License Version 2 only ("GPL") or the Common Development
# and Distribution License("CDDL") (collectively, the "License").  You
# may not use this file except in compliance with the License.  You can
# obtain a copy of the License at
# https://glassfish.dev.java.net/public/CDDL+GPL_1_1.html
# or packager/legal/LICENSE.txt.  See the License for the specific
# language governing permissions and limitations under the License.
#
# When distributing the software, include this License Header Notice in each
# file and include the License file at packager/legal/LICENSE.txt.
#
# GPL Classpath Exception:
# Oracle designates this particular file as subject to the "Classpath"
# exception as provided by Oracle in the GPL Version 2 section of the License
# file that accompanied this code.
#
# Modifications:
# If applicable, add the following below the License Header, with the fields
# enclosed by brackets [] replaced by your own identifying information:
# "Portions Copyright [year] [name of copyright owner]"
#
# Contributor(s):
# If you wish your version of this file to be governed by only the CDDL or
# only the GPL Version 2, indicate your decision by adding "[Contributor]
# elects to include this software in this distribution under the [CDDL or GPL
# Version 2] license."  If you don't indicate a single choice of license, a
# recipient has the option to distribute your version of this file under
# either the CDDL, the GPL Version 2 or to extend the choice of license to
# its licensees as provided above.  However, if you add GPL Version 2 code
# and therefore, elected the GPL Version 2 license, then the option applies
# only if the new code is made subject to such option by the copyright
# holder.
#

#mapping between jdbc and Derby
BIGINT=BIGINT
BIT=SMALLINT
CLOB=CLOB
REAL=FLOAT

# LOBs must be 2 GB or less.
BLOB.jdbc-maximum-length=2147483647
CLOB.jdbc-maximum-length=2147483647

# DERBY supports precision of only up to 31
java.math.BigDecimal.jdbc-precision = 31
java.math.BigInteger.jdbc-precision = 31

# maximum length for table name, column name and constraint name
table-name.maximum-length=128
column-name.maximum-length=30
constraint-name.maximum-length=18

#
# Properties to indicate how to format SQL
#

# Text used to indicate that a column is nullable
# (Yes, it is supposed to be the empty string)
columnNullability.sql-format=

# Reserved words
reserved-words=ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC, ASSERTION, \
AT, AUTHORIZATION, AVG, BEGIN, BETWEEN, BIT, BIT_LENGTH, BOOLEAN, BOTH, BY, \
CALL, CASCADE, CASCADED, CASE, CAST, CHAR, CHARACTER, CHARACTER_LENGTH, \
CHAR_LENGTH, CHECK, CLOSE, COLLATE, COLLATION, COLUMN, COMMIT, CONNECT, \
CONNECTION, CONSTRAINT, CONSTRAINTS, CONTINUE, CONVERT, CORRESPONDING, \
COUNT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, \
CURRENT_USER, CURSOR, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFERRABLE, DEFERRED, \
DELETE, DESC, DESCRIBE, DIAGNOSTICS, DISCONNECT, DISTINCT, DOUBLE, DROP, ELSE, \
END, ENDEXEC, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS, EXPLAIN, \
EXTERNAL, EXTRACT, FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FOUND, FROM, \
FULL, FUNCTION, GET, GET_CURRENT_CONNECTION, GLOBAL, GO, GOTO, GRANT, GROUP, \
HAVING, HOUR, IDENTITY, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INOUT, \
INPUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTO, IS, ISOLATION, JOIN, \
KEY, LAST, LEADING, LEFT, LIKE, LOCAL, LONGINT, LOWER, LTRIM, MATCH, MAX, MIN, \
MINUTE, NATIONAL, NATURAL, NCHAR, NVARCHAR, NEXT, NO, NOT, NULL, NULLIF, \
NUMERIC, OCTET_LENGTH, OF, ON, ONLY, OPEN, OPTION, OR, ORDER, OUT, OUTER, \
OUTPUT, OVERLAPS, PAD, PARTIAL, PREPARE, PRESERVE, PRIMARY, PRIOR, PRIVILEGES, \
PROCEDURE, PUBLIC, READ, REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, \
ROLLBACK, ROWS, RTRIM, RUNTIMESTATISTICS, SCHEMA, SCROLL, SECOND, SELECT, \
SESSION_USER, SET, SMALLINT, SOME, SPACE, SQL, SQLCODE, SQLERROR, SQLSTATE, \
SUBSTR, SUBSTRING, SUM, SYSTEM_USER, TABLE, TEMPORARY, TIMEZONE_HOUR, \
TIMEZONE_MINUTE, TINYINT, TO, TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, \
TRIM, TRUE, UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USER, USING, VALUES, \
VARCHAR, VARYING, VIEW, WHENEVER, WHERE, WITH, WORK, WRITE, YEAR