On Fri, Nov 16, 2012 at 1:42 AM, Dinusha Senanayaka <[email protected]>wrote:
> 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. > I happened to notice this in the builder machine . please do the needful! :) > > 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 >> >> > -- Thanks, Shariq. Phone: +94 777 202 225
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
