[esb-issues] [JBoss JIRA] Created: (JBESB-1481) helloworld_tx_sql_action deployment error

[Daniel Bevenius (JIRA)]

helloworld_tx_sql_action deployment error
-----------------------------------------

                 Key: JBESB-1481
                 URL: http://jira.jboss.com/jira/browse/JBESB-1481
             Project: JBoss ESB
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Examples
    Affects Versions: 4.2.1
            Reporter: Daniel Bevenius
             Fix For: 4.2.1 CP1


Upon deploying the quickstart I get:

16:51:48,566 ERROR [XmlValidatorImpl] 1-ERROR-null-6:cvc-complex-type.4: Attribute 'message-column' must appear on element 'sql-message-filter'.
16:51:48,682 WARN  [ServiceController] Problem starting service jboss.esb:deployment=Quickstart_helloworld_TX_SQL_action.esb
java.lang.RuntimeException: java.lang.IllegalStateException: ESB file had validation errors.
        at org.jboss.soa.esb.listeners.config.Configuration.create(Configuration.java:132)
        at org.jboss.soa.esb.listeners.config.JBoss4ESBDeployment.startService(JBoss4ESBDeployment.java:82)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2

Modifying jboss-esb.xml and adding:
message-column="DATA_COL"
insert-timestamp-column="TIMESTAMP_COL"
to sql-bus named helloSQLChannel and deployment will succeed. I'll attach my jboss-esb.xml



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira