source: src/main/java/weka/experiment/DatabaseUtils.props.mssqlserver2005 @ 11

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

Import di weka.

File size: 3.6 KB
RevLine 
[4]1# Database settings for Microsoft SQL Server 2005 Express Edition
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://msdn2.microsoft.com/en-us/data/aa937724.aspx
8# author:  Fracpete (fracpete at waikato dot ac dot nz)
9# version: $Revision: 5837 $
10
11# JDBC driver (comma-separated list)
12jdbcDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
13
14# database URL
15jdbcURL=jdbc:sqlserver://localhost;databaseName=blahblah
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/ms189822(SQL.90).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  DUMP,\
102  ELSE,\
103  END,\
104  ERRLVL,\
105  ESCAPE,\
106  EXCEPT,\
107  EXEC,\
108  EXECUTE,\
109  EXISTS,\
110  EXIT,\
111  EXTERNAL,\
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  PIVOT,\
167  PLAN,\
168  PRECISION,\
169  PRIMARY,\
170  PRINT,\
171  PROC,\
172  PROCEDURE,\
173  PUBLIC,\
174  RAISERROR,\
175  READ,\
176  READTEXT,\
177  RECONFIGURE,\
178  REFERENCES,\
179  REPLICATION,\
180  RESTORE,\
181  RESTRICT,\
182  RETURN,\
183  REVERT,\
184  REVOKE,\
185  RIGHT,\
186  ROLLBACK,\
187  ROWCOUNT,\
188  ROWGUIDCOL,\
189  RULE,\
190  SAVE,\
191  SCHEMA,\
192  SECURITYAUDIT,\
193  SELECT,\
194  SESSION_USER,\
195  SET,\
196  SETUSER,\
197  SHUTDOWN,\
198  SOME,\
199  STATISTICS,\
200  SYSTEM_USER,\
201  TABLE,\
202  TABLESAMPLE,\
203  TEXTSIZE,\
204  THEN,\
205  TO,\
206  TOP,\
207  TRAN,\
208  TRANSACTION,\
209  TRIGGER,\
210  TRUNCATE,\
211  TSEQUAL,\
212  UNION,\
213  UNIQUE,\
214  UNPIVOT,\
215  UPDATE,\
216  UPDATETEXT,\
217  USE,\
218  USER,\
219  VALUES,\
220  VARYING,\
221  VIEW,\
222  WAITFOR,\
223  WHEN,\
224  WHERE,\
225  WHILE,\
226  WITH,\
227  WRITETEXT
228
229# The character to append to attribute names to avoid exceptions due to
230# clashes between keywords and attribute names
231KeywordsMaskChar=_
232
233#flags for loading and saving instances using DatabaseLoader/Saver
234nominalToStringLimit=50
235idColumn=auto_generated_id
236
Note: See TracBrowser for help on using the repository browser.