weka.experiment.DatabaseUtils.props.postgresql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of weka-stable Show documentation
Show all versions of weka-stable Show documentation
The Waikato Environment for Knowledge Analysis (WEKA), a machine
learning workbench. This is the stable version. Apart from bugfixes, this version
does not receive any other updates.
# Database settings for PostgreSQL 7.4
#
# General information on database access can be found here:
# http://weka.wikispaces.com/Databases
#
# url: http://www.postgresql.org/
# jdbc: http://jdbc.postgresql.org/
# author: Fracpete (fracpete at waikato dot ac dot nz)
# version: $Revision: 11885 $
# JDBC driver (comma-separated list)
jdbcDriver=org.postgresql.Driver
# database URL
jdbcURL=jdbc:postgresql://server_name:5432/database_name
# specific data types
# string, getString() = 0; --> nominal
# boolean, getBoolean() = 1; --> nominal
# double, getDouble() = 2; --> numeric
# byte, getByte() = 3; --> numeric
# short, getByte()= 4; --> numeric
# int, getInteger() = 5; --> numeric
# long, getLong() = 6; --> numeric
# float, getFloat() = 7; --> numeric
# date, getDate() = 8; --> date
# text, getString() = 9; --> string
# time, getTime() = 10; --> date
# timestamp, getTime() = 11; --> date
# PostgreSQL data types to Java classes information can be found at:
# http://www.postgresql.org/message-id/[email protected]
varchar=0
text=0
float4=7
float8=2
int4=5
oid=5
timestamp=8
date=8
int2=5
int8=2
numeric=2
bpchar=9
# other options
CREATE_DOUBLE=float8
CREATE_STRING=text
CREATE_INT=int
CREATE_DATE=TIMESTAMP
DateFormat=yyyy-MM-dd HH:mm:ss
checkUpperCaseNames=false
checkLowerCaseNames=true
checkForTable=true
# All the reserved keywords for this database
# Based on the keywords listed at the following URL (2009-04-13):
# http://www.postgresql.org/docs/7.4/static/sql-keywords-appendix.html
Keywords=\
ABORT,\
ABS,\
ABSOLUTE,\
ACCESS,\
ACTION,\
ADA,\
ADD,\
ADMIN,\
AFTER,\
AGGREGATE,\
ALIAS,\
ALL,\
ALLOCATE,\
ALTER,\
ANALYSE,\
ANALYZE,\
AND,\
ANY,\
ARE,\
ARRAY,\
AS,\
ASC,\
ASENSITIVE,\
ASSERTION,\
ASSIGNMENT,\
ASYMMETRIC,\
AT,\
ATOMIC,\
AUTHORIZATION,\
AVG,\
BACKWARD,\
BEFORE,\
BEGIN,\
BETWEEN,\
BIGINT,\
BINARY,\
BIT,\
BITVAR,\
BIT_LENGTH,\
BLOB,\
BOOLEAN,\
BOTH,\
BREADTH,\
BY,\
C,\
CACHE,\
CALL,\
CALLED,\
CARDINALITY,\
CASCADE,\
CASCADED,\
CASE,\
CAST,\
CATALOG,\
CATALOG_NAME,\
CHAIN,\
CHAR,\
CHARACTER,\
CHARACTERISTICS,\
CHARACTER_LENGTH,\
CHARACTER_SET_CATALOG,\
CHARACTER_SET_NAME,\
CHARACTER_SET_SCHEMA,\
CHAR_LENGTH,\
CHECK,\
CHECKED,\
CHECKPOINT,\
CLASS,\
CLASS_ORIGIN,\
CLOB,\
CLOSE,\
CLUSTER,\
COALESCE,\
COBOL,\
COLLATE,\
COLLATION,\
COLLATION_CATALOG,\
COLLATION_NAME,\
COLLATION_SCHEMA,\
COLUMN,\
COLUMN_NAME,\
COMMAND_FUNCTION,\
COMMAND_FUNCTION_CODE,\
COMMENT,\
COMMIT,\
COMMITTED,\
COMPLETION,\
CONDITION_NUMBER,\
CONNECT,\
CONNECTION,\
CONNECTION_NAME,\
CONSTRAINT,\
CONSTRAINTS,\
CONSTRAINT_CATALOG,\
CONSTRAINT_NAME,\
CONSTRAINT_SCHEMA,\
CONSTRUCTOR,\
CONTAINS,\
CONTINUE,\
CONVERSION,\
CONVERT,\
COPY,\
CORRESPONDING,\
COUNT,\
CREATE,\
CREATEDB,\
CREATEUSER,\
CROSS,\
CUBE,\
CURRENT,\
CURRENT_DATE,\
CURRENT_PATH,\
CURRENT_ROLE,\
CURRENT_TIME,\
CURRENT_TIMESTAMP,\
CURRENT_USER,\
CURSOR,\
CURSOR_NAME,\
CYCLE,\
DATA,\
DATABASE,\
DATE,\
DATETIME_INTERVAL_CODE,\
DATETIME_INTERVAL_PRECISION,\
DAY,\
DEALLOCATE,\
DEC,\
DECIMAL,\
DECLARE,\
DEFAULT,\
DEFAULTS,\
DEFERRABLE,\
DEFERRED,\
DEFINED,\
DEFINER,\
DELETE,\
DELIMITER,\
DELIMITERS,\
DEPTH,\
DEREF,\
DESC,\
DESCRIBE,\
DESCRIPTOR,\
DESTROY,\
DESTRUCTOR,\
DETERMINISTIC,\
DIAGNOSTICS,\
DICTIONARY,\
DISCONNECT,\
DISPATCH,\
DISTINCT,\
DO,\
DOMAIN,\
DOUBLE,\
DROP,\
DYNAMIC,\
DYNAMIC_FUNCTION,\
DYNAMIC_FUNCTION_CODE,\
EACH,\
ELSE,\
ENCODING,\
ENCRYPTED,\
END,\
END-EXEC,\
EQUALS,\
ESCAPE,\
EVERY,\
EXCEPT,\
EXCEPTION,\
EXCLUDING,\
EXCLUSIVE,\
EXEC,\
EXECUTE,\
EXISTING,\
EXISTS,\
EXPLAIN,\
EXTERNAL,\
EXTRACT,\
FALSE,\
FETCH,\
FINAL,\
FIRST,\
FLOAT,\
FOR,\
FORCE,\
FOREIGN,\
FORTRAN,\
FORWARD,\
FOUND,\
FREE,\
FREEZE,\
FROM,\
FULL,\
FUNCTION,\
G,\
GENERAL,\
GENERATED,\
GET,\
GLOBAL,\
GO,\
GOTO,\
GRANT,\
GRANTED,\
GROUP,\
GROUPING,\
HANDLER,\
HAVING,\
HIERARCHY,\
HOLD,\
HOST,\
HOUR,\
IDENTITY,\
IGNORE,\
ILIKE,\
IMMEDIATE,\
IMMUTABLE,\
IMPLEMENTATION,\
IMPLICIT,\
IN,\
INCLUDING,\
INCREMENT,\
INDEX,\
INDICATOR,\
INFIX,\
INHERITS,\
INITIALIZE,\
INITIALLY,\
INNER,\
INOUT,\
INPUT,\
INSENSITIVE,\
INSERT,\
INSTANCE,\
INSTANTIABLE,\
INSTEAD,\
INT,\
INTEGER,\
INTERSECT,\
INTERVAL,\
INTO,\
INVOKER,\
IS,\
ISNULL,\
ISOLATION,\
ITERATE,\
JOIN,\
K,\
KEY,\
KEY_MEMBER,\
KEY_TYPE,\
LANCOMPILER,\
LANGUAGE,\
LARGE,\
LAST,\
LATERAL,\
LEADING,\
LEFT,\
LENGTH,\
LESS,\
LEVEL,\
LIKE,\
LIMIT,\
LISTEN,\
LOAD,\
LOCAL,\
LOCALTIME,\
LOCALTIMESTAMP,\
LOCATION,\
LOCATOR,\
LOCK,\
LOWER,\
M,\
MAP,\
MATCH,\
MAX,\
MAXVALUE,\
MESSAGE_LENGTH,\
MESSAGE_OCTET_LENGTH,\
MESSAGE_TEXT,\
METHOD,\
MIN,\
MINUTE,\
MINVALUE,\
MOD,\
MODE,\
MODIFIES,\
MODIFY,\
MODULE,\
MONTH,\
MORE,\
MOVE,\
MUMPS,\
NAME,\
NAMES,\
NATIONAL,\
NATURAL,\
NCHAR,\
NCLOB,\
NEW,\
NEXT,\
NO,\
NOCREATEDB,\
NOCREATEUSER,\
NONE,\
NOT,\
NOTHING,\
NOTIFY,\
NOTNULL,\
NULL,\
NULLABLE,\
NULLIF,\
NUMBER,\
NUMERIC,\
OBJECT,\
OCTET_LENGTH,\
OF,\
OFF,\
OFFSET,\
OIDS,\
OLD,\
ON,\
ONLY,\
OPEN,\
OPERATION,\
OPERATOR,\
OPTION,\
OPTIONS,\
OR,\
ORDER,\
ORDINALITY,\
OUT,\
OUTER,\
OUTPUT,\
OVERLAPS,\
OVERLAY,\
OVERRIDING,\
OWNER,\
PAD,\
PARAMETER,\
PARAMETERS,\
PARAMETER_MODE,\
PARAMETER_NAME,\
PARAMETER_ORDINAL_POSITION,\
PARAMETER_SPECIFIC_CATALOG,\
PARAMETER_SPECIFIC_NAME,\
PARAMETER_SPECIFIC_SCHEMA,\
PARTIAL,\
PASCAL,\
PASSWORD,\
PATH,\
PENDANT,\
PLACING,\
PLI,\
POSITION,\
POSTFIX,\
PRECISION,\
PREFIX,\
PREORDER,\
PREPARE,\
PRESERVE,\
PRIMARY,\
PRIOR,\
PRIVILEGES,\
PROCEDURAL,\
PROCEDURE,\
PUBLIC,\
READ,\
READS,\
REAL,\
RECHECK,\
RECURSIVE,\
REF,\
REFERENCES,\
REFERENCING,\
REINDEX,\
RELATIVE,\
RENAME,\
REPEATABLE,\
REPLACE,\
RESET,\
RESTART,\
RESTRICT,\
RESULT,\
RETURN,\
RETURNED_LENGTH,\
RETURNED_OCTET_LENGTH,\
RETURNED_SQLSTATE,\
RETURNS,\
REVOKE,\
RIGHT,\
ROLE,\
ROLLBACK,\
ROLLUP,\
ROUTINE,\
ROUTINE_CATALOG,\
ROUTINE_NAME,\
ROUTINE_SCHEMA,\
ROW,\
ROWS,\
ROW_COUNT,\
RULE,\
SAVEPOINT,\
SCALE,\
SCHEMA,\
SCHEMA_NAME,\
SCOPE,\
SCROLL,\
SEARCH,\
SECOND,\
SECTION,\
SECURITY,\
SELECT,\
SELF,\
SENSITIVE,\
SEQUENCE,\
SERIALIZABLE,\
SERVER_NAME,\
SESSION,\
SESSION_USER,\
SET,\
SETOF,\
SETS,\
SHARE,\
SHOW,\
SIMILAR,\
SIMPLE,\
SIZE,\
SMALLINT,\
SOME,\
SOURCE,\
SPACE,\
SPECIFIC,\
SPECIFICTYPE,\
SPECIFIC_NAME,\
SQL,\
SQLCODE,\
SQLERROR,\
SQLEXCEPTION,\
SQLSTATE,\
SQLWARNING,\
STABLE,\
START,\
STATE,\
STATEMENT,\
STATIC,\
STATISTICS,\
STDIN,\
STDOUT,\
STORAGE,\
STRICT,\
STRUCTURE,\
STYLE,\
SUBCLASS_ORIGIN,\
SUBLIST,\
SUBSTRING,\
SUM,\
SYMMETRIC,\
SYSID,\
SYSTEM,\
SYSTEM_USER,\
TABLE,\
TABLE_NAME,\
TEMP,\
TEMPLATE,\
TEMPORARY,\
TERMINATE,\
THAN,\
THEN,\
TIME,\
TIMESTAMP,\
TIMEZONE_HOUR,\
TIMEZONE_MINUTE,\
TO,\
TOAST,\
TRAILING,\
TRANSACTION,\
TRANSACTIONS_COMMITTED,\
TRANSACTIONS_ROLLED_BACK,\
TRANSACTION_ACTIVE,\
TRANSFORM,\
TRANSFORMS,\
TRANSLATE,\
TRANSLATION,\
TREAT,\
TRIGGER,\
TRIGGER_CATALOG,\
TRIGGER_NAME,\
TRIGGER_SCHEMA,\
TRIM,\
TRUE,\
TRUNCATE,\
TRUSTED,\
TYPE,\
UNCOMMITTED,\
UNDER,\
UNENCRYPTED,\
UNION,\
UNIQUE,\
UNKNOWN,\
UNLISTEN,\
UNNAMED,\
UNNEST,\
UNTIL,\
UPDATE,\
UPPER,\
USAGE,\
USER,\
USER_DEFINED_TYPE_CATALOG,\
USER_DEFINED_TYPE_NAME,\
USER_DEFINED_TYPE_SCHEMA,\
USING,\
VACUUM,\
VALID,\
VALIDATOR,\
VALUE,\
VALUES,\
VARCHAR,\
VARIABLE,\
VARYING,\
VERBOSE,\
VERSION,\
VIEW,\
VOLATILE,\
WHEN,\
WHENEVER,\
WHERE,\
WITH,\
WITHOUT,\
WORK,\
WRITE,\
YEAR,\
ZONE
# The character to append to attribute names to avoid exceptions due to
# clashes between keywords and attribute names
KeywordsMaskChar=_
#flags for loading and saving instances using DatabaseLoader/Saver
nominalToStringLimit=50
idColumn=auto_generated_id