[4] | 1 | # Database settings for Microsoft SQL Server 2000 |
---|
| 2 | # |
---|
| 3 | # General information on database access can be found here: |
---|
| 4 | # http://weka.wikispaces.com/Databases |
---|
| 5 | # |
---|
| 6 | # url: http://www.microsoft.com/ |
---|
| 7 | # jdbc: http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A |
---|
| 8 | # author: Fracpete (fracpete at waikato dot ac dot nz) |
---|
| 9 | # version: $Revision: 5837 $ |
---|
| 10 | |
---|
| 11 | # JDBC driver (comma-separated list) |
---|
| 12 | jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver |
---|
| 13 | |
---|
| 14 | # database URL |
---|
| 15 | jdbcURL=jdbc:sqlserver://server_name:1433 |
---|
| 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 | |
---|
| 30 | varchar=0 |
---|
| 31 | float=2 |
---|
| 32 | tinyint=3 |
---|
| 33 | int=5 |
---|
| 34 | |
---|
| 35 | # other options |
---|
| 36 | CREATE_DOUBLE=DOUBLE PRECISION |
---|
| 37 | CREATE_STRING=VARCHAR(8000) |
---|
| 38 | CREATE_INT=INT |
---|
| 39 | CREATE_DATE=DATETIME |
---|
| 40 | DateFormat=yyyy-MM-dd HH:mm:ss |
---|
| 41 | checkUpperCaseNames=false |
---|
| 42 | checkLowerCaseNames=false |
---|
| 43 | checkForTable=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://msdn.microsoft.com/en-us/library/aa238507.aspx |
---|
| 48 | Keywords=\ |
---|
| 49 | ADD,\ |
---|
| 50 | ALL,\ |
---|
| 51 | ALTER,\ |
---|
| 52 | AND,\ |
---|
| 53 | ANY,\ |
---|
| 54 | AS,\ |
---|
| 55 | ASC,\ |
---|
| 56 | AUTHORIZATION,\ |
---|
| 57 | BACKUP,\ |
---|
| 58 | BEGIN,\ |
---|
| 59 | BETWEEN,\ |
---|
| 60 | BREAK,\ |
---|
| 61 | BROWSE,\ |
---|
| 62 | BULK,\ |
---|
| 63 | BY,\ |
---|
| 64 | CASCADE,\ |
---|
| 65 | CASE,\ |
---|
| 66 | CHECK,\ |
---|
| 67 | CHECKPOINT,\ |
---|
| 68 | CLOSE,\ |
---|
| 69 | CLUSTERED,\ |
---|
| 70 | COALESCE,\ |
---|
| 71 | COLLATE,\ |
---|
| 72 | COLUMN,\ |
---|
| 73 | COMMIT,\ |
---|
| 74 | COMPUTE,\ |
---|
| 75 | CONSTRAINT,\ |
---|
| 76 | CONTAINS,\ |
---|
| 77 | CONTAINSTABLE,\ |
---|
| 78 | CONTINUE,\ |
---|
| 79 | CONVERT,\ |
---|
| 80 | CREATE,\ |
---|
| 81 | CROSS,\ |
---|
| 82 | CURRENT,\ |
---|
| 83 | CURRENT_DATE,\ |
---|
| 84 | CURRENT_TIME,\ |
---|
| 85 | CURRENT_TIMESTAMP,\ |
---|
| 86 | CURRENT_USER,\ |
---|
| 87 | CURSOR,\ |
---|
| 88 | DATABASE,\ |
---|
| 89 | DBCC,\ |
---|
| 90 | DEALLOCATE,\ |
---|
| 91 | DECLARE,\ |
---|
| 92 | DEFAULT,\ |
---|
| 93 | DELETE,\ |
---|
| 94 | DENY,\ |
---|
| 95 | DESC,\ |
---|
| 96 | DISK,\ |
---|
| 97 | DISTINCT,\ |
---|
| 98 | DISTRIBUTED,\ |
---|
| 99 | DOUBLE,\ |
---|
| 100 | DROP,\ |
---|
| 101 | DUMMY,\ |
---|
| 102 | DUMP,\ |
---|
| 103 | ELSE,\ |
---|
| 104 | END,\ |
---|
| 105 | ERRLVL,\ |
---|
| 106 | ESCAPE,\ |
---|
| 107 | EXCEPT,\ |
---|
| 108 | EXEC,\ |
---|
| 109 | EXECUTE,\ |
---|
| 110 | EXISTS,\ |
---|
| 111 | EXIT,\ |
---|
| 112 | FETCH,\ |
---|
| 113 | FILE,\ |
---|
| 114 | FILLFACTOR,\ |
---|
| 115 | FOR,\ |
---|
| 116 | FOREIGN,\ |
---|
| 117 | FREETEXT,\ |
---|
| 118 | FREETEXTTABLE,\ |
---|
| 119 | FROM,\ |
---|
| 120 | FULL,\ |
---|
| 121 | FUNCTION,\ |
---|
| 122 | GOTO,\ |
---|
| 123 | GRANT,\ |
---|
| 124 | GROUP,\ |
---|
| 125 | HAVING,\ |
---|
| 126 | HOLDLOCK,\ |
---|
| 127 | IDENTITY,\ |
---|
| 128 | IDENTITYCOL,\ |
---|
| 129 | IDENTITY_INSERT,\ |
---|
| 130 | IF,\ |
---|
| 131 | IN,\ |
---|
| 132 | INDEX,\ |
---|
| 133 | INNER,\ |
---|
| 134 | INSERT,\ |
---|
| 135 | INTERSECT,\ |
---|
| 136 | INTO,\ |
---|
| 137 | IS,\ |
---|
| 138 | JOIN,\ |
---|
| 139 | KEY,\ |
---|
| 140 | KILL,\ |
---|
| 141 | LEFT,\ |
---|
| 142 | LIKE,\ |
---|
| 143 | LINENO,\ |
---|
| 144 | LOAD,\ |
---|
| 145 | NATIONAL,\ |
---|
| 146 | NOCHECK,\ |
---|
| 147 | NONCLUSTERED,\ |
---|
| 148 | NOT,\ |
---|
| 149 | NULL,\ |
---|
| 150 | NULLIF,\ |
---|
| 151 | OF,\ |
---|
| 152 | OFF,\ |
---|
| 153 | OFFSETS,\ |
---|
| 154 | ON,\ |
---|
| 155 | OPEN,\ |
---|
| 156 | OPENDATASOURCE,\ |
---|
| 157 | OPENQUERY,\ |
---|
| 158 | OPENROWSET,\ |
---|
| 159 | OPENXML,\ |
---|
| 160 | OPTION,\ |
---|
| 161 | OR,\ |
---|
| 162 | ORDER,\ |
---|
| 163 | OUTER,\ |
---|
| 164 | OVER,\ |
---|
| 165 | PERCENT,\ |
---|
| 166 | PLAN,\ |
---|
| 167 | PRECISION,\ |
---|
| 168 | PRIMARY,\ |
---|
| 169 | PRINT,\ |
---|
| 170 | PROC,\ |
---|
| 171 | PROCEDURE,\ |
---|
| 172 | PUBLIC,\ |
---|
| 173 | RAISERROR,\ |
---|
| 174 | READ,\ |
---|
| 175 | READTEXT,\ |
---|
| 176 | RECONFIGURE,\ |
---|
| 177 | REFERENCES,\ |
---|
| 178 | REPLICATION,\ |
---|
| 179 | RESTORE,\ |
---|
| 180 | RESTRICT,\ |
---|
| 181 | RETURN,\ |
---|
| 182 | REVOKE,\ |
---|
| 183 | RIGHT,\ |
---|
| 184 | ROLLBACK,\ |
---|
| 185 | ROWCOUNT,\ |
---|
| 186 | ROWGUIDCOL,\ |
---|
| 187 | RULE,\ |
---|
| 188 | SAVE,\ |
---|
| 189 | SCHEMA,\ |
---|
| 190 | SELECT,\ |
---|
| 191 | SESSION_USER,\ |
---|
| 192 | SET,\ |
---|
| 193 | SETUSER,\ |
---|
| 194 | SHUTDOWN,\ |
---|
| 195 | SOME,\ |
---|
| 196 | STATISTICS,\ |
---|
| 197 | SYSTEM_USER,\ |
---|
| 198 | TABLE,\ |
---|
| 199 | TEXTSIZE,\ |
---|
| 200 | THEN,\ |
---|
| 201 | TO,\ |
---|
| 202 | TOP,\ |
---|
| 203 | TRAN,\ |
---|
| 204 | TRANSACTION,\ |
---|
| 205 | TRIGGER,\ |
---|
| 206 | TRUNCATE,\ |
---|
| 207 | TSEQUAL,\ |
---|
| 208 | UNION,\ |
---|
| 209 | UNIQUE,\ |
---|
| 210 | UPDATE,\ |
---|
| 211 | UPDATETEXT,\ |
---|
| 212 | USE,\ |
---|
| 213 | USER,\ |
---|
| 214 | VALUES,\ |
---|
| 215 | VARYING,\ |
---|
| 216 | VIEW,\ |
---|
| 217 | WAITFOR,\ |
---|
| 218 | WHEN,\ |
---|
| 219 | WHERE,\ |
---|
| 220 | WHILE,\ |
---|
| 221 | WITH,\ |
---|
| 222 | WRITETEXT |
---|
| 223 | |
---|
| 224 | # The character to append to attribute names to avoid exceptions due to |
---|
| 225 | # clashes between keywords and attribute names |
---|
| 226 | KeywordsMaskChar=_ |
---|
| 227 | |
---|
| 228 | #flags for loading and saving instances using DatabaseLoader/Saver |
---|
| 229 | nominalToStringLimit=50 |
---|
| 230 | idColumn=auto_generated_id |
---|
| 231 | |
---|