/
MsSql2000DatabasePlatform.java
146 lines (123 loc) · 4.94 KB
/
MsSql2000DatabasePlatform.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
/**
* Licensed to JumpMind Inc under one or more contributor
* license agreements. See the NOTICE file distributed
* with this work for additional information regarding
* copyright ownership. JumpMind Inc licenses this file
* to you under the GNU General Public License, version 3.0 (GPLv3)
* (the "License"); you may not use this file except in compliance
* with the License.
*
* You should have received a copy of the GNU General Public License,
* version 3.0 (GPLv3) along with this library; if not, see
* <http://www.gnu.org/licenses/>.
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.jumpmind.db.platform.mssql;
import javax.sql.DataSource;
import org.apache.commons.lang.StringUtils;
import org.jumpmind.db.model.Column;
import org.jumpmind.db.platform.AbstractJdbcDatabasePlatform;
import org.jumpmind.db.platform.DatabaseNamesConstants;
import org.jumpmind.db.platform.IDdlBuilder;
import org.jumpmind.db.platform.PermissionResult;
import org.jumpmind.db.platform.PermissionResult.Status;
import org.jumpmind.db.platform.PermissionType;
import org.jumpmind.db.sql.SqlException;
import org.jumpmind.db.sql.SqlTemplateSettings;
/*
* The platform implementation for the Microsoft SQL Server 2000 database.
*/
public class MsSql2000DatabasePlatform extends AbstractJdbcDatabasePlatform {
/* The standard SQLServer jdbc driver. */
public static final String JDBC_DRIVER = "net.sourceforge.jtds.jdbc.Driver";
/* The sub protocol used by the standard SQL Server driver. */
public static final String JDBC_SUBPROTOCOL = "jtds";
/*
* Creates a new platform instance.
*/
public MsSql2000DatabasePlatform(DataSource dataSource, SqlTemplateSettings settings) {
super(dataSource, settings);
}
@Override
protected IDdlBuilder createDdlBuilder() {
return new MsSql2000DdlBuilder();
}
@Override
protected MsSqlDdlReader createDdlReader() {
return new MsSqlDdlReader(this);
}
@Override
protected MsSqlJdbcSqlTemplate createSqlTemplate() {
return new MsSqlJdbcSqlTemplate(dataSource, settings, getDatabaseInfo());
}
public String getName() {
return DatabaseNamesConstants.MSSQL2000;
}
public String getDefaultCatalog() {
if (StringUtils.isBlank(defaultCatalog)) {
defaultCatalog = (String) getSqlTemplate().queryForObject("select DB_NAME()", String.class);
}
return defaultCatalog;
}
public String getDefaultSchema() {
if (StringUtils.isBlank(defaultSchema)) {
defaultSchema = (String) getSqlTemplate().queryForObject("select current_user", String.class);
}
return defaultSchema;
}
@Override
public boolean isClob(int type) {
return super.isClob(type) ||
// SQL-Server ntext binary type
type == -10;
}
@Override
public boolean canColumnBeUsedInWhereClause(Column column) {
return !column.isOfBinaryType();
}
@Override
protected Object parseFloat(String value) {
return cleanNumber(value).replace(',', '.');
}
@Override
public PermissionResult getCreateSymTriggerPermission() {
String delimiter = getDatabaseInfo().getDelimiterToken();
delimiter = delimiter != null ? delimiter : "";
String triggerSql = "CREATE TRIGGER TEST_TRIGGER ON " + delimiter + PERMISSION_TEST_TABLE_NAME + delimiter
+ " AFTER UPDATE AS SELECT 1 GO";
PermissionResult result = new PermissionResult(PermissionType.CREATE_TRIGGER, triggerSql);
try {
getSqlTemplate().update(triggerSql);
result.setStatus(Status.PASS);
} catch (SqlException e) {
result.setException(e);
result.setSolution("Grant CREATE TRIGGER permission or TRIGGER permission");
}
return result;
}
@Override
public PermissionResult getCreateSymFunctionPermission() {
String routineSql = "CREATE FUNCTION TEST_FUNC() RETURNS INTEGER BEGIN RETURN 1; END";
String dropSql = "IF OBJECT_ID('TEST_FUNC') IS NOT NULL DROP FUNCTION TEST_FUNC";
PermissionResult result = new PermissionResult(PermissionType.CREATE_FUNCTION,
dropSql + "\r\n" + routineSql + "\r\n" + dropSql);
try {
getSqlTemplate().update(dropSql);
getSqlTemplate().update(routineSql);
getSqlTemplate().update(dropSql);
result.setStatus(Status.PASS);
} catch (SqlException e) {
result.setException(e);
if (result.getSolution() != null) {
result.setSolution("Grant CREATE FUNCTION Privilege");
}
}
return result;
}
}