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

Go to download
Show more of this group Show more artifacts with this name
Show all versions of payara-micro Show documentation
Micro Distribution of the Payara Project
There is a newer version: 7.2024.1.Alpha1
#
# 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.
#

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

#mapping between jdbc and mssql 
TINYINT=TINYINT
DOUBLE=FLOAT
BIGINT=NUMERIC
BLOB=IMAGE
TIMESTAMP=DATETIME
DATE=DATETIME
TIME=DATETIME
CLOB=NTEXT

# MSSQL's default of 18 digits is not enough to store a long.
long.jdbc-precision = 19
java.lang.Long.jdbc-precision = 19

# create table and drop table definition
statementSeparator.sql-format=go

# Reserved words
reserved-words=BACKUP, BREAK, BROWSE, BULK, CHECKPOINT, CLUSTERED, COMPUTE, \
    CONTAINS, CONTAINSTABLE, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, \
    CURRENT_USER, DATABASE, DBCC, DENY, DISK, DISTRIBUTED, DUMMY, \
    DUMP, ERRLVL, EXIT, FILE, FILLFACTOR, FREETEXT, FREETEXTTABLE, \
    FUNCTION, HOLDLOCK, IDENTITYCOL, IDENTITY_INSERT, IF, INDEX, \
    KILL, LINENO, LOAD, NOCHECK, NONCLUSTERED, OFF, OFFSETS, OPENDATASOURCE, \
    OPENQUERY, OPENROWSET, OPENXML, OVER, PERCENT, PLAN, PRINT, PROC, \
    RAISERROR, READTEXT, RECONFIGURE, REPLICATION, RESTORE, RETURN, \
    ROWCOUNT, ROWGUIDCOL, RULE, SAVE, SESSION_USER, SETUSER, SHUTDOWN, \
    STATISTICS, SYSTEM_USER, TEXTSIZE, TOP, TRAN, TRIGGER, TRUNCATE, \
    TSEQUAL, UPDATETEXT, USE, WAITFOR, WHILE, WRITETEXT