1 2 Previous Next 20 Replies Latest reply on Jul 28, 2009 9:33 AM by Matthew Skevington

    Drools Dependencies in the ESB

    wollint Newbie

      What components in the ESB depend on Drools? For example, if Drools was removed from the ESB what else would "break"?

        • 1. Re: Drools Dependencies in the ESB
          Kevin Conner Master

          At present it would disable the routing options, ContentBasedRouter, ContentBasedWiretap, MessageFilter and BusinessRulesProcessor.

          We are currently considering alternatives for the routing however

          http://www.jboss.org/index.html?module=bb&op=viewtopic&t=154882

          • 2. Re: Drools Dependencies in the ESB
            wollint Newbie

            Thanks for the quick response.

            The reason I asked about disabling Drools is because we are having problems getting the ESB to work with Oracle 10/11g and have narrowed it down to what we think is a Drools issue. At startup of JBoss, when Drools creates tables in Oracle it violates Oracle contraints - uses Oracle keywords and table and field names are greater than 30 chars.

            Has this been reported? Is there a fix?

            • 3. Re: Drools Dependencies in the ESB
              Kevin Conner Master

              I am not aware of any issues between drools and Oracle. We do include Oracle in the testing for the SOA platform so this may have come up in other forums.

              Can you give us more information about your setup, ESB version, drools version (if you have replaced it) etc, and also some information about the DB constraint violation you are seeing?

              It would also help if you can explain why you feel it is drools which is responsible and not some other aspect of the ESB.

              Thanks
              Kev

              • 4. Re: Drools Dependencies in the ESB
                Matthew Skevington Newbie

                I've experienced the same problems with Drools and the ESB. To overcome the issue, I used the jar files from the previous version of Drools (drools-4.0.7-bin) which resolved the problem. I would still like to know if there is a fix for this issue as I'd prefer to use the latest version of Drools.

                • 5. Re: Drools Dependencies in the ESB
                  Kevin Conner Master

                  We will shortly be upgrading drools to their latest version but would appreciate some information about the constraint violation you are seeing. If we know what is going on then we can investigate.

                  Kev

                  • 6. Re: Drools Dependencies in the ESB
                    Matthew Skevington Newbie

                    This is an extract from the server.log relating to the Drools issue:

                    2009-05-13 16:03:57,813 111557 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Running hbm2ddl schema export
                    2009-05-13 16:03:57,814 111558 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) exporting generated schema to database
                    2009-05-13 16:03:58,064 111808 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table Attachment (id number(19,0) not null, accessType number(10,0), attachedAt timestamp, attachmentContentId number(19,0) not null, contentType varchar2(255 char), name varchar2(255 char), size number(10,0) not null, attachedBy_id varchar2(255 char), TaskData_Attachments_Id number(19,0), primary key (id))
                    2009-05-13 16:03:58,064 111808 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00904: : invalid identifier

                    2009-05-13 16:03:58,090 111834 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table Comment (id number(19,0) not null, addedAt timestamp, text clob, addedBy_id varchar2(255 char), TaskData_Comments_Id number(19,0), primary key (id))
                    2009-05-13 16:03:58,090 111834 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00903: invalid table name

                    2009-05-13 16:03:58,115 111859 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table Deadline (id number(19,0) not null, date timestamp, escalated number(1,0) not null, Deadlines_StartDeadLine_Id number(19,0), Deadlines_EndDeadLine_Id number(19,0), primary key (id))
                    2009-05-13 16:03:58,115 111859 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00904: : invalid identifier

                    2009-05-13 16:03:58,247 111991 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table Notification_BusinessAdministrators (task_id number(19,0) not null, entity_id varchar2(255 char) not null)
                    2009-05-13 16:03:58,247 111991 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,248 111992 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table Notification_EmailNotificationHeader (Notification_id number(19,0) not null, emailHeaders_id number(19,0) not null, mapkey varchar2(255 char), primary key (Notification_id, mapkey), unique (emailHeaders_id))
                    2009-05-13 16:03:58,249 111993 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,291 112035 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table PeopleAssignments_BusinessAdministrators (task_id number(19,0) not null, entity_id varchar2(255 char) not null)
                    2009-05-13 16:03:58,291 112035 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,296 112040 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table PeopleAssignments_ExcludedOwners (task_id number(19,0) not null, entity_id varchar2(255 char) not null)
                    2009-05-13 16:03:58,296 112040 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,300 112044 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table PeopleAssignments_PotentialOwners (task_id number(19,0) not null, entity_id varchar2(255 char) not null)
                    2009-05-13 16:03:58,300 112044 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,326 112070 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table PeopleAssignments_TaskStakeholders (task_id number(19,0) not null, entity_id varchar2(255 char) not null)
                    2009-05-13 16:03:58,326 112070 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,359 112103 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: create table ProcessInstanceInfo_eventTypes (ProcessInstanceInfo_processInstanceId number(19,0) not null, element varchar2(255 char))
                    2009-05-13 16:03:58,359 112103 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,475 112219 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Attachment add constraint FK1C93543839A1819 foreign key (TaskData_Attachments_Id) references Task
                    2009-05-13 16:03:58,475 112219 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,480 112224 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Attachment add constraint FK1C935432077E1A4 foreign key (attachedBy_id) references OrganizationalEntity
                    2009-05-13 16:03:58,480 112224 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,503 112247 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Comment add constraint FK9BDE863F44E05A35 foreign key (TaskData_Comments_Id) references Task
                    2009-05-13 16:03:58,504 112248 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00903: invalid table name

                    2009-05-13 16:03:58,509 112253 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Comment add constraint FK9BDE863FC17237C8 foreign key (addedBy_id) references OrganizationalEntity
                    2009-05-13 16:03:58,509 112253 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00903: invalid table name

                    2009-05-13 16:03:58,515 112259 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Deadline add constraint FK21DF3E78F9CD9DE3 foreign key (Deadlines_StartDeadLine_Id) references Task
                    2009-05-13 16:03:58,515 112259 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,520 112264 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Deadline add constraint FK21DF3E78B92DDCCA foreign key (Deadlines_EndDeadLine_Id) references Task
                    2009-05-13 16:03:58,520 112264 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,562 112306 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Escalation add constraint FK67B2C6B5F8479DB0 foreign key (Deadline_Escalation_Id) references Deadline
                    2009-05-13 16:03:58,562 112306 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,637 112381 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table I18NText add constraint FK2349686B63D84819 foreign key (Deadline_Documentation_Id) references Deadline
                    2009-05-13 16:03:58,637 112381 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00942: table or view does not exist

                    2009-05-13 16:03:58,764 112508 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Notification_BusinessAdministrators add constraint FK4DCCC4FA9A939BFA foreign key (task_id) references Notification
                    2009-05-13 16:03:58,764 112508 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,766 112510 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Notification_BusinessAdministrators add constraint FK4DCCC4FAB009A012 foreign key (entity_id) references OrganizationalEntity
                    2009-05-13 16:03:58,766 112510 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,767 112511 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Notification_EmailNotificationHeader add constraint FK92169CC0379F97EA foreign key (emailHeaders_id) references EmailNotificationHeader
                    2009-05-13 16:03:58,768 112512 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,770 112514 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table Notification_EmailNotificationHeader add constraint FK92169CC01B1E66DC foreign key (Notification_id) references Notification
                    2009-05-13 16:03:58,771 112515 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,816 112560 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_BusinessAdministrators add constraint FK3D56AB6EC834E294 foreign key (task_id) references Task
                    2009-05-13 16:03:58,816 112560 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,818 112562 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_BusinessAdministrators add constraint FK3D56AB6EB009A012 foreign key (entity_id) references OrganizationalEntity
                    2009-05-13 16:03:58,818 112562 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,819 112563 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_ExcludedOwners add constraint FK19190ED2C834E294 foreign key (task_id) references Task
                    2009-05-13 16:03:58,820 112564 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,821 112565 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_ExcludedOwners add constraint FK19190ED2B009A012 foreign key (entity_id) references OrganizationalEntity
                    2009-05-13 16:03:58,822 112566 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,824 112568 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_PotentialOwners add constraint FK9C9C2A96C834E294 foreign key (task_id) references Task
                    2009-05-13 16:03:58,824 112568 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,826 112570 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_PotentialOwners add constraint FK9C9C2A96B009A012 foreign key (entity_id) references OrganizationalEntity
                    2009-05-13 16:03:58,826 112570 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,865 112609 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_TaskStakeholders add constraint FKE6997FFAC834E294 foreign key (task_id) references Task
                    2009-05-13 16:03:58,866 112610 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,869 112613 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table PeopleAssignments_TaskStakeholders add constraint FKE6997FFAB009A012 foreign key (entity_id) references OrganizationalEntity
                    2009-05-13 16:03:58,869 112613 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:58,871 112615 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) Unsuccessful: alter table ProcessInstanceInfo_eventTypes add constraint FK2FD59D8CBEE4613C foreign key (ProcessInstanceInfo_processInstanceId) references ProcessInstanceInfo
                    2009-05-13 16:03:58,871 112615 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) ORA-00972: identifier is too long

                    2009-05-13 16:03:59,060 112804 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (main:) schema export complete

                    • 7. Re: Drools Dependencies in the ESB
                      wollint Newbie

                      These are the same types of errors we are seeing: invalid table name, table name too long, use of Oracle reserved words, field name too long, etc.

                      Would you like me to post our errors too (if we still have them)?

                      • 8. Re: Drools Dependencies in the ESB
                        Kevin Conner Master

                         

                        "mrman" wrote:
                        This is an extract from the server.log relating to the Drools issue:


                        Would it be okay to send me the log?

                        Thanks,
                        Kev

                        • 9. Re: Drools Dependencies in the ESB
                          Kevin Conner Master

                           

                          "wollint" wrote:
                          Would you like me to post our errors too (if we still have them)?

                          No need to post them, but you could email me the log if you wouldn't mind.

                          Thanks,
                          Kev

                          • 10. Re: Drools Dependencies in the ESB
                            Matthew Skevington Newbie

                            Kevin. Unfortunately, due to security constraints, I am unable to send the entire log.

                            I believe that the wrong SQL statements are being called, which are not compatible with Oracle's field length restrictions etc. Perhaps it is using a default script for say, Hypersonic?

                            • 11. Re: Drools Dependencies in the ESB
                              Kevin Conner Master

                              No problem, I have oracle installed locally.

                              Can you tell me which version you are using?

                              Thanks,
                              Kev

                              • 12. Re: Drools Dependencies in the ESB
                                Kevin Conner Master

                                Can you also send me your -ds.xml file?

                                Kev

                                • 13. Re: Drools Dependencies in the ESB
                                  wollint Newbie

                                  Tried both 10g and 11g.

                                  • 14. Re: Drools Dependencies in the ESB
                                    Matthew Skevington Newbie

                                    Kevin. I don’t think it’s the data source as all the other tables are being created properly on start-up. I just think whatever changes have been made since the previous version; regarding SQL scripts, are the root cause. However, for completeness, I’m including my –ds.xml file below. We are currently using Oracle 10g.

                                    <?xml version="1.0" encoding="UTF-8"?>
                                    
                                    <datasources>
                                     <local-tx-datasource>
                                     <jndi-name>DefaultDS</jndi-name>
                                     <connection-url>jdbc:oracle:thin:@xx.xx.xx.xx:1521:MYSID</connection-url>
                                     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                                     <user-name>username</user-name>
                                     <password>pwd</password>
                                     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
                                     <check-valid-connection-sql>select count(*) from jbm_user</check-valid-connection-sql>
                                    
                                     <metadata>
                                     <type-mapping>Oracle9i</type-mapping>
                                     </metadata>
                                     </local-tx-datasource>
                                    </datasources>


                                    1 2 Previous Next