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
