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

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

Taggata versione per la demo e aggiunto branch.

File size: 2.2 KB
RevLine 
[29]1# General information on database access can be found here:
2# http://weka.wikispaces.com/Databases
3#
4# Version: $Revision: 5837 $
5
6# The comma-separated list of jdbc drivers to use
7#jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver
8#jdbcDriver=jdbc.idbDriver
9jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver,org.gjt.mm.mysql.Driver,com.mckoi.JDBCDriver,org.hsqldb.jdbcDriver
10#jdbcDriver=org.gjt.mm.mysql.Driver
11
12# The url to the experiment database
13#jdbcURL=jdbc:rmi://expserver/jdbc:idb=experiments.prp
14jdbcURL=jdbc:idb=experiments.prp
15#jdbcURL=jdbc:mysql://mysqlserver/username
16
17# the method that is used to retrieve values from the db
18# (java datatype + RecordSet.<method>)
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# the original conversion: <column type>=<conversion>
31#char=0
32#varchar=0
33#longvarchar=0
34#binary=0
35#varbinary=0
36#longvarbinary=0
37#bit=1
38#numeric=2
39#decimal=2
40#tinyint=3
41#smallint=4
42#integer=5
43#bigint=6
44#real=7
45#float=2
46#double=2
47#date=8
48#time=10
49#timestamp=8
50#mysql-conversion
51CHAR=0
52TEXT=0
53VARCHAR=0
54LONGVARCHAR=9
55BINARY=0
56VARBINARY=0
57LONGVARBINARY=9
58BIT=1
59NUMERIC=2
60DECIMAL=2
61FLOAT=2
62DOUBLE=2
63TINYINT=3
64SMALLINT=4
65#SHORT=4
66SHORT=5
67INTEGER=5
68BIGINT=6
69LONG=6
70REAL=7
71DATE=8
72TIME=10
73TIMESTAMP=8
74
75#mappings for table creation
76CREATE_STRING=TEXT
77CREATE_INT=INT
78CREATE_DOUBLE=DOUBLE
79CREATE_DATE=DATETIME
80DateFormat=yyyy-MM-dd HH:mm:ss
81
82#database flags
83checkUpperCaseNames=false
84checkLowerCaseNames=false
85checkForTable=true
86setAutoCommit=true
87createIndex=false
88
89# All the reserved keywords for this database
90Keywords=\
91  AND,\
92  ASC,\
93  BY,\
94  DESC,\
95  FROM,\
96  GROUP,\
97  INSERT,\
98  ORDER,\
99  SELECT,\
100  UPDATE,\
101  WHERE
102
103# The character to append to attribute names to avoid exceptions due to
104# clashes between keywords and attribute names
105KeywordsMaskChar=_
106
107#flags for loading and saving instances using DatabaseLoader/Saver
108nominalToStringLimit=50
109idColumn=auto_generated_id
Note: See TracBrowser for help on using the repository browser.