source: src/main/java/weka/experiment/DatabaseUtils.props.mssqlserver @ 23

Last change on this file since 23 was 4, checked in by gnappo, 14 years ago

Import di weka.

File size: 3.6 KB
Line 
1# Database settings for Microsoft SQL Server 2000
2#
3# General information on database access can be found here:
4# http://weka.wikispaces.com/Databases
5#
6# url:     http://www.microsoft.com/
7# jdbc:    http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A
8# author:  Fracpete (fracpete at waikato dot ac dot nz)
9# version: $Revision: 5837 $
10
11# JDBC driver (comma-separated list)
12jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
13
14# database URL
15jdbcURL=jdbc:sqlserver://server_name:1433
16
17# specific data types
18# string, getString() = 0;    --> nominal
19# boolean, getBoolean() = 1;  --> nominal
20# double, getDouble() = 2;    --> numeric
21# byte, getByte() = 3;        --> numeric
22# short, getByte()= 4;        --> numeric
23# int, getInteger() = 5;      --> numeric
24# long, getLong() = 6;        --> numeric
25# float, getFloat() = 7;      --> numeric
26# date, getDate() = 8;        --> date
27# text, getString() = 9;      --> string
28# time, getTime() = 10;       --> date
29
30varchar=0
31float=2
32tinyint=3
33int=5
34
35# other options
36CREATE_DOUBLE=DOUBLE PRECISION
37CREATE_STRING=VARCHAR(8000)
38CREATE_INT=INT
39CREATE_DATE=DATETIME
40DateFormat=yyyy-MM-dd HH:mm:ss
41checkUpperCaseNames=false
42checkLowerCaseNames=false
43checkForTable=true
44
45# All the reserved keywords for this database
46# Based on the keywords listed at the following URL (2009-04-13):
47# http://msdn.microsoft.com/en-us/library/aa238507.aspx
48Keywords=\
49  ADD,\
50  ALL,\
51  ALTER,\
52  AND,\
53  ANY,\
54  AS,\
55  ASC,\
56  AUTHORIZATION,\
57  BACKUP,\
58  BEGIN,\
59  BETWEEN,\
60  BREAK,\
61  BROWSE,\
62  BULK,\
63  BY,\
64  CASCADE,\
65  CASE,\
66  CHECK,\
67  CHECKPOINT,\
68  CLOSE,\
69  CLUSTERED,\
70  COALESCE,\
71  COLLATE,\
72  COLUMN,\
73  COMMIT,\
74  COMPUTE,\
75  CONSTRAINT,\
76  CONTAINS,\
77  CONTAINSTABLE,\
78  CONTINUE,\
79  CONVERT,\
80  CREATE,\
81  CROSS,\
82  CURRENT,\
83  CURRENT_DATE,\
84  CURRENT_TIME,\
85  CURRENT_TIMESTAMP,\
86  CURRENT_USER,\
87  CURSOR,\
88  DATABASE,\
89  DBCC,\
90  DEALLOCATE,\
91  DECLARE,\
92  DEFAULT,\
93  DELETE,\
94  DENY,\
95  DESC,\
96  DISK,\
97  DISTINCT,\
98  DISTRIBUTED,\
99  DOUBLE,\
100  DROP,\
101  DUMMY,\
102  DUMP,\
103  ELSE,\
104  END,\
105  ERRLVL,\
106  ESCAPE,\
107  EXCEPT,\
108  EXEC,\
109  EXECUTE,\
110  EXISTS,\
111  EXIT,\
112  FETCH,\
113  FILE,\
114  FILLFACTOR,\
115  FOR,\
116  FOREIGN,\
117  FREETEXT,\
118  FREETEXTTABLE,\
119  FROM,\
120  FULL,\
121  FUNCTION,\
122  GOTO,\
123  GRANT,\
124  GROUP,\
125  HAVING,\
126  HOLDLOCK,\
127  IDENTITY,\
128  IDENTITYCOL,\
129  IDENTITY_INSERT,\
130  IF,\
131  IN,\
132  INDEX,\
133  INNER,\
134  INSERT,\
135  INTERSECT,\
136  INTO,\
137  IS,\
138  JOIN,\
139  KEY,\
140  KILL,\
141  LEFT,\
142  LIKE,\
143  LINENO,\
144  LOAD,\
145  NATIONAL,\
146  NOCHECK,\
147  NONCLUSTERED,\
148  NOT,\
149  NULL,\
150  NULLIF,\
151  OF,\
152  OFF,\
153  OFFSETS,\
154  ON,\
155  OPEN,\
156  OPENDATASOURCE,\
157  OPENQUERY,\
158  OPENROWSET,\
159  OPENXML,\
160  OPTION,\
161  OR,\
162  ORDER,\
163  OUTER,\
164  OVER,\
165  PERCENT,\
166  PLAN,\
167  PRECISION,\
168  PRIMARY,\
169  PRINT,\
170  PROC,\
171  PROCEDURE,\
172  PUBLIC,\
173  RAISERROR,\
174  READ,\
175  READTEXT,\
176  RECONFIGURE,\
177  REFERENCES,\
178  REPLICATION,\
179  RESTORE,\
180  RESTRICT,\
181  RETURN,\
182  REVOKE,\
183  RIGHT,\
184  ROLLBACK,\
185  ROWCOUNT,\
186  ROWGUIDCOL,\
187  RULE,\
188  SAVE,\
189  SCHEMA,\
190  SELECT,\
191  SESSION_USER,\
192  SET,\
193  SETUSER,\
194  SHUTDOWN,\
195  SOME,\
196  STATISTICS,\
197  SYSTEM_USER,\
198  TABLE,\
199  TEXTSIZE,\
200  THEN,\
201  TO,\
202  TOP,\
203  TRAN,\
204  TRANSACTION,\
205  TRIGGER,\
206  TRUNCATE,\
207  TSEQUAL,\
208  UNION,\
209  UNIQUE,\
210  UPDATE,\
211  UPDATETEXT,\
212  USE,\
213  USER,\
214  VALUES,\
215  VARYING,\
216  VIEW,\
217  WAITFOR,\
218  WHEN,\
219  WHERE,\
220  WHILE,\
221  WITH,\
222  WRITETEXT
223
224# The character to append to attribute names to avoid exceptions due to
225# clashes between keywords and attribute names
226KeywordsMaskChar=_
227
228#flags for loading and saving instances using DatabaseLoader/Saver
229nominalToStringLimit=50
230idColumn=auto_generated_id
231
Note: See TracBrowser for help on using the repository browser.