Hi Shariq, I am not getting this error locally. Anyway since we are no longer using rss feature with DSS, we can remove this rss-db creation script from DSS. ll do the necessary changes.
Regards, Dinusha. On Thu, Nov 15, 2012 at 9:55 PM, Muhammed Shariq <[email protected]> wrote: > 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 [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
