source: branches/MetisMQI/src/main/java/weka/experiment/DatabaseUtils.props.hsql

Last change on this file was 29, checked in by gnappo, 14 years ago

Taggata versione per la demo e aggiunto branch.
File size: 3.2 KB
RevLine 
[29]1# Database settings for HSQLDB 1.8.x
2#
3# General information on database access can be found here:
4# http://weka.wikispaces.com/Databases
5#
6# url:     http://hsqldb.sourceforge.net/
7# jdbc:    http://sourceforge.net/projects/hsqldb/
8# howto:   http://hsqldb.sourceforge.net/doc/guide/ch01.html
9# author:  Dale Fletcher (dale at cs dot waikato dot ac dot nz)
10# version: $Revision: 5837 $
11
12# JDBC driver (comma-separated list)
13jdbcDriver=org.hsqldb.jdbcDriver
14
15# database URL
16jdbcURL=jdbc:hsqldb:hsql://server_name/database_name
17
18# specific data types
19# string, getString() = 0;    --> nominal
20# boolean, getBoolean() = 1;  --> nominal
21# double, getDouble() = 2;    --> numeric
22# byte, getByte() = 3;        --> numeric
23# short, getByte()= 4;        --> numeric
24# int, getInteger() = 5;      --> numeric
25# long, getLong() = 6;        --> numeric
26# float, getFloat() = 7;      --> numeric
27# date, getDate() = 8;        --> date
28# text, getString() = 9;      --> string
29# time, getTime() = 10;       --> date
30
31# other options
32CREATE_INT=INT
33CREATE_DOUBLE=DOUBLE
34CREATE_STRING=LONGVARCHAR
35CREATE_DATE=DATETIME
36DateFormat=yyyy-MM-dd HH:mm:ss
37checkUpperCaseNames=true
38checkLowerCaseNames=false
39checkForTable=true
40
41# All the reserved keywords for this database
42# Based on the keywords listed at the following URL (2009-04-13):
43# http://hsqldb.org/doc/guide/ch09.html
44Keywords=\
45  ABS,\
46  ACOS,\
47  ALIAS,\
48  ALL,\
49  ALTER,\
50  ASCII,\
51  ASIN,\
52  ATAN,\
53  ATAN2,\
54  AUTOCOMMIT,\
55  BITAND,\
56  BIT_LENGTH,\
57  BITOR,\
58  CACHED,\
59  CALL,\
60  CASEWHEN,\
61  CEILING,\
62  CHAR,\
63  CHAR_LENGTH,\
64  CHECKPOINT,\
65  COALESCE,\
66  COLLATION,\
67  COMMIT,\
68  CONCAT,\
69  CONNECT,\
70  CONVERT,\
71  COS,\
72  COT,\
73  CREATE,\
74  CURDATE,\
75  CURRENT_DATE,\
76  CURRENT_TIME,\
77  CURRENT_TIMESTAMP,\
78  CURRENT_USER,\
79  CURTIME,\
80  DATABASE,\
81  DAYNAME,\
82  DAYOFMONTH,\
83  DAYOFWEEK,\
84  DAYOFYEAR,\
85  DEFRAG,\
86  DEGREES,\
87  DELAY,\
88  DELETE,\
89  DIFFERENCE,\
90  DISCONNECT,\
91  DISTINCT,\
92  DROP,\
93  EXCEPT,\
94  EXP,\
95  EXPLAIN,\
96  EXTRACT,\
97  FLOOR,\
98  FROM,\
99  GRANT,\
100  GROUPBY,\
101  HAVING,\
102  HEXTORAW,\
103  HOUR,\
104  IDENTITY,\
105  IFNULL,\
106  IGNORECASE,\
107  INDEX,\
108  INITIAL,\
109  INSERT,\
110  INTEGRITY,\
111  INTERSECT,\
112  INTO,\
113  LCASE,\
114  LEFT,\
115  LENGTH,\
116  LIMIT,\
117  LOCATE,\
118  LOG,\
119  LOG10,\
120  LOGSIZE,\
121  LOWER,\
122  LTRIM,\
123  MAXROWS,\
124  MINUS,\
125  MINUTE,\
126  MOD,\
127  MONTH,\
128  MONTHNAME,\
129  NOW,\
130  NULLIF,\
131  OCTET_LENGTH,\
132  OFFSET,\
133  ORDERBY,\
134  PASSWORD,\
135  PI,\
136  PLAN,\
137  POWER,\
138  PROPERTY,\
139  QUARTER,\
140  RADIANS,\
141  RAND,\
142  RAWTOHEX,\
143  READONLY,\
144  REFERENTIAL,\
145  REPEAT,\
146  REPLACE,\
147  REVOKE,\
148  RIGHT,\
149  ROLE,\
150  ROLLBACK,\
151  ROUND,\
152  ROUNDMAGIC,\
153  RTRIM,\
154  SAVEPOINT,\
155  SCHEMA,\
156  SCRIPT,\
157  SCRIPTFORMAT,\
158  SECOND,\
159  SELECT,\
160  SEQUENCE,\
161  SET,\
162  SHUTDOWN,\
163  SIGN,\
164  SIN,\
165  SOUNDEX,\
166  SOURCE,\
167  SPACE,\
168  SQRT,\
169  SUBSTR,\
170  SUBSTRING,\
171  TABLE,\
172  TAN,\
173  TEMP,\
174  TEXT,\
175  TOP,\
176  TRIGGER,\
177  TRUNCATE,\
178  UCASE,\
179  UNION,\
180  UPDATE,\
181  UPPER,\
182  USER,\
183  VIEW,\
184  WEEK,\
185  WHERE,\
186  WRITE,\
187  YEAR
188
189# The character to append to attribute names to avoid exceptions due to
190# clashes between keywords and attribute names
191KeywordsMaskChar=_
192
193# flags for loading and saving instances using DatabaseLoader/Saver
194nominalToStringLimit=50
195idColumn=auto_generated_id
196
Note: See TracBrowser for help on using the repository browser.