source: src/main/java/weka/experiment/DatabaseUtils.props.oracle @ 13

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

Import di weka.
File size: 2.7 KB
RevLine 
[4]1# Database settings for Oracle 10g Express Edition
2#
3# General information on database access can be found here:
4# http://weka.wikispaces.com/Databases
5#
6# url:     http://www.oracle.com/
7# jdbc:    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/
8# author:  Fracpete (fracpete at waikato dot ac dot nz)
9# version: $Revision: 5837 $
10
11# JDBC driver (comma-separated list)
12jdbcDriver=oracle.jdbc.driver.OracleDriver
13
14# database URL
15jdbcURL=jdbc:oracle:thin:@server_name:1521:XE
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
30VARCHAR2=0
31NUMBER=2
32DOUBLE_PRECISION=2
33TIMESTAMP=8
34
35# other options
36CREATE_INT=INTEGER
37CREATE_STRING=VARCHAR2(4000)
38CREATE_DOUBLE=NUMBER
39CREATE_DATE=TIMESTAMP
40DateFormat=yyyy-MM-dd HH:mm:ss
41checkUpperCaseNames=true
42checkForTable=true
43
44# All the reserved keywords for this database
45# Based on the keywords listed at the following URL (2009-04-13):
46# http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_keywd.htm
47Keywords=\
48  ACCESS,\
49  ADD,\
50  ALL,\
51  ALTER,\
52  AND,\
53  ANY,\
54  AS,\
55  ASC,\
56  AUDIT,\
57  BETWEEN,\
58  BY,\
59  CHAR,\
60  CHECK,\
61  CLUSTER,\
62  COLUMN,\
63  COMMENT,\
64  COMPRESS,\
65  CONNECT,\
66  CREATE,\
67  CURRENT,\
68  DATE,\
69  DECIMAL,\
70  DEFAULT,\
71  DELETE,\
72  DESC,\
73  DISTINCT,\
74  DROP,\
75  ELSE,\
76  EXCLUSIVE,\
77  EXISTS,\
78  FILE,\
79  FLOAT,\
80  FOR,\
81  FROM,\
82  GRANT,\
83  GROUP,\
84  HAVING,\
85  IDENTIFIED,\
86  IMMEDIATE,\
87  IN,\
88  INCREMENT,\
89  INDEX,\
90  INITIAL,\
91  INSERT,\
92  INTEGER,\
93  INTERSECT,\
94  INTO,\
95  IS,\
96  LEVEL,\
97  LIKE,\
98  LOCK,\
99  LONG,\
100  MAXEXTENTS,\
101  MINUS,\
102  MLSLABEL,\
103  MODE,\
104  MODIFY,\
105  NOAUDIT,\
106  NOCOMPRESS,\
107  NOT,\
108  NOWAIT,\
109  NULL,\
110  NUMBER,\
111  OF,\
112  OFFLINE,\
113  ON,\
114  ONLINE,\
115  OPTION,\
116  OR,\
117  ORDER,\
118  PCTFREE,\
119  PRIOR,\
120  PRIVILEGES,\
121  PUBLIC,\
122  RAW,\
123  RENAME,\
124  RESOURCE,\
125  REVOKE,\
126  ROW,\
127  ROWID,\
128  ROWNUM,\
129  ROWS,\
130  SELECT,\
131  SESSION,\
132  SET,\
133  SHARE,\
134  SIZE,\
135  SMALLINT,\
136  START,\
137  SUCCESSFUL,\
138  SYNONYM,\
139  SYSDATE,\
140  TABLE,\
141  THEN,\
142  TO,\
143  TRIGGER,\
144  UID,\
145  UNION,\
146  UNIQUE,\
147  UPDATE,\
148  USER,\
149  VALIDATE,\
150  VALUES,\
151  VARCHAR,\
152  VARCHAR2,\
153  VIEW,\
154  WHENEVER,\
155  WHERE,\
156  WITH
157
158# The character to append to attribute names to avoid exceptions due to
159# clashes between keywords and attribute names
160KeywordsMaskChar=_
161
162#flags for loading and saving instances using DatabaseLoader/Saver
163nominalToStringLimit=50
164idColumn=auto_generated_id
165
Note: See TracBrowser for help on using the repository browser.