Hi Shariq,
On Fri, Nov 16, 2012 at 11:42 AM, Muhammed Shariq <sha...@wso2.com> wrote:
> On Fri, Nov 16, 2012 at 1:42 AM, Dinusha Senanayaka <dinu...@wso2.com>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 <sha...@wso2.com> 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
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
