main: [sql] Executing resource: /home/wso2/4.0.5-release/platform/4.0.0/products/dss/3.0.1/modules/samples/sql/h2/CreateTables2.sql [sql] 2 of 2 SQL statements executed successfully [INFO] Executed tasks [INFO] [INFO] --- maven-antrun-plugin:1.7:run (create-rss-database) @ wso2dss --- [WARNING] Parameter tasks is deprecated, use target instead [INFO] Executing tasks
main: [sql] Executing resource: /home/wso2/4.0.5-release/platform/4.0.0/products/dss/3.0.1/modules/distribution/src/resources/dbscripts/wso2_rss.sql [sql] Failed to execute: CREATE TABLE RM_USER_DATABASE_PRIVILEGE ( username VARCHAR(16), database_name VARCHAR(128), rss_instance_name VARCHAR(128), tenant_id INTEGER, select_priv enum('N','Y') NOT NULL, insert_priv enum('N','Y') NOT NULL, update_priv enum('N','Y') NOT NULL, delete_priv enum('N','Y') NOT NULL, create_priv enum('N','Y') NOT NULL, drop_priv enum('N','Y') NOT NULL, grant_priv enum('N','Y') NOT NULL, references_priv enum('N','Y') NOT NULL, index_priv enum('N','Y') NOT NULL, alter_priv enum('N','Y') NOT NULL, create_tmp_table_priv enum('N','Y') NOT NULL, lock_tables_priv enum('N','Y') NOT NULL, create_view enum('N','Y') NOT NULL, show_view_priv enum('N','Y') NOT NULL, create_routine_priv enum('N','Y') NOT NULL, alter_routine_priv enum('N','Y') NOT NULL, execute_priv enum('N','Y') NOT NULL, event_priv enum('N','Y') NOT NULL, trigger_priv enum('N','Y') NOT NULL, PRIMARY KEY (username, database_name, rss_instance_name, tenant_id), FOREIGN KEY (username) REFERENCES RM_DATABASE_USER (username), FOREIGN KEY (database_name) REFERENCES RM_DATABASE (name), FOREIGN KEY (rss_instance_name) REFERENCES RM_SERVER_INSTANCE (name) ) [sql] org.h2.jdbc.JdbcSQLException: Unknown data type: "ENUM"; SQL statement: [sql] CREATE TABLE RM_USER_DATABASE_PRIVILEGE ( username VARCHAR(16), database_name VARCHAR(128), rss_instance_name VARCHAR(128), tenant_id INTEGER, select_priv enum('N','Y') NOT NULL, insert_priv enum('N','Y') NOT NULL, update_priv enum('N','Y') NOT NULL, delete_priv enum('N','Y') NOT NULL, create_priv enum('N','Y') NOT NULL, drop_priv enum('N','Y') NOT NULL, grant_priv enum('N','Y') NOT NULL, references_priv enum('N','Y') NOT NULL, index_priv enum('N','Y') NOT NULL, alter_priv enum('N','Y') NOT NULL, create_tmp_table_priv enum('N','Y') NOT NULL, lock_tables_priv enum('N','Y') NOT NULL, create_view enum('N','Y') NOT NULL, show_view_priv enum('N','Y') NOT NULL, create_routine_priv enum('N','Y') NOT NULL, alter_routine_priv enum('N','Y') NOT NULL, execute_priv enum('N','Y') NOT NULL, event_priv enum('N','Y') NOT NULL, trigger_priv enum('N','Y') NOT NULL, PRIMARY KEY (username, database_name, rss_instance_name, tenant_id), FOREIGN KEY (username) REFERENCES RM_DATABASE_USER (username), FOREIGN KEY (database_name) REFERENCES RM_DATABASE (name), FOREIGN KEY (rss_instance_name) REFERENCES RM_SERVER_INSTANCE (name) ) [50004-140] [sql] Failed to execute: CREATE TABLE RM_DB_PRIVILEGE_TEMPLATE_ENTRY ( template_name VARCHAR(128), tenant_id INTEGER, select_priv enum('N','Y') NOT NULL, insert_priv enum('N','Y') NOT NULL, update_priv enum('N','Y') NOT NULL, delete_priv enum('N','Y') NOT NULL, create_priv enum('N','Y') NOT NULL, drop_priv enum('N','Y') NOT NULL, grant_priv enum('N','Y') NOT NULL, references_priv enum('N','Y') NOT NULL, index_priv enum('N','Y') NOT NULL, alter_priv enum('N','Y') NOT NULL, create_tmp_table_priv enum('N','Y') NOT NULL, lock_tables_priv enum('N','Y') NOT NULL, create_view enum('N','Y') NOT NULL, show_view_priv enum('N','Y') NOT NULL, create_routine_priv enum('N','Y') NOT NULL, alter_routine_priv enum('N','Y') NOT NULL, execute_priv enum('N','Y') NOT NULL, event_priv enum('N','Y') NOT NULL, trigger_priv enum('N','Y') NOT NULL, PRIMARY KEY (template_name, tenant_id), FOREIGN KEY (template_name) REFERENCES RM_DB_PRIVILEGE_TEMPLATE (name) ) [sql] org.h2.jdbc.JdbcSQLException: Unknown data type: "ENUM"; SQL statement: [sql] CREATE TABLE RM_DB_PRIVILEGE_TEMPLATE_ENTRY ( template_name VARCHAR(128), tenant_id INTEGER, select_priv enum('N','Y') NOT NULL, insert_priv enum('N','Y') NOT NULL, update_priv enum('N','Y') NOT NULL, delete_priv enum('N','Y') NOT NULL, create_priv enum('N','Y') NOT NULL, drop_priv enum('N','Y') NOT NULL, grant_priv enum('N','Y') NOT NULL, references_priv enum('N','Y') NOT NULL, index_priv enum('N','Y') NOT NULL, alter_priv enum('N','Y') NOT NULL, create_tmp_table_priv enum('N','Y') NOT NULL, lock_tables_priv enum('N','Y') NOT NULL, create_view enum('N','Y') NOT NULL, show_view_priv enum('N','Y') NOT NULL, create_routine_priv enum('N','Y') NOT NULL, alter_routine_priv enum('N','Y') NOT NULL, execute_priv enum('N','Y') NOT NULL, event_priv enum('N','Y') NOT NULL, trigger_priv enum('N','Y') NOT NULL, PRIMARY KEY (template_name, tenant_id), FOREIGN KEY (template_name) REFERENCES RM_DB_PRIVILEGE_TEMPLATE (name) ) [50004-140] [sql] 7 of 9 SQL statements executed successfully [INFO] Executed tasks [INFO] -- Thanks, Shariq. Phone: +94 777 202 225
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev