8 Replies Latest reply on Jan 27, 2007 12:17 PM by tfennelly

    Transformation Issues....

    tfennelly

      Hi all.

      Can all who've tried to use JBoss ESB Transformations please feedback
      all issues they've encountered, or comments they might have??

      A new and useful feature has been added to the admin console for the GA release (not in the CR2 release). It allows you test your transformations, from within the console, as you build them. This can be tried from the SVN trunk.

      Here's a flash demo that demonstrates some of the features of the admin
      console - http://milyn.codehaus.org/jbossesb/flash/console-demo-01.html.

      Regards,

      Tom.

        • 1. Re: Transformation Issues....
          jplenhart

          Hi Tom,

          I just did a fresh build out of svn - last time I updated was yesterday. Deployed the esb via the ant script within the install directory. Verified the app server was starting up without error.

          Went to the tools directory - built the console via the associated build file. Then copied the war file to my deploy directory. When I started the app server I am seeing a stack trace (shown below) - I wanted to give you this feedback:

          14:54:46,527 INFO [SessionFactoryObjectFactory] Factory name: java:/ esbDatabase
          14:54:46,527 INFO [NamingHelper] JNDI InitialContext properties:
          {java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory,
          java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
          14:54:46,528 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: java:/esbDatabase
          14:54:46,528 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
          14:54:46,555 INFO [SchemaExport] Running hbm2ddl schema export
          14:54:46,556 INFO [SchemaExport] exporting generated schema to database
          14:54:46,562 INFO [SchemaExport] Executing import script: /import.sql
          14:54:46,575 ERROR [SchemaExport] schema export unsuccessful
          org.hibernate.JDBCException: Error during import script execution
          at org.hibernate.tool.hbm2ddl.SchemaExport.importScript
          (SchemaExport.java:258)
          at org.hibernate.tool.hbm2ddl.SchemaExport.execute
          (SchemaExport.java:192)
          at org.hibernate.tool.hbm2ddl.SchemaExport.create
          (SchemaExport.java:133)
          at org.hibernate.impl.SessionFactoryImpl.
          (SessionFactoryImpl.java:311)
          at org.hibernate.cfg.Configuration.buildSessionFactory
          (Configuration.java:1291)
          at
          org.jboss.seam.microcontainer.HibernateFactory.createSessionFactory
          (HibernateFactory.java:133)
          at org.jboss.seam.core.HibernateSessionFactory.startup
          (HibernateSessionFactory.java:39)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke
          (DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:585)
          at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
          at org.jboss.seam.util.Reflections.invokeAndWrap
          (Reflections.java:102)
          at org.jboss.seam.Component.callComponentMethod
          (Component.java:1791)
          at org.jboss.seam.Component.callCreateMethod(Component.java:
          1739)
          at org.jboss.seam.Component.newInstance(Component.java:1728)
          at org.jboss.seam.contexts.Lifecycle.startup(Lifecycle.java:
          152)
          at org.jboss.seam.contexts.Lifecycle.endInitialization
          (Lifecycle.java:126)
          at org.jboss.seam.init.Initialization.init
          (Initialization.java:430)
          at org.jboss.seam.servlet.SeamListener.contextInitialized
          (SeamListener.java:33)
          at org.apache.catalina.core.StandardContext.listenerStart
          (StandardContext.java:3729)
          at org.apache.catalina.core.StandardContext.start
          (StandardContext.java:4187)
          at org.apache.catalina.core.ContainerBase.addChildInternal
          (ContainerBase.java:759)
          at org.apache.catalina.core.ContainerBase.addChild
          (ContainerBase.java:739)
          at org.apache.catalina.core.StandardHost.addChild
          (StandardHost.java:524)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke
          (DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:585)
          at org.apache.commons.modeler.BaseModelMBean.invoke
          (BaseModelMBean.java:503)
          at org.jboss.mx.server.RawDynamicInvoker.invoke
          (RawDynamicInvoker.java:164)
          at org.jboss.mx.server.MBeanServerImpl.invoke
          (MBeanServerImpl.java:659)
          at org.apache.catalina.core.StandardContext.init
          (StandardContext.java:5116)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke
          (DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:585)
          at org.apache.commons.modeler.BaseModelMBean.invoke
          (BaseModelMBean.java:503)
          at org.jboss.mx.server.RawDynamicInvoker.invoke
          (RawDynamicInvoker.java:164)
          at org.jboss.mx.server.MBeanServerImpl.invoke
          (MBeanServerImpl.java:659)
          at
          org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal
          (TomcatDeployer.java:297)
          at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy
          (TomcatDeployer.java:103)
          at org.jboss.web.AbstractWebDeployer.start
          (AbstractWebDeployer.java:371)
          at org.jboss.web.WebModule.startModule(WebModule.java:83)
          at org.jboss.web.WebModule.startService(WebModule.java:61)
          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.GeneratedMethodAccessor6.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:
          210)
          at $Proxy40.start(Unknown Source)
          at org.jboss.web.AbstractWebContainer.start
          (AbstractWebContainer.java:466)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          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.interceptor.AbstractInterceptor.invoke
          (AbstractInterceptor.java:133)
          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
          at
          org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke
          (ModelMBeanOperationInterceptor.java:142)
          at org.jboss.mx.interceptor.DynamicInterceptor.invoke
          (DynamicInterceptor.java:97)
          at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext
          (InterceptorServiceMBeanSupport.java:238)
          at org.jboss.ws.server.WebServiceDeployer.start
          (WebServiceDeployer.java:117)
          at org.jboss.deployment.SubDeployerInterceptorSupport
          $XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
          at org.jboss.deployment.SubDeployerInterceptor.invoke
          (SubDeployerInterceptor.java:95)
          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:659)
          at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:
          210)
          at $Proxy41.start(Unknown Source)
          at org.jboss.deployment.MainDeployer.start(MainDeployer.java:
          1007)
          at org.jboss.deployment.MainDeployer.deploy
          (MainDeployer.java:808)
          at org.jboss.deployment.MainDeployer.deploy
          (MainDeployer.java:771)
          at sun.reflect.GeneratedMethodAccessor8.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.interceptor.AbstractInterceptor.invoke
          (AbstractInterceptor.java:133)
          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
          at
          org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke
          (ModelMBeanOperationInterceptor.java:142)
          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:659)
          at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:
          210)
          at $Proxy6.deploy(Unknown Source)
          at org.jboss.deployment.scanner.URLDeploymentScanner.deploy
          (URLDeploymentScanner.java:421)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scan
          (URLDeploymentScanner.java:634)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner
          $ScannerThread.doScan(AbstractDeploymentScanner.java:263)
          at
          org.jboss.deployment.scanner.AbstractDeploymentScanner.startService
          (AbstractDeploymentScanner.java:336)
          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart
          (ServiceMBeanSupport.java:289)
          at
          org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle
          (ServiceMBeanSupport.java:245)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          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.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:
          210)
          at $Proxy4.start(Unknown Source)
          at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
          at org.jboss.deployment.MainDeployer.start(MainDeployer.java:
          1007)
          at org.jboss.deployment.MainDeployer.deploy
          (MainDeployer.java:808)
          at org.jboss.deployment.MainDeployer.deploy
          (MainDeployer.java:771)
          at org.jboss.deployment.MainDeployer.deploy
          (MainDeployer.java:755)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:39)
          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.interceptor.AbstractInterceptor.invoke
          (AbstractInterceptor.java:133)
          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
          at
          org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke
          (ModelMBeanOperationInterceptor.java:142)
          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:659)
          at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:
          210)
          at $Proxy5.deploy(Unknown Source)
          at org.jboss.system.server.ServerImpl.doStart
          (ServerImpl.java:482)
          at org.jboss.system.server.ServerImpl.start(ServerImpl.java:
          362)
          at org.jboss.Main.boot(Main.java:200)
          at org.jboss.Main$1.run(Main.java:464)
          at java.lang.Thread.run(Thread.java:613)
          Caused by: java.sql.SQLException: Wrong data type: hexadecimal string with odd number of characters
          at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
          at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
          at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
          at org.jboss.resource.adapter.jdbc.WrappedStatement.execute
          (WrappedStatement.java:82)
          at org.hibernate.tool.hbm2ddl.SchemaExport.importScript
          (SchemaExport.java:254)
          ... 156 more
          14:54:46,600 INFO [NamingHelper] JNDI InitialContext properties:
          {java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory,
          java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
          14:54:46,609 INFO [Initialization] done initializing Seam
          14:54:46,679 INFO [ServletCacheAdministrator] Created new instance of ServletCacheAdministrator
          14:54:46,679 INFO [ServletCacheAdministrator] Created new application-scoped cache at key: __oscache_cache
          14:54:46,933 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
          14:54:47,230 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
          14:54:47,303 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
          14:54:47,313 INFO [JkMain] Jk running ID=0 time=0/29 config=null
          14:54:47,344 INFO [Server] JBoss (MX MicroKernel) [4.0.4.GA (build:
          CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 27s:680ms 14:55:29,400 INFO [GatewayListenerController] Reloading parameters _____________________________________________________
          14:55:29,404 INFO [GatewayListenerController] No value specified
          for: endTime - Listener will run until parent container/process terminates.





          • 2. Re: Transformation Issues....
            tfennelly

            Thanks Jason.

            Hmmm, nothing obvious there! I'll try a clean checkout and a clean AS deployment and see can I reproduce this.

            Regards,

            Tom.

            • 3. Re: Transformation Issues....
              jplenhart

              Hi,

              I would have put some more time into it but was running short. I will try again today and see if it all goes cleanly. Thanks, Jason

              • 4. Re: Transformation Issues....
                tfennelly

                Ok, so I:

                1: Reinstalled the AS,
                2: Got a fresh checkout of the product and built the distro
                3: Built the console for Hypersonic (from the distro)
                4: Started the new AS and deployed the Console App.

                I'm not seeing this error on my setup, which is:
                1: AS = 4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000) (same as Jasons). Deployed the "default" profile.
                2: JDK = 1.5.0_10
                3: OS = Windows

                What AS deployment are you running this off Jason?

                Did you try deleting the AS temp + data + work folders by any chance?

                • 5. Re: Transformation Issues....
                  dlarsson

                  Hi,

                  I had to remove the QName class from jbossesb.sar/xbean-1.0.4.jar in order to run transformations. I'm running JBossAS4.0.5GA on Java5 (Windows) with ESB deployed in the application server.

                  Regards
                  David

                  • 6. Re: Transformation Issues....
                    tfennelly

                     

                    "dlarsson" wrote:
                    I had to remove the QName class from jbossesb.sar/xbean-1.0.4.jar in order to run transformations. I'm running JBossAS4.0.5GA on Java5 (Windows) with ESB deployed in the application server.


                    Thanks David. In fact this is part of a more general problem that SAR deployment of the the ESB suffers from (classloader issue). Kurt Stam fixed this issue just yesterday, so it should be sorted for the GA.

                    Thanks for reporting this David.

                    • 7. Re: Transformation Issues....
                      jplenhart

                      Hi Tom -- updating some docs today and checking in some unit tests. Tomorrow morning ... going to do a fresh build and AS deployment and walkthrough the console. Will give feedback.

                      Thanks,

                      Jason

                      • 8. Re: Transformation Issues....
                        tfennelly

                        Thanks Jason.

                        Don't forget to check out the flash demos too.