Search
Calendar
March 2024
S M T W T F S
« Sep    
 12
3456789
10111213141516
17181920212223
24252627282930
31  
Your widget title
Archives

Posts Tagged ‘ESB’

PostHeaderIcon Cannot run this command because Java services are not enabled. A user with System Administrator (SA) role must reconfigure the system to enable Java.

Context

An object is marshallized and sent on TibcoRV 8.1. An instance of Mule ESB 2.2.1 listens to TibcoRV, reads the message, unmarshalls the object and builds an SQL insert query.

The query is very simple:

insert into myTable(dateColumn, stringColumn) values(...)

It is executed in a Jdbc connector declared on Mule configuration file:

    <jdbc:connector name="jdbcConnector" dataSource-ref="mySybaseDB" pollingFrequency="1000">
        <jdbc:query key="writeTest"
                    value="INSERT INTO myTable(dateColumn, stringColumn)
                              VALUES(#[map-payload:myJavaDate],#[map-payload:myJavaString])"/>
    </jdbc:connector>

The DB is Sybase. The first column is of type datetime, the second one is varchar. The values are retrieved from a java.util.Date and a java.lang.String.

Case

When the query is run, I get the error:

java.sql.SQLException: Cannot run this command because Java services are not enabled. A user with System Administrator (SA) role must reconfigure the system to enable Java.

(you may get a com.sybase.jdbc2.jdbc.SybSQLException instead of java.sql.SQLException)

Explanation – Fix

The error is related only to Sybase, and not to TibcoRV and Mule: by default, Sybase cannot manage Java Dates (java.util.Date). You have to start explicitly the Java services. To perform that:

  • login with an username owing the rights “sa_role
  • run the SQL query:
    sp_configure 'enable java', 1
  • the restart the Sybase server

Now it should work. A similar error may occur with JBoss.

PostHeaderIcon Remote debug on Mule 2.2.1

Case

You have to run a standalone Mule 2.2.1 in debug mode. Since Mule is launched in standalone, you have to debug a remote application.

Fix

Nice case

  • Edit the %MULE_HOME%/conf/wrapper.conf
  • Uncomment the line:
    wrapper.java.additional.<n>=-Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=y,address=5005
  • Don’t forget to set the parameter <n>

Boring case

In my case (Windows XP SP2, Java 1.5), the Mule refused to start and freezed:

------------------------------------------------------------------------
The JVM is being launched with a debugger enabled and could possibly be
suspended.  To avoid unwanted shutdowns, timeouts will be disabled,
removing the ability to detect and restart frozen JVMs.
------------------------------------------------------------------------
Launching a JVM...
Listening for transport dt_socket at address: 5005
------------------------------------------------------------------------
Startup: Timed out waiting for a signal from the JVM.
The JVM was launched with debug options so this may be because the JVM
is currently suspended by a debugger.  Any future timeouts during this
JVM invocation will be silently ignored.
------------------------------------------------------------------------

The fix this:

  • Download the jar spring-agent here.
  • Move it into %MULE_HOME%/lib/user/
  • Edit the %MULE_HOME%/conf/wrapper.conf
  • add the following block:
  • wrapper.java.additional.3=-javaagent:%MULE_HOME%\lib\user\spring-agent-2.5.3.jar
    wrapper.java.additional.4=-Xdebug
    wrapper.java.additional.5=-Xnoagent
    wrapper.java.additional.6=-Djava.compiler=NONE
    wrapper.java.additional.7=-Xrunjdwp:transport=dt_socket,server=y,suspend=y,address=5005
  • (by the way, even though properties #3 and #5 are inconsistent, don’t mind)
  • launch the Mule
  • In your IDE (Eclipse, NetBeans, IntelliJ IDEA), run debug on localhost:5005

PostHeaderIcon org.springframework.beans.factory.xml.XmlBeanDefinitionReader: Ignored XML validation warning org.xml.sax.SAXParseException: SchemaLocation: schemaLocation value = … must have even number of URI’s

Context

Mule 2.2.1 ESB config file with a TibcoRV connector, under Windows XP SP2 and Java 5.
The error happened in this context, yet I assume it would occur in any occurence related to XSD / XML schemas.

Error

org.springframework.beans.factory.xml.XmlBeanDefinitionReader: Ignored XML validation warning
org.xml.sax.SAXParseException: SchemaLocation: schemaLocation value = 'http://www.mulesource.org/schema/mule/management/2.2                http://www.mulesource.org/schema/mule/management/2.2/mule-management.xsd                http://www.mulesource.org/schema/mule/core/2.2                http://www.mulesource.org/schema/mule/core/2.2/mule.xsd                http://www.springframework.org/schema/beans                http://www.springframework.org/schema/beans/spring-beans-2.5.xsd                http://www.mulesource.org/schema/mule/core/2.2/mule.xsd                http://www.mulesource.org/schema/mule/vm/2.2                http://www.mulesource.org/schema/mule/vm/2.2/mule-vm.xsd
http://www.mulesource.org/schema/mule/tibcorv/2.2                http://www.mulesource.org/schema/mule/tibcorv/2.2/mule-tibcorv.xsd' must have even number of URI's.

Headers of XML config file:

<mule xmlns=&amp;quot;http://www.mulesource.org/schema/mule/core/2.2&amp;quot;
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:spring="http://www.springframework.org/schema/beans"
xmlns:management="http://www.mulesource.org/schema/mule/management/2.2"
xmlns:tibcorv="http://www.mulesource.org/schema/mule/tibcorv/2.2
xsi:schemaLocation="http://www.mulesource.org/schema/mule/management/2.2
http://www.mulesource.org/schema/mule/management/2.2/mule-management.xsd
http://www.mulesource.org/schema/mule/core/2.2
http://www.mulesource.org/schema/mule/core/2.2/mule.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.mulesource.org/schema/mule/core/2.2/mule.xsd
http://www.mulesource.org/schema/mule/vm/2.2
http://www.mulesource.org/schema/mule/vm/2.2/mule-vm.xsd
http://www.mulesource.org/schema/mule/tibcorv/2.2
http://www.mulesource.org/schema/mule/tibcorv/2.2/mule-tibcorv.xsd">

Explanation – Fix

Each time, the attribute xsi:schemaLocation must have an even number of lines: a “public” XSD address and a “non-public” one. For non English-fluent speakers, I remind that a number is even if, and only if, it is a multiple of 2 ; otherwise it is odd.

In our case, one line is redundant. To fix this issue, you have to remove the redundant line, and ensure each line belongs to a consistent pair of lines: for instance:

http://www.mulesource.org/schema/mule/tibcorv/2.2
and
http://www.mulesource.org/schema/mule/tibcorv/2.2/mule-tibcorv.xsd

PostHeaderIcon TibrvException[error=901,message=Library not found: tibrvjsd]

Stacktrace

TibrvException[error=901,message=Library not found: tibrvjsd]

and below:

java.lang.UnsatisfiedLinkError: no tibrvjsd in java.library.path

The error appears also with tibrv instead of tibrvjsd.

Context

Mule ESB 2.2.1 using TibcoRV 8.1.2, under Windows XP, with Java 1.5

Explanation – Fix

  • Explanation:
    • the Mule tries to load a DLL, here tibrvjsd.dll. Its path should be available in the property java.library.path.
    • Unlike what may be found on the net, the right DLL cannot be found under
      %TIBRV_HOME%/lib, where only jars are available, not DLLs.
  • Backup the file %MULE_HOME%/conf/wrapper.conf
  • Edit it
  • After the lines
# Java Native Library Path (location of .DLL or .so files)
wrapper.java.library.path.1=%LD_LIBRARY_PATH%
wrapper.java.library.path.2=%MULE_HOME%/lib/boot

add the line:

wrapper.java.library.path.3=%TIBRV_HOME%/bin

PostHeaderIcon Use TibcoRV connector with Mule ESB

Installation

Prerequisites

Priori to following the current tutorial, you must have installed

  • a Java JDK/JRE 1.5+, with a parameter JAVA_HOME already set
  • a TibcoRV 8.1, with a parameter TIBRV_HOME already set. You can consult a short tutorial here to perform this.

Main

  • Get Zip version of “Mule ESB Full Distribution”, version 2.2.1, on this page.
  • Unzip the content in a folder, eg: C:\exe\mule-standalone-2.2.1
  • Add a environment variable MULE_HOME and update your path, eg:
    set MULE_HOME=C:\win32app\mule-standalone-2.2.1
    set PATH=%PATH%;%MULE_HOME%\bin
  • To check the Mule is well installed, you can launch the “Hello World” application:
    %MULE_HOME%\examples\hello\hello.bat

Specific for TibcoRV

  • Get mule-transport-tibcorv-2.2.1.jar, available at this link.
  • Copy it into %MULE_HOME%/lib/mule
  • Get the jar %TIBRV_HOME%\lib\tibrv.jar
  • Copy and rename it into %MULE_HOME%/lib/opt/tibrvj-8.1.2.jar
  • Tip: to know the exact version of the Jar you have just copied, you can open it, explore and decompile the class com.tibco.tobrv.tibrvj_id. The exact version must appear.
  • Copy %MULE_HOME%/conf/wrapper.conf as %MULE_HOME%/conf/wrapper.conf.old
  • Edit %MULE_HOME%/conf/wrapper.conf:
    • replace
      wrapper.java.library.path.1=%LD_LIBRARY_PATH%
      wrapper.java.library.path.2=%MULE_HOME%/lib/boot

      with:

      wrapper.java.library.path.1=%LD_LIBRARY_PATH%
      wrapper.java.library.path.2=%MULE_HOME%/lib/boot
      wrapper.java.library.path.3=%TIBRV_HOME%/bin

Here is for the very configuration.

“Hello world” for “TibcoRV via Mule”

Configuration file for Mule/TibcoRV “Hello World”

Code below is commented. Save it into a file named mule-config.xml.

<?xml version="1.0" encoding="UTF-8" ?>
<mule xmlns="http://www.mulesource.org/schema/mule/core/2.2"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:spring="http://www.springframework.org/schema/beans"
 xmlns:management="http://www.mulesource.org/schema/mule/management/2.2"
 xmlns:tibcorv="http://www.mulesource.org/schema/mule/tibcorv/2.2"
 xmlns:stdio="http://www.mulesource.org/schema/mule/stdio/2.2"
 xsi:schemaLocation="http://www.mulesource.org/schema/mule/management/2.2
 http://www.mulesource.org/schema/mule/management/2.2/mule-management.xsd
 http://www.mulesource.org/schema/mule/core/2.2
 http://www.mulesource.org/schema/mule/core/2.2/mule.xsd
 http://www.springframework.org/schema/beans
 http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
 http://www.mulesource.org/schema/mule/vm/2.2
 http://www.mulesource.org/schema/mule/vm/2.2/mule-vm.xsd
 http://www.mulesource.org/schema/mule/tibcorv/2.2
 http://www.mulesource.org/schema/mule/tibcorv/2.2/mule-tibcorv.xsd
 http://www.mulesource.org/schema/mule/stdio/2.2
 http://www.mulesource.org/schema/mule/stdio/2.2/mule-stdio.xsd">
 <!-- The TibcoRV we're listening is on the IP#127.0.0.1 -->
 <tibcorv:connector name="myTibcoConnector" network="127.0.0.1"/>
 <model name="fromTibco2stout">
 <service name="fromTibco">
 <inbound>
 <!-- We follow all subjects, on the TibcoRV connector defined above-->
 <tibcorv:inbound-endpoint connector-ref="myTibcoConnector" subject="*"/>
 </inbound>
 <echo-component/>
 <outbound>
 <pass-through-router>
 <!-- Messages received are displayed on standard output -->
 <stdio:outbound-endpoint address="stdio://OUT"/>
 </pass-through-router>
 </outbound>
 </service>
 </model>
</mule>

Run TibcoRV

Launch the daemon

Launch the daemon on localhost on port 7580:

%TIBRV_HOME\bin\rvd -http 7580

Launch a listener

Possibly, you can run a listener in a separate frame, in order to double check whether messages are sent and received in the right way, independantly of what happens on Mule side.
Listen to all messages with subject mySubject on localhost:7580

%TIBRV_HOME\bin\tibrvlisten.exe" -network localhost mySubject

Launch the Mule

  • Now run the ESB:
    %MULE_HOME%\bin\mule.bat -config path\to\file\mule-config.xml
  • Send a message:
    %TIBRV_HOME\bin\tibrvsend.exe -network 127.0.0.1  mySubject HelloWorld
  • Expected outputs:
    • On sending frame:
      Publishing: subject=mySubject "HelloWorld"
    • On listening frame:
      tibrvlisten: Listening to subject mySubject
      2010-01-21 17:51:43 (2010-01-21 16:51:43.109000000Z): subject=mySubject, message={DATA="HelloWorld"}
    • On Mule ESB frame:
      INFO  2010-01-21 17:53:02,860 [Bus] org.mule.transport.tibrv.TibrvMessageReceiver: message received
      on: *
      INFO  2010-01-21 17:53:02,860 [fromTibco.4] org.mule.transport.tibrv.TibrvMessageAdapter: The newThreadCopy method in AbstractMessageAdapter is being used directly. This code may be susceptible to 'scribbling' issues with messages. Please consider implementing the ThreadSafeAccess interface in the message adapter.
      INFO  2010-01-21 17:53:02,860 [fromTibco.4] org.mule.component.simple.LogComponent:
      ********************************************************************************
      * Message received in service: fromTibco. Content is: '{                       *
      * DATA="HelloWorldOfTheWorld" }'                                               *
      ********************************************************************************
      INFO  2010-01-21 17:53:02,860 [connector.stdio.0.dispatcher.3] org.mule.transport.stdio.StdioMessageDispatcher: Connected: endpoint.outbound.stdio://OUT
      {DATA=HelloWorldOfTheWorld, __send__subject__=mySubject}