[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 |
---|
| 9 | jdbcDriver=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 |
---|
| 14 | jdbcURL=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 |
---|
| 51 | CHAR=0 |
---|
| 52 | TEXT=0 |
---|
| 53 | VARCHAR=0 |
---|
| 54 | LONGVARCHAR=9 |
---|
| 55 | BINARY=0 |
---|
| 56 | VARBINARY=0 |
---|
| 57 | LONGVARBINARY=9 |
---|
| 58 | BIT=1 |
---|
| 59 | NUMERIC=2 |
---|
| 60 | DECIMAL=2 |
---|
| 61 | FLOAT=2 |
---|
| 62 | DOUBLE=2 |
---|
| 63 | TINYINT=3 |
---|
| 64 | SMALLINT=4 |
---|
| 65 | #SHORT=4 |
---|
| 66 | SHORT=5 |
---|
| 67 | INTEGER=5 |
---|
| 68 | BIGINT=6 |
---|
| 69 | LONG=6 |
---|
| 70 | REAL=7 |
---|
| 71 | DATE=8 |
---|
| 72 | TIME=10 |
---|
| 73 | TIMESTAMP=8 |
---|
| 74 | |
---|
| 75 | #mappings for table creation |
---|
| 76 | CREATE_STRING=TEXT |
---|
| 77 | CREATE_INT=INT |
---|
| 78 | CREATE_DOUBLE=DOUBLE |
---|
| 79 | CREATE_DATE=DATETIME |
---|
| 80 | DateFormat=yyyy-MM-dd HH:mm:ss |
---|
| 81 | |
---|
| 82 | #database flags |
---|
| 83 | checkUpperCaseNames=false |
---|
| 84 | checkLowerCaseNames=false |
---|
| 85 | checkForTable=true |
---|
| 86 | setAutoCommit=true |
---|
| 87 | createIndex=false |
---|
| 88 | |
---|
| 89 | # All the reserved keywords for this database |
---|
| 90 | Keywords=\ |
---|
| 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 |
---|
| 105 | KeywordsMaskChar=_ |
---|
| 106 | |
---|
| 107 | #flags for loading and saving instances using DatabaseLoader/Saver |
---|
| 108 | nominalToStringLimit=50 |
---|
| 109 | idColumn=auto_generated_id |
---|