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

[Mark Little (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-1481?page=all ]

Mark Little closed JBESB-1481.
------------------------------

    Resolution: Done

> 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
>         Assigned To: Mark Little
>             Fix For: 4.2.1 CP1
>
>         Attachments: jboss-esb.xml
>
>
> 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