Dear Dzung,

this should be fairly simple: You activated the validation and this goes through all your fields and checks the required boundaries. Your OMP_O09_ORDER is defined as having minimum one instance (have a look at the minimum occurrence attribute of the field).

Regarding your empty fields: The field delimiter is defined as r or carriage return. However your test file provides rn also known as carriage return+line feed. Just switch your text editor to using mac line endings (these are just r) and the file parses just fine.

Best regards,
Matthias

Hi nmishra,

this seems to be oracle SQL code, but your database is configured as postgresql. This may be the problem. please switch your database type to "Oracle", either new or conventional, in Saddle's database connection configuration and try to connect using the button "test JDBC connection".

Unfortunately I can not set up an Oracle database for testing here.

Just tell me if you have further questions to this.

Best regards,
Matthias

Hi,

The exception

Root Exception stack trace: 

java.sql.SQLException: Invalid column type 

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) 

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) 

    + 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything) 

lets me think that perhaps the data types of the outbound fields are wrong. Could you please provide an SQL script that allows me to create your test database here, so that I can have a look at it?

Normally JDBC only accepts matching datatypes for a query (so a String for a String, a Date for a Date and so on).

Perhaps that's the problem.

Best regards,
Matthias

Hi nmishra,

I just had a short look at your configuration and I assume your problem may be the query that you defined as

INSERT INTO test1(userid, fname, lname) VALUES( #[map-payload:{}]{userid},{fname},{lname});

you see the #[map-payload:{}] there? This seems to have slipped in by clicking around in the list of snippets. Please remove this part of the query and test whether this solves your problem.

Your query should look like this afterwards:

INSERT INTO test1(userid, fname, lname) VALUES({userid},{fname},{lname});

Please let me know if this does not fix your problem.

Best regards,
Matthias

Dear gosi,

you need the JDK to run Saddle. Unfortunately the error mesage is not very specific about that.

Best regards,
Matthias

Dear Dzung, I will answer your questions one at a time

dzungdev wrote:

1. Where can I put MyConnectException class ? Is it in custom part ?

Yes, just put your class into the custom folder and it will be deployed in the custom.jar and available for mule.

dzungdev wrote:

2. Actually I want to catch the ConnectException which will happen if my system can't connect to 3rd system (in the case the 3rd system isn't available). Is it possible to catch ConnectException when I have to work with MyConnectException here ?

In your ExceptionListener implementation you can handle all exceptions, just in the Mule way. The java.beans.ExceptionListener(the only one that I found on the classpath) is an interface for handling exceptionsin it's exceptionThrown method. Your class MyConnectException (which is actually a confusing name for a class that catches exceptions) can handle all kinds of exceptions.

Best regards,
Matthias

Dear dzung,

