Hi Shariq, On Fri, Nov 16, 2012 at 11:42 AM, Muhammed Shariq <[email protected]> wrote:
> 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! > :) > Already done. r148065. please take a svn up in products/dss/3.0.1. Regards, Dinusha. > >> 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
