source: src/main/java/weka/experiment/DatabaseUtils.props.msaccess @ 15

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

Import di weka.

File size: 3.9 KB
Line 
1# Database settings for ODBC in conjunction with MS Access 2000
2#
3# General information on database access can be found here:
4# http://weka.wikispaces.com/Databases
5#
6# url:     http://weka.wikispaces.com/Windows+Databases
7# author:  Fracpete (fracpete at waikato dot ac dot nz)
8# version: $Revision: 5837 $
9
10# JDBC driver (comma-separated list)
11jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
12
13# database URL
14jdbcURL=jdbc:odbc:DSN_Name
15
16# specific data types
17# string, getString() = 0;    --> nominal
18# boolean, getBoolean() = 1;  --> nominal
19# double, getDouble() = 2;    --> numeric
20# byte, getByte() = 3;        --> numeric
21# short, getByte()= 4;        --> numeric
22# int, getInteger() = 5;      --> numeric
23# long, getLong() = 6;        --> numeric
24# float, getFloat() = 7;      --> numeric
25# date, getDate() = 8;        --> date
26# text, getString() = 9;      --> string
27# time, getTime() = 10;       --> date
28
29varchar=0
30float=2
31tinyint=3
32int=5
33text=0
34
35# other options
36CREATE_DOUBLE=DOUBLE
37CREATE_STRING=TEXT
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://support.microsoft.com/default.aspx?scid=kb;en-us;286335
48Keywords=\
49  ADD,\
50  ALL,\
51  ALTER,\
52  AND,\
53  ANY,\
54  AS,\
55  ASC,\
56  AUTOINCREMENT,\
57  Alphanumeric,\
58  Application,\
59  Assistant,\
60  Avg,\
61  BETWEEN,\
62  BINARY,\
63  BIT,\
64  BOOLEAN,\
65  BY,\
66  BYTE,\
67  CHAR,\
68  CHARACTER,\
69  COLUMN,\
70  CONSTRAINT,\
71  COUNTER,\
72  CREATE,\
73  CURRENCY,\
74  CompactDatabase,\
75  Container,\
76  Count,\
77  CreateDatabase,\
78  CreateField,\
79  CreateGroup,\
80  CreateIndex,\
81  CreateObject,\
82  CreateProperty,\
83  CreateRelation,\
84  CreateTableDef,\
85  CreateUser,\
86  CreateWorkspace,\
87  CurrentUser,\
88  DATABASE,\
89  DATE,\
90  DATETIME,\
91  DELETE,\
92  DESC,\
93  DISALLOW,\
94  DISTINCT,\
95  DISTINCTROW,\
96  DOUBLE,\
97  DROP,\
98  Description,\
99  Document,\
100  EXISTS,\
101  Echo,\
102  Else,\
103  End,\
104  Eqv,\
105  Error,\
106  Exit,\
107  FALSE,\
108  FLOAT,\
109  FLOAT4,\
110  FLOAT8,\
111  FOREIGN,\
112  FROM,\
113  FUNCTION,\
114  Field,\
115  Fields,\
116  FillCache,\
117  Form,\
118  Forms,\
119  Full,\
120  GENERAL,\
121  GROUP,\
122  GROUPBY,\
123  GUID,\
124  GetObject,\
125  GetOption,\
126  GotoPage,\
127  HAVING,\
128  IEEEDOUBLE,\
129  IEEESINGLE,\
130  IGNORE,\
131  IN,\
132  INDEX,\
133  INNER,\
134  INSERT,\
135  INT,\
136  INTEGER,\
137  INTEGER1,\
138  INTEGER2,\
139  INTEGER4,\
140  INTO,\
141  IS,\
142  Idle,\
143  If,\
144  Imp,\
145  Index,\
146  Indexes,\
147  InsertText,\
148  JOIN,\
149  KEY,\
150  LEFT,\
151  LOGICAL,\
152  LOGICAL1,\
153  LONG,\
154  LONGBINARY,\
155  LONGTEXT,\
156  LastModified,\
157  Level,\
158  Like,\
159  MEMO,\
160  MONEY,\
161  Macro,\
162  Match,\
163  Max,\
164  Min,\
165  Mod,\
166  Module,\
167  Move,\
168  NAME,\
169  NO,\
170  NULL,\
171  NUMBER,\
172  NUMERIC,\
173  NewPassword,\
174  Not,\
175  Note,\
176  OFF,\
177  OLEOBJECT,\
178  ON,\
179  OPTION,\
180  OR,\
181  ORDER,\
182  OWNERACCESS,\
183  Object,\
184  OpenRecordset,\
185  Orientation,\
186  Outer,\
187  PARAMETERS,\
188  PERCENT,\
189  PIVOT,\
190  PRIMARY,\
191  PROCEDURE,\
192  Parameter,\
193  Partial,\
194  Property,\
195  Queries,\
196  Query,\
197  Quit,\
198  REAL,\
199  REFERENCES,\
200  RIGHT,\
201  Recalc,\
202  Recordset,\
203  Refresh,\
204  RefreshLink,\
205  RegisterDatabase,\
206  Relation,\
207  Repaint,\
208  RepairDatabase,\
209  Report,\
210  Reports,\
211  Requery,\
212  SCREEN,\
213  SECTION,\
214  SELECT,\
215  SET,\
216  SHORT,\
217  SINGLE,\
218  SMALLINT,\
219  SOME,\
220  SQL,\
221  STRING,\
222  SetFocus,\
223  SetOption,\
224  StDev,\
225  StDevP,\
226  Sum,\
227  TABLE,\
228  TEXT,\
229  TIME,\
230  TIMESTAMP,\
231  TOP,\
232  TRANSFORM,\
233  TRUE,\
234  TableDef,\
235  TableDefs,\
236  TableID,\
237  Type,\
238  UNION,\
239  UNIQUE,\
240  UPDATE,\
241  USER,\
242  VALUE,\
243  VALUES,\
244  VARBINARY,\
245  VARCHAR,\
246  VERSION,\
247  Var,\
248  VarP,\
249  WHERE,\
250  WITH,\
251  Workspace,\
252  Xor,\
253  YES,\
254  YESNO,\
255  Year
256
257# The character to append to attribute names to avoid exceptions due to
258# clashes between keywords and attribute names
259KeywordsMaskChar=_
260
261#flags for loading and saving instances using DatabaseLoader/Saver
262nominalToStringLimit=50
263idColumn=auto_generated_id
264
Note: See TracBrowser for help on using the repository browser.