XML can not be posted to the forum (which unfortunately can't be changed), so please just attach the java class of your exception strategy and a small file containing the xml snippet to your post, please.

Best regards,
Matthias

Dear Dzung,

please have a look at this part of the documentation:

http://www.mulesoft.org/documentation/d … +Reference

Best regards,
Matthias

Dear Dzung,

the custom exception strategy expect an exception strategy class instead of the exception class. Please read this part of Mule's documentation to gain more knowledge about exception strategies.

Best regards,
Matthias

Dear Dzung,

we don't have a running HL7 system here, we just provide the development tools and have not developed a full HL7 system, so we did not run into this problem until now.

Sorry I can't help you,
Matthias

Dear Dzung,

actually the reconnection does not work for me either (I just tested it) so you will have to go into more detail on the mule side here. Perhaps the strategy has to be configured in a different way.

Best regards,
Matthias

Dear Dzung,

please post new logs (and please cut them down to just the last run). I just see the exception when trying to connect and no reconnection attempts whatsoever. Also please switch the time between retries to a lower number to see a result faster.

Best regards,
Matthias

Dear Dzung,

yes, according to the following line mule should try to reconnect each 30 seconds a thousand times if the message can not be delivered.

reconnect count="1000" frequency="30000"

Did you get any logging output that might be helpful? Consider having a look at both the mule and app log.

Best regards,
Matthias

[edit] And there is still the "reconnect" section in your endpoint. Please remove that or mule will not be able to start properly.

Dear Dzung,

in this case I think it might make more sense to write up a little script file (batch or shell) that just replaces the values in the xml file within Mule. I do not think that it is possible for mule to read data like this dynamically, but you should perhaps check back in their forum.

There is also the possibility to place a property file inside the mule folder and read values like this from there. Unfortunately such a property file can not automatically be deployed with Saddle, so you would have to package it into the mule application once before handing it over to the deployment engineer.

Hope this helps,
Matthias

Dear Dzung

dzungdev wrote:

I just saw that we can use Saddle Properties view to create a HL7 Connector. Then we open the workflow xml file and put  element in HL7 Connector. If this way is correct, the disadvantage is each time we want to change the value of , we have to change in workflow file and re-deploy again.

Sure, as soon as you change the configuration you will have to re-deploy it. Another way of doing it would be to change it in the deployed configuration. But anyway these settings should not be changed very frequently.

dzungdev wrote:

As I understand your way is you want to use code in Service component to set the property value for  element in HL7 Connector. Is it right ? If yes, the steps will be:
1. creating RetryPolicyTemplate
2. Setting RetryPolicyTemplate to HL7 Connector

What are you talking about here? Do you want to have dynamic retry values dependent on the message? I do not think this is possible or even makes a lot of sense.

Best regards,
Matthias

Dear Dzung,

you can not just hack it into the connector element, but you need to create a new xml element "reconnect" which then holds the properties you want to set. All direct properties of the connectors can be set in the UI (as they are just read from the XSD).

Best regards,
Matthias

Dear Dzung,

the solution to this problem is easy: just create a connector. As long as you only have one defined for a certain protocol (like HL7 here)  it will automatically be used by all endpoints using this protocol. If you define more than one you have to assign a connector to all endpoints, so that they know which one to use.

So you are left with a choice of two options:

1. Create just one connector which is then used in all endpoint of the same type (for example HL7)
2. Create several connectors if you need different properties and assign one of them to each endpoint

Dear Dzung,

I assume you took your selection of properties from this mule documentation page.

You will actually have to put the reconnect segment INTO the connector entry in the xml manually as Saddle unfortunately has no GUI support for this.

Once you put it there it will remain there as long as you do not delete the connector.

I hope this helps.

Best regards,
Matthias

Dear ajasharma,

Saddle should be fit for HL7 v3 as we just extended our XML support for Saddle 1.0 (and onwards). Unfortunately there are no real examples, but you can generate a template from any XML or XSD file as described here and use this like in the tutorial for Hl7 version 2.x (available from the download section).

If you need any further assistance I'd be glad to answer all your questions.

Best regards,
Matthias

Dear Dzung,

thanks for sharing the information! This might be helpful to some people that swing by here.

Best regards,
Matthias

Dear Dzung,

I just don't work with Spring at all :) We just did not need it until now.

Best regards,
Matthias

Dear Dzung,

I have no idea about springs autowired annotation, but I know mule's classloader architecture pretty well. So a general advice: if you pack your libraries into lib/user and leave the others in the lib/opt folder the lib/opt will be loaded first, then, in another linked classloader the lib/user files will be loaded. As the last step in the class loader hierarchy the libs of your applications lib folder will be loaded.

Also there is quite a lot of logging output generated by spring, so you should definitely have a look at all of this stuff, whether there is any hint for you.

Best regards,
Matthias

Dear Dzung,

we had a similar problem with our monitoring and went with placing the files in the different lib folder, according to where and when we needed them (the class loaders are sometimes global for all apps and sometimes not).

But in your case you will probably have to modify the mule libraries as I know no way of telling mule to load one jar instead of another one.


Best regards,
Matthias

Dear Dzung,

here is the result you are looking for (from google):

http://forum.mulesoft.org/mulesoft/topi … config_xml

As I already said: this is mule specific, so please consult their documentation first, when you try to add custom code to the XML file.

Best regards,
Matthias

Dear Dzung,

I am actually aware of this, but the processing takes some time, so please just attach the files that we need directly to your post. This makes handling the requests easier.

I will have a look at it later one and let you know if I find anything.

Best regards,
Matthias