2 Replies Latest reply on Jul 20, 2010 2:51 PM by Mac Ferguson

    JBoss ESB 4.8 Fails to create jUDDI tables on MSSQL

    Mac Ferguson Newbie

      I'm trying to move up to 4.8, but when I change jbossesb-registry.sar/juddi-ds.xml to point to my MSSQL database, hibernate fails to create the juddi schema on server startup with the messages below. Anyone have any suggestions? Should this be added to JIRA?

       

      09:36:37,424 INFO [DatasourceConnectionProvider] Using datasource: java:/juddiDB

      09:36:37,717 INFO [SettingsFactory] RDBMS: Microsoft SQL Server, version: 09.00.4053

      09:36:37,717 INFO [SettingsFactory] JDBC driver: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, version: 1.2

      09:36:37,757 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect

      09:36:37,765 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory

      09:36:37,768 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)

      09:36:37,768 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled

      09:36:37,768 INFO [SettingsFactory] Automatic session close at end of transaction: disabled

      09:36:37,768 INFO [SettingsFactory] JDBC batch size: 15

      09:36:37,768 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled

      09:36:37,769 INFO [SettingsFactory] Scrollable result sets: enabled

      09:36:37,770 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled

      09:36:37,770 INFO [SettingsFactory] Connection release mode: auto

      09:36:37,771 INFO [SettingsFactory] Default batch fetch size: 1

      09:36:37,772 INFO [SettingsFactory] Generate SQL with comments: disabled

      09:36:37,772 INFO [SettingsFactory] Order SQL updates by primary key: disabled

      09:36:37,772 INFO [SettingsFactory] Order SQL inserts for batching: disabled

      09:36:37,772 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

      09:36:37,790 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory

      09:36:37,790 INFO [SettingsFactory] Query language substitutions: {}

      09:36:37,790 INFO [SettingsFactory] JPA-QL strict compliance: enabled

      09:36:37,790 INFO [SettingsFactory] Second-level cache: enabled

      09:36:37,790 INFO [SettingsFactory] Query cache: disabled

      09:36:37,790 INFO [SettingsFactory] Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory

      09:36:37,791 INFO [SettingsFactory] Optimize cache for minimal puts: disabled

      09:36:37,791 INFO [SettingsFactory] Structured second-level cache entries: disabled

      09:36:37,816 INFO [SettingsFactory] Statistics: disabled

      09:36:37,816 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled

      09:36:37,816 INFO [SettingsFactory] Default entity-mode: pojo

      09:36:37,816 INFO [SettingsFactory] Named query checking : enabled

      09:36:37,905 INFO [SessionFactoryImpl] building session factory

      09:36:38,313 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured

      09:36:38,373 INFO [SchemaExport] Running hbm2ddl schema export

      09:36:38,395 INFO [SchemaExport] exporting generated schema to database

      09:36:38,718 ERROR [SchemaExport] Unsuccessful: create table j3_address (id bigint generated by default as identity (start with 1), sort_code varchar(10), tmodel_key varchar(255), use_type varchar(255), address_id bigint not null, primary key (id))

      09:36:38,718 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,720 ERROR [SchemaExport] Unsuccessful: create table j3_address_line (id bigint generated by default as identity (start with 1), key_name varchar(255), key_value varchar(255), line varchar(80) not null, address_id bigint not null, primary key (id))

      09:36:38,720 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,722 ERROR [SchemaExport] Unsuccessful: create table j3_auth_token (auth_token varchar(51) not null, authorized_name varchar(255) not null, created timestamp not null, last_used timestamp not null, number_of_uses integer not null, token_state integer not null, primary key (auth_token))

      09:36:38,723 ERROR [SchemaExport] A table can only have one timestamp column. Because table 'j3_auth_token' already has one, the column 'last_used' cannot be added.

      09:36:38,728 ERROR [SchemaExport] Unsuccessful: create table j3_binding_category_bag (id bigint not null, entity_key varchar(255) not null, primary key (id), unique (entity_key))

      09:36:38,728 ERROR [SchemaExport] There is already an object named 'j3_binding_category_bag' in the database.

      09:36:38,730 ERROR [SchemaExport] Unsuccessful: create table j3_binding_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), entity_key varchar(255) not null, primary key (id))

      09:36:38,730 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,732 ERROR [SchemaExport] Unsuccessful: create table j3_binding_template (access_point_type varchar(255), access_point_url varchar(4000), hosting_redirector varchar(255), entity_key varchar(255) not null, service_key varchar(255) not null, primary key (entity_key))

      09:36:38,732 ERROR [SchemaExport] There is already an object named 'j3_binding_template' in the database.

      09:36:38,734 ERROR [SchemaExport] Unsuccessful: create table j3_business_category_bag (id bigint not null, entity_key varchar(255) not null, primary key (id), unique (entity_key))

      09:36:38,734 ERROR [SchemaExport] There is already an object named 'j3_business_category_bag' in the database.

      09:36:38,736 ERROR [SchemaExport] Unsuccessful: create table j3_business_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), entity_key varchar(255) not null, primary key (id))

      09:36:38,736 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,738 ERROR [SchemaExport] Unsuccessful: create table j3_business_entity (entity_key varchar(255) not null, primary key (entity_key))

      09:36:38,738 ERROR [SchemaExport] There is already an object named 'j3_business_entity' in the database.

      09:36:38,740 ERROR [SchemaExport] Unsuccessful: create table j3_business_identifier (id bigint generated by default as identity (start with 1), key_name varchar(255), key_value varchar(255) not null, tmodel_key_ref varchar(255), entity_key varchar(255) not null, primary key (id))

      09:36:38,740 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,742 ERROR [SchemaExport] Unsuccessful: create table j3_business_name (id bigint generated by default as identity (start with 1), lang_code varchar(5), name varchar(255) not null, entity_key varchar(255) not null, primary key (id))

      09:36:38,742 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,744 ERROR [SchemaExport] Unsuccessful: create table j3_business_service (entity_key varchar(255) not null, business_key varchar(255) not null, primary key (entity_key))

      09:36:38,744 ERROR [SchemaExport] There is already an object named 'j3_business_service' in the database.

      09:36:38,746 ERROR [SchemaExport] Unsuccessful: create table j3_category_bag (id bigint generated by default as identity (start with 1), primary key (id))

      09:36:38,746 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,748 ERROR [SchemaExport] Unsuccessful: create table j3_clerk (clerk_name varchar(255) not null, cred varchar(255), publisher_id varchar(255) not null, node_name varchar(255), primary key (clerk_name))

      09:36:38,748 ERROR [SchemaExport] There is already an object named 'j3_clerk' in the database.

      09:36:38,750 ERROR [SchemaExport] Unsuccessful: create table j3_client_subscriptioninfo (subscription_key varchar(255) not null, last_notified timestamp, fromClerk_clerk_name varchar(255), toClerk_clerk_name varchar(255), primary key (subscription_key))

      09:36:38,750 ERROR [SchemaExport] There is already an object named 'j3_client_subscriptioninfo' in the database.

      09:36:38,752 ERROR [SchemaExport] Unsuccessful: create table j3_contact (id bigint generated by default as identity (start with 1), use_type varchar(255), entity_key varchar(255) not null, primary key (id))

      09:36:38,752 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,753 ERROR [SchemaExport] Unsuccessful: create table j3_contact_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), contact_id bigint not null, primary key (id))

      09:36:38,754 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,755 ERROR [SchemaExport] Unsuccessful: create table j3_discovery_url (id bigint generated by default as identity (start with 1), url varchar(255) not null, use_type varchar(255) not null, entity_key varchar(255) not null, primary key (id))

      09:36:38,756 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,757 ERROR [SchemaExport] Unsuccessful: create table j3_email (id bigint generated by default as identity (start with 1), email_address varchar(255) not null, use_type varchar(255), contact_id bigint not null, primary key (id))

      09:36:38,757 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,759 ERROR [SchemaExport] Unsuccessful: create table j3_instance_details_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), tmodel_instance_info_id bigint not null, primary key (id))

      09:36:38,759 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,761 ERROR [SchemaExport] Unsuccessful: create table j3_instance_details_doc_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), tmodel_instance_info_id bigint not null, primary key (id))

      09:36:38,761 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,763 ERROR [SchemaExport] Unsuccessful: create table j3_keyed_reference (id bigint generated by default as identity (start with 1), key_name varchar(255), key_value varchar(255) not null, tmodel_key_ref varchar(255), category_bag_id bigint, keyed_reference_group_id bigint, primary key (id))

      09:36:38,764 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,765 ERROR [SchemaExport] Unsuccessful: create table j3_keyed_reference_group (id bigint generated by default as identity (start with 1), tmodel_key varchar(255), category_bag_id bigint not null, primary key (id))

      09:36:38,766 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,768 ERROR [SchemaExport] Unsuccessful: create table j3_node (name varchar(255) not null, custody_transfer_url varchar(255) not null, factory_initial varchar(255), factory_naming_provider varchar(255), factory_url_pkgs varchar(255), inquiry_url varchar(255) not null, juddi_api_url varchar(255), manager_name varchar(255) not null, proxy_transport varchar(255) not null, publish_url varchar(255) not null, security_url varchar(255) not null, subscription_url varchar(255) not null, primary key (name))

      09:36:38,768 ERROR [SchemaExport] There is already an object named 'j3_node' in the database.

      09:36:38,770 ERROR [SchemaExport] Unsuccessful: create table j3_overview_doc (id bigint generated by default as identity (start with 1), overview_url varchar(255) not null, overview_url_use_type varchar(255), entity_key varchar(255), tomodel_instance_info_id bigint, primary key (id))

      09:36:38,770 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,772 ERROR [SchemaExport] Unsuccessful: create table j3_overview_doc_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), overview_doc_id bigint, primary key (id))

      09:36:38,772 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,773 ERROR [SchemaExport] Unsuccessful: create table j3_person_name (id bigint generated by default as identity (start with 1), lang_code varchar(5), name varchar(255) not null, contact_id bigint not null, primary key (id))

      09:36:38,774 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,775 ERROR [SchemaExport] Unsuccessful: create table j3_phone (id bigint generated by default as identity (start with 1), phone_number varchar(50) not null, use_type varchar(255), contact_id bigint not null, primary key (id))

      09:36:38,776 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,778 ERROR [SchemaExport] Unsuccessful: create table j3_publisher (authorized_name varchar(255) not null, email_address varchar(255), is_admin varchar(5), is_enabled varchar(5), max_bindings_per_service integer, max_businesses integer, max_services_per_business integer, max_tmodels integer, publisher_name varchar(255) not null, primary key (authorized_name))

      09:36:38,778 ERROR [SchemaExport] There is already an object named 'j3_publisher' in the database.

      09:36:38,780 ERROR [SchemaExport] Unsuccessful: create table j3_publisher_assertion (from_key varchar(255) not null, to_key varchar(255) not null, from_check varchar(5) not null, key_name varchar(255) not null, key_value varchar(255) not null, tmodel_key varchar(255) not null, to_check varchar(5) not null, primary key (from_key, to_key))

      09:36:38,780 ERROR [SchemaExport] There is already an object named 'j3_publisher_assertion' in the database.

      09:36:38,781 ERROR [SchemaExport] Unsuccessful: create table j3_service_category_bag (id bigint not null, entity_key varchar(255) not null, primary key (id), unique (entity_key))

      09:36:38,782 ERROR [SchemaExport] There is already an object named 'j3_service_category_bag' in the database.

      09:36:38,783 ERROR [SchemaExport] Unsuccessful: create table j3_service_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), entity_key varchar(255) not null, primary key (id))

      09:36:38,783 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,785 ERROR [SchemaExport] Unsuccessful: create table j3_service_name (id bigint generated by default as identity (start with 1), lang_code varchar(5), name varchar(255) not null, entity_key varchar(255) not null, primary key (id))

      09:36:38,785 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,786 ERROR [SchemaExport] Unsuccessful: create table j3_service_projection (business_key varchar(255) not null, service_key varchar(255) not null, primary key (business_key, service_key))

      09:36:38,787 ERROR [SchemaExport] There is already an object named 'j3_service_projection' in the database.

      09:36:38,788 ERROR [SchemaExport] Unsuccessful: create table j3_subscription (subscription_key varchar(255) not null, authorized_name varchar(255) not null, binding_key varchar(255), brief bit, create_date timestamp not null, expires_after timestamp, last_notified timestamp, max_entities integer, notification_interval varchar(255), subscription_filter longvarchar not null, primary key (subscription_key))

      09:36:38,789 ERROR [SchemaExport] A table can only have one timestamp column. Because table 'j3_subscription' already has one, the column 'expires_after' cannot be added.

      09:36:38,790 ERROR [SchemaExport] Unsuccessful: create table j3_subscription_chunk_token (chunk_token varchar(255) not null, data integer not null, end_point timestamp, expires_after timestamp not null, start_point timestamp, subscription_key varchar(255) not null, primary key (chunk_token))

      09:36:38,790 ERROR [SchemaExport] A table can only have one timestamp column. Because table 'j3_subscription_chunk_token' already has one, the column 'expires_after' cannot be added.

      09:36:38,792 ERROR [SchemaExport] Unsuccessful: create table j3_subscription_match (id bigint generated by default as identity (start with 1), entity_key varchar(255) not null, subscription_key varchar(255) not null, primary key (id))

      09:36:38,792 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,794 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel (deleted bit, lang_code varchar(5), name varchar(255) not null, entity_key varchar(255) not null, primary key (entity_key))

      09:36:38,794 ERROR [SchemaExport] There is already an object named 'j3_tmodel' in the database.

      09:36:38,798 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel_category_bag (id bigint not null, entity_key varchar(255) not null, primary key (id), unique (entity_key))

      09:36:38,798 ERROR [SchemaExport] There is already an object named 'j3_tmodel_category_bag' in the database.

      09:36:38,799 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), entity_key varchar(255) not null, primary key (id))

      09:36:38,799 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,800 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel_identifier (id bigint generated by default as identity (start with 1), key_name varchar(255), key_value varchar(255) not null, tmodel_key_ref varchar(255), entity_key varchar(255) not null, primary key (id))

      09:36:38,800 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,802 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel_instance_info (id bigint generated by default as identity (start with 1), instance_parms varchar(512), tmodel_key varchar(255) not null, entity_key varchar(255) not null, primary key (id))

      09:36:38,802 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,804 ERROR [SchemaExport] Unsuccessful: create table j3_tmodel_instance_info_descr (id bigint generated by default as identity (start with 1), descr varchar(1024) not null, lang_code varchar(5), tmodel_instance_info_id bigint not null, primary key (id))

      09:36:38,804 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,806 ERROR [SchemaExport] Unsuccessful: create table j3_transfer_token (transfer_token varchar(51) not null, expiration_date timestamp not null, primary key (transfer_token))

      09:36:38,806 ERROR [SchemaExport] There is already an object named 'j3_transfer_token' in the database.

      09:36:38,807 ERROR [SchemaExport] Unsuccessful: create table j3_transfer_token_keys (id bigint generated by default as identity (start with 1), entity_key varchar(255), transfer_token varchar(51) not null, primary key (id))

      09:36:38,807 ERROR [SchemaExport] Incorrect syntax near 'generated'.

      09:36:38,809 ERROR [SchemaExport] Unsuccessful: create table j3_uddi_entity (entity_key varchar(255) not null, authorized_name varchar(255) not null, created timestamp, modified timestamp not null, modified_including_children timestamp, node_id varchar(255), primary key (entity_key))

      09:36:38,809 ERROR [SchemaExport] A table can only have one timestamp column. Because table 'j3_uddi_entity' already has one, the column 'modified' cannot be added.

      09:36:38,810 ERROR [SchemaExport] Unsuccessful: alter table j3_address add constraint FKF83236BE75D860FB foreign key (address_id) references j3_contact

      09:36:38,810 ERROR [SchemaExport] Cannot find the object "j3_address" because it does not exist or you do not have permissions.

      09:36:38,811 ERROR [SchemaExport] Unsuccessful: alter table j3_address_line add constraint FKC665B8D5F8B8D8CF foreign key (address_id) references j3_address

      09:36:38,811 ERROR [SchemaExport] Cannot find the object "j3_address_line" because it does not exist or you do not have permissions.

      09:36:38,814 ERROR [SchemaExport] Unsuccessful: alter table j3_binding_category_bag add constraint FKCF34B2376A68D45A foreign key (id) references j3_category_bag

      09:36:38,814 ERROR [SchemaExport] Foreign key 'FKCF34B2376A68D45A' references invalid table 'j3_category_bag'.

      09:36:38,822 ERROR [SchemaExport] Unsuccessful: alter table j3_binding_descr add constraint FK5EA60911CFBD88B7 foreign key (entity_key) references j3_binding_template

      09:36:38,822 ERROR [SchemaExport] Cannot find the object "j3_binding_descr" because it does not exist or you do not have permissions.

      09:36:38,828 ERROR [SchemaExport] Unsuccessful: alter table j3_binding_template add constraint FKD044BD6AD1823CA5 foreign key (entity_key) references j3_uddi_entity

      09:36:38,828 ERROR [SchemaExport] Foreign key 'FKD044BD6AD1823CA5' references invalid table 'j3_uddi_entity'.

      09:36:38,830 ERROR [SchemaExport] Unsuccessful: alter table j3_business_category_bag add constraint FKD6D3ECB06A68D45A foreign key (id) references j3_category_bag

      09:36:38,830 ERROR [SchemaExport] Foreign key 'FKD6D3ECB06A68D45A' references invalid table 'j3_category_bag'.

      09:36:38,839 ERROR [SchemaExport] Unsuccessful: alter table j3_business_descr add constraint FK3A24B4B8BEB92A91 foreign key (entity_key) references j3_business_entity

      09:36:38,839 ERROR [SchemaExport] Cannot find the object "j3_business_descr" because it does not exist or you do not have permissions.

      09:36:38,841 ERROR [SchemaExport] Unsuccessful: alter table j3_business_entity add constraint FKCA61A0CD1823CA5 foreign key (entity_key) references j3_uddi_entity

      09:36:38,841 ERROR [SchemaExport] Foreign key 'FKCA61A0CD1823CA5' references invalid table 'j3_uddi_entity'.

      09:36:38,842 ERROR [SchemaExport] Unsuccessful: alter table j3_business_identifier add constraint FKB0C7A652BEB92A91 foreign key (entity_key) references j3_business_entity

      09:36:38,842 ERROR [SchemaExport] Cannot find the object "j3_business_identifier" because it does not exist or you do not have permissions.

      09:36:38,843 ERROR [SchemaExport] Unsuccessful: alter table j3_business_name add constraint FK43F526F4BEB92A91 foreign key (entity_key) references j3_business_entity

      09:36:38,843 ERROR [SchemaExport] Cannot find the object "j3_business_name" because it does not exist or you do not have permissions.

      09:36:38,845 ERROR [SchemaExport] Unsuccessful: alter table j3_business_service add constraint FK5D4255ACD1823CA5 foreign key (entity_key) references j3_uddi_entity

      09:36:38,845 ERROR [SchemaExport] Foreign key 'FK5D4255ACD1823CA5' references invalid table 'j3_uddi_entity'.

      09:36:38,863 ERROR [SchemaExport] Unsuccessful: alter table j3_contact add constraint FK7551BEEABEB92A91 foreign key (entity_key) references j3_business_entity

      09:36:38,864 ERROR [SchemaExport] Cannot find the object "j3_contact" because it does not exist or you do not have permissions.

      09:36:38,865 ERROR [SchemaExport] Unsuccessful: alter table j3_contact_descr add constraint FK56CA9E6C2E3FD94F foreign key (contact_id) references j3_contact

      09:36:38,865 ERROR [SchemaExport] Cannot find the object "j3_contact_descr" because it does not exist or you do not have permissions.

      09:36:38,867 ERROR [SchemaExport] Unsuccessful: alter table j3_discovery_url add constraint FKA042FDAABEB92A91 foreign key (entity_key) references j3_business_entity

      09:36:38,867 ERROR [SchemaExport] Cannot find the object "j3_discovery_url" because it does not exist or you do not have permissions.

      09:36:38,868 ERROR [SchemaExport] Unsuccessful: alter table j3_email add constraint FK34F910E62E3FD94F foreign key (contact_id) references j3_contact

      09:36:38,869 ERROR [SchemaExport] Cannot find the object "j3_email" because it does not exist or you do not have permissions.

      09:36:38,870 ERROR [SchemaExport] Unsuccessful: alter table j3_instance_details_descr add constraint FK3CC165902B115C6F foreign key (tmodel_instance_info_id) references j3_tmodel_instance_info

      09:36:38,871 ERROR [SchemaExport] Cannot find the object "j3_instance_details_descr" because it does not exist or you do not have permissions.

      09:36:38,872 ERROR [SchemaExport] Unsuccessful: alter table j3_instance_details_doc_descr add constraint FK447324492B115C6F foreign key (tmodel_instance_info_id) references j3_tmodel_instance_info

      09:36:38,872 ERROR [SchemaExport] Cannot find the object "j3_instance_details_doc_descr" because it does not exist or you do not have permissions.

      09:36:38,874 ERROR [SchemaExport] Unsuccessful: alter table j3_keyed_reference add constraint FK350C8454E075C8D7 foreign key (keyed_reference_group_id) references j3_keyed_reference_group

      09:36:38,874 ERROR [SchemaExport] Cannot find the object "j3_keyed_reference" because it does not exist or you do not have permissions.

      09:36:38,876 ERROR [SchemaExport] Unsuccessful: alter table j3_keyed_reference add constraint FK350C84541DB72652 foreign key (category_bag_id) references j3_category_bag

      09:36:38,876 ERROR [SchemaExport] Cannot find the object "j3_keyed_reference" because it does not exist or you do not have permissions.

      09:36:38,877 ERROR [SchemaExport] Unsuccessful: alter table j3_keyed_reference_group add constraint FKF6224ED41DB72652 foreign key (category_bag_id) references j3_category_bag

      09:36:38,877 ERROR [SchemaExport] Cannot find the object "j3_keyed_reference_group" because it does not exist or you do not have permissions.

      09:36:38,879 ERROR [SchemaExport] Unsuccessful: alter table j3_overview_doc add constraint FK5CD8D0E8C5BF8903 foreign key (entity_key) references j3_tmodel

      09:36:38,879 ERROR [SchemaExport] Cannot find the object "j3_overview_doc" because it does not exist or you do not have permissions.

      09:36:38,880 ERROR [SchemaExport] Unsuccessful: alter table j3_overview_doc add constraint FK5CD8D0E8E8CE1B36 foreign key (tomodel_instance_info_id) references j3_tmodel_instance_info

      09:36:38,881 ERROR [SchemaExport] Cannot find the object "j3_overview_doc" because it does not exist or you do not have permissions.

      09:36:38,882 ERROR [SchemaExport] Unsuccessful: alter table j3_overview_doc_descr add constraint FK36FB9EA9BDC711C foreign key (overview_doc_id) references j3_overview_doc

      09:36:38,882 ERROR [SchemaExport] Cannot find the object "j3_overview_doc_descr" because it does not exist or you do not have permissions.

      09:36:38,883 ERROR [SchemaExport] Unsuccessful: alter table j3_person_name add constraint FKCB7B8AFF2E3FD94F foreign key (contact_id) references j3_contact

      09:36:38,884 ERROR [SchemaExport] Cannot find the object "j3_person_name" because it does not exist or you do not have permissions.

      09:36:38,885 ERROR [SchemaExport] Unsuccessful: alter table j3_phone add constraint FK359202B82E3FD94F foreign key (contact_id) references j3_contact

      09:36:38,885 ERROR [SchemaExport] Cannot find the object "j3_phone" because it does not exist or you do not have permissions.

      09:36:38,903 ERROR [SchemaExport] Unsuccessful: alter table j3_service_category_bag add constraint FK185A68076A68D45A foreign key (id) references j3_category_bag

      09:36:38,903 ERROR [SchemaExport] Foreign key 'FK185A68076A68D45A' references invalid table 'j3_category_bag'.

      09:36:38,912 ERROR [SchemaExport] Unsuccessful: alter table j3_service_descr add constraint FKB6D63D4148D0656D foreign key (entity_key) references j3_business_service

      09:36:38,912 ERROR [SchemaExport] Cannot find the object "j3_service_descr" because it does not exist or you do not have permissions.

      09:36:38,913 ERROR [SchemaExport] Unsuccessful: alter table j3_service_name add constraint FKCC1BE94B48D0656D foreign key (entity_key) references j3_business_service

      09:36:38,913 ERROR [SchemaExport] Cannot find the object "j3_service_name" because it does not exist or you do not have permissions.

      09:36:38,923 ERROR [SchemaExport] Unsuccessful: alter table j3_subscription_match add constraint FK5B9C2F19BEEE42E5 foreign key (subscription_key) references j3_subscription

      09:36:38,924 ERROR [SchemaExport] Cannot find the object "j3_subscription_match" because it does not exist or you do not have permissions.

      09:36:38,926 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel add constraint FK83C8072BD1823CA5 foreign key (entity_key) references j3_uddi_entity

      09:36:38,926 ERROR [SchemaExport] Foreign key 'FK83C8072BD1823CA5' references invalid table 'j3_uddi_entity'.

      09:36:38,928 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel_category_bag add constraint FK7E0859DB6A68D45A foreign key (id) references j3_category_bag

      09:36:38,928 ERROR [SchemaExport] Foreign key 'FK7E0859DB6A68D45A' references invalid table 'j3_category_bag'.

      09:36:38,935 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel_descr add constraint FK63DFF1EDC5BF8903 foreign key (entity_key) references j3_tmodel

      09:36:38,935 ERROR [SchemaExport] Cannot find the object "j3_tmodel_descr" because it does not exist or you do not have permissions.

      09:36:38,937 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel_identifier add constraint FKD5FB623DC5BF8903 foreign key (entity_key) references j3_tmodel

      09:36:38,937 ERROR [SchemaExport] Cannot find the object "j3_tmodel_identifier" because it does not exist or you do not have permissions.

      09:36:38,938 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel_instance_info add constraint FKDC6C9004CFBD88B7 foreign key (entity_key) references j3_binding_template

      09:36:38,939 ERROR [SchemaExport] Cannot find the object "j3_tmodel_instance_info" because it does not exist or you do not have permissions.

      09:36:38,940 ERROR [SchemaExport] Unsuccessful: alter table j3_tmodel_instance_info_descr add constraint FKD826B4062B115C6F foreign key (tmodel_instance_info_id) references j3_tmodel_instance_info

      09:36:38,940 ERROR [SchemaExport] Cannot find the object "j3_tmodel_instance_info_descr" because it does not exist or you do not have permissions.

      09:36:38,941 ERROR [SchemaExport] Unsuccessful: alter table j3_transfer_token_keys add constraint FK8BBF49185ED9DD48 foreign key (transfer_token) references j3_transfer_token

      09:36:38,941 ERROR [SchemaExport] Cannot find the object "j3_transfer_token_keys" because it does not exist or you do not have permissions.

      09:36:38,941 INFO [SchemaExport] schema export complete

      09:36:39,106 INFO [AppConfig] The 'root' publisher was not found, loading...

      09:36:39,121 INFO [Install] Loading the content of file: vfsfile:/C:/dev/servers/jboss-5.1.0.GA/server/default/deploy/jbossesb-registry.sar/juddi_custom_install_data/root_tModelKeyGen.xml

      09:36:39,622 INFO [Install] Loading the content of file: vfsfile:/C:/dev/servers/jboss-5.1.0.GA/server/default/deploy/jbossesb-registry.sar/juddi_custom_install_data/root_BusinessEntity.xml

      09:36:39,749 INFO [Install] Loading the root Publisher from file root_Publisher.xml

      09:36:39,754 INFO [Install] Loading the content of file: vfsfile:/C:/dev/servers/jboss-5.1.0.GA/server/default/deploy/jbossesb-registry.sar/juddi_custom_install_data/root_Publisher.xml

      09:36:40,025 WARN [JDBCExceptionReporter] SQL Error: 208, SQLState: 42S02

      09:36:40,025 ERROR [JDBCExceptionReporter] Invalid object name 'j3_uddi_entity'.

      09:36:40,049 ERROR [AbstractKernelController] Error installing to Start: name=jboss.esb:service=JuddiRMI state=Create mode=Manual requiredState=Installed

      org.apache.commons.configuration.ConfigurationException

       

      : javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

      at org.apache.juddi.config.AppConfig.getPersistentConfiguration(

      AppConfig.java:122)

      at org.apache.juddi.config.AppConfig.loadConfiguration(

      AppConfig.java:95)

      at org.apache.juddi.config.AppConfig.<init>(

      AppConfig.java:62)

      at org.apache.juddi.config.AppConfig.getInstance(

      AppConfig.java:183)

      at org.apache.juddi.config.AppConfig.getConfiguration(

      AppConfig.java:205)

      at org.apache.juddi.Registry.start(

      Registry.java:55)

      at org.jboss.internal.soa.esb.dependencies.JuddiRMIService.startService(

      JuddiRMIService.java:144)

      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(

      ServiceMBeanSupport.java:376)

      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(

      ServiceMBeanSupport.java:322)

      at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(

      DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(

      Method.java:597)

      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(

      ReflectedDispatcher.java:157)

      at org.jboss.mx.server.Invocation.dispatch(

      Invocation.java:96)

      at org.jboss.mx.server.Invocation.invoke(

      Invocation.java:88)

      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(

      AbstractMBeanInvoker.java:264)

      at org.jboss.mx.server.MBeanServerImpl.invoke(

      MBeanServerImpl.java:668)

      at org.jboss.system.microcontainer.ServiceProxy.invoke(

      ServiceProxy.java:189)

      at $Proxy38.start(Unknown Source)

      at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(

      StartStopLifecycleAction.java:42)

      at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(

      StartStopLifecycleAction.java:37)

      at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(

      SimpleControllerContextAction.java:62)

      at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(

      AccessControllerContextAction.java:71)

      at org.jboss.dependency.plugins.AbstractControllerContextActions.install(

      AbstractControllerContextActions.java:51)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.system.microcontainer.ServiceControllerContext.install(

      ServiceControllerContext.java:286)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.system.ServiceController.doChange(

      ServiceController.java:688)

      at org.jboss.system.ServiceController.start(

      ServiceController.java:460)

      at org.jboss.system.deployers.ServiceDeployer.start(

      ServiceDeployer.java:163)

      at org.jboss.system.deployers.ServiceDeployer.deploy(

      ServiceDeployer.java:99)

      at org.jboss.system.deployers.ServiceDeployer.deploy(

      ServiceDeployer.java:46)

      at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(

      AbstractSimpleRealDeployer.java:62)

      at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(

      AbstractRealDeployer.java:50)

      at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(

      DeployerWrapper.java:171)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(

      DeployersImpl.java:1439)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(

      DeployersImpl.java:1157)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(

      DeployersImpl.java:1178)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.install(

      DeployersImpl.java:1098)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.process(

      DeployersImpl.java:781)

      at org.jboss.deployers.plugins.main.MainDeployerImpl.process(

      MainDeployerImpl.java:702)

      at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(

      MainDeployerAdapter.java:117)

      at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(

      ProfileDeployAction.java:70)

      at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(

      AbstractProfileAction.java:53)

      at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(

      AbstractProfileService.java:361)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(

      AbstractProfileService.java:306)

      at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(

      ProfileServiceBootstrap.java:271)

      at org.jboss.bootstrap.AbstractServerImpl.start(

      AbstractServerImpl.java:461)

      at org.jboss.Main.boot(

      Main.java:221)

      at org.jboss.Main$1.run(

      Main.java:556)

      at java.lang.Thread.run(

      Thread.java:619)

      Caused by:

      javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(

      AbstractEntityManagerImpl.java:614)

      at org.hibernate.ejb.AbstractEntityManagerImpl.persist(

      AbstractEntityManagerImpl.java:226)

      at org.apache.juddi.config.Install.installPublisherKeyGen(

      Install.java:476)

      at org.apache.juddi.config.Install.installRootPublisherKeyGen(

      Install.java:460)

      at org.apache.juddi.config.Install.install(

      Install.java:104)

      at org.apache.juddi.config.AppConfig.getPersistentConfiguration(

      AppConfig.java:120)

      ... 69 more

      Caused by:

      org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

      at org.hibernate.exception.SQLStateConverter.convert(

      SQLStateConverter.java:90)

      at org.hibernate.exception.JDBCExceptionHelper.convert(

      JDBCExceptionHelper.java:66)

      at org.hibernate.jdbc.AbstractBatcher.executeBatch(

      AbstractBatcher.java:275)

      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(

      AbstractBatcher.java:114)

      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(

      AbstractBatcher.java:109)

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(

      AbstractEntityPersister.java:2260)

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(

      AbstractEntityPersister.java:2688)

      at org.hibernate.action.EntityInsertAction.execute(

      EntityInsertAction.java:79)

      at org.hibernate.engine.ActionQueue.execute(

      ActionQueue.java:279)

      at org.hibernate.engine.ActionQueue.executeActions(

      ActionQueue.java:263)

      at org.hibernate.engine.ActionQueue.executeInserts(

      ActionQueue.java:158)

      at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(

      AbstractSaveEventListener.java:268)

      at org.hibernate.event.def.AbstractSaveEventListener.performSave(

      AbstractSaveEventListener.java:204)

      at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(

      AbstractSaveEventListener.java:130)

      at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(

      EJB3PersistEventListener.java:49)

      at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(

      DefaultPersistEventListener.java:154)

      at org.hibernate.event.def.DefaultPersistEventListener.onPersist(

      DefaultPersistEventListener.java:110)

      at org.hibernate.impl.SessionImpl.firePersist(

      SessionImpl.java:636)

      at org.hibernate.impl.SessionImpl.persist(

      SessionImpl.java:628)

      at org.hibernate.engine.EJB3CascadingAction$1.cascade(

      EJB3CascadingAction.java:28)

      at org.hibernate.engine.Cascade.cascadeToOne(

      Cascade.java:291)

      at org.hibernate.engine.Cascade.cascadeAssociation(

      Cascade.java:239)

      at org.hibernate.engine.Cascade.cascadeProperty(

      Cascade.java:192)

      at org.hibernate.engine.Cascade.cascadeCollectionElements(

      Cascade.java:319)

      at org.hibernate.engine.Cascade.cascadeCollection(

      Cascade.java:265)

      at org.hibernate.engine.Cascade.cascadeAssociation(

      Cascade.java:242)

      at org.hibernate.engine.Cascade.cascadeProperty(

      Cascade.java:192)

      at org.hibernate.engine.Cascade.cascade(

      Cascade.java:153)

      at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(

      AbstractSaveEventListener.java:479)

      at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(

      AbstractSaveEventListener.java:357)

      at org.hibernate.event.def.AbstractSaveEventListener.performSave(

      AbstractSaveEventListener.java:204)

      at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(

      AbstractSaveEventListener.java:144)

      at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(

      EJB3PersistEventListener.java:49)

      at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(

      DefaultPersistEventListener.java:154)

      at org.hibernate.event.def.DefaultPersistEventListener.onPersist(

      DefaultPersistEventListener.java:110)

      at org.hibernate.event.def.DefaultPersistEventListener.onPersist(

      DefaultPersistEventListener.java:61)

      at org.hibernate.impl.SessionImpl.firePersist(

      SessionImpl.java:645)

      at org.hibernate.impl.SessionImpl.persist(

      SessionImpl.java:619)

      at org.hibernate.impl.SessionImpl.persist(

      SessionImpl.java:623)

      at org.hibernate.ejb.AbstractEntityManagerImpl.persist(

      AbstractEntityManagerImpl.java:220)

      ... 73 more

      Caused by:

      java.sql.BatchUpdateException: Invalid object name 'j3_uddi_entity'.

      at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(

      JtdsStatement.java:901)

      at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(

      CachedPreparedStatement.java:476)

      at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(

      WrappedStatement.java:774)

      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(

      BatchingBatcher.java:70)

      at org.hibernate.jdbc.AbstractBatcher.executeBatch(

      AbstractBatcher.java:268)

      ... 110 more