Posts Tagged ‘ESB’
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.
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
localhost:5005
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=&quot;http://www.mulesource.org/schema/mule/core/2.2&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
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
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
- replace
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}
- On sending frame: