tag:blogger.com,1999:blog-1839316484051079047.post5478495310906731697..comments2024-03-28T06:38:40.958+01:00Comments on Java / Oracle SOA blog: Flat file to xml with Oracle Service BusEdwin Biemondhttp://www.blogger.com/profile/02338716126881111629noreply@blogger.comBlogger95125tag:blogger.com,1999:blog-1839316484051079047.post-59770505643671154462016-05-06T14:30:11.559+02:002016-05-06T14:30:11.559+02:00Hello everyone!For a better management of your tra...Hello everyone!For a better management of your translation files, I recommend to have a look at this online software localization tool like <a href="https://poeditor.com" rel="nofollow">POEditor</a> to reduce time with projects and simplify the workflow. Anonymoushttps://www.blogger.com/profile/17837421672939274498noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-25327612878409149432015-02-10T01:04:02.922+01:002015-02-10T01:04:02.922+01:00Edwin:
In the second assign we will create a new b...Edwin:<br />In the second assign we will create a new body and pass this to the body variable.<br />when I run a test I got the error below (Please advise):<br /> <Exception on TransportManagerImpl.receiveMessage, com.bea.wli.sb.context.BindingLayerException: Failed to set the value of context variable "body". Value must be an instance of {http://schemas.xmlsoap.org/soap/envelope/}Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-61301680498474591802015-01-12T20:47:26.522+01:002015-01-12T20:47:26.522+01:00Hello Edwin,
How do we go about doing the reverse ...Hello Edwin,<br />How do we go about doing the reverse i.e. Converting XML messages into CSV files.<br />Is it possible using MFL. Also is it possible using the JCA adapter.<br />How is it done?<br />Ankit Maliknoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-17771113323023117902014-04-24T21:54:30.049+02:002014-04-24T21:54:30.049+02:00Hi Guys,
Can you please help me on publishing a ...Hi Guys, <br /><br />Can you please help me on publishing a large size xml request (around 100-200 mb) to JMS queue through Oracle Service Bus.<br />Presently I am using a Business service to publish the request but while executing it gives unexpected error occur message. Please help me ... Thanks in advanceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-56039834305727600222014-02-22T09:21:46.922+01:002014-02-22T09:21:46.922+01:00Hi Edwin,
i am reading a text file using file tr...Hi Edwin,<br /><br />i am reading a text file using file transport of proxy service. which later uses MFL transform action to convert text to xml using the MFL created for this.When I run MFL, it runs absolutely fine , but when i run end to end, the file once read, it is failing at MFL transformation step.Upon further investigation, i found that when i am placing the file with text data in Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-7631188937844555542014-02-03T23:54:37.743+01:002014-02-03T23:54:37.743+01:00Hi Edwin-
Great post as always. I am trying below...Hi Edwin-<br /><br />Great post as always. I am trying below using MFL , please let me know if this looks fine . Its not working :<br /><br />1) Business service - invoking webservice returning CSV data (Input : None , Output : MFL)<br />2) Proxy service invoking the Business service , captures resposnse and applies the Xquery for MFL.<br /><br />Its always failing with error " BEA-382030: Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-58603122278332975762014-01-22T12:46:22.158+01:002014-01-22T12:46:22.158+01:00Hi Steve, Were you able to achieve this ? I am als...Hi Steve, Were you able to achieve this ? I am also trying to do the same thing ..kindly share .ThanksRajeshhttps://www.blogger.com/profile/05154742451189517721noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-58910164430631053662013-11-07T06:39:57.670+01:002013-11-07T06:39:57.670+01:00HI, Have a look on this post ..... http://java.net...HI, Have a look on this post ..... http://java.net/projects/oracleservicebus1031/downloads/download/INTEGRATING-EXCEL-WITH-OSB.zipKrishna Ravurihttps://www.blogger.com/profile/04896408247487766271noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-38633070507411859262013-10-24T18:40:00.575+02:002013-10-24T18:40:00.575+02:00is there anyone knows how to read xlsx file from o...is there anyone knows how to read xlsx file from oracle service bus without using JAVA callout ?Anonymoushttps://www.blogger.com/profile/01870779249819501021noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-82192353118831975302013-10-17T16:54:26.973+02:002013-10-17T16:54:26.973+02:00Hi,
MFL is not the right tool for binary data, fo...Hi,<br /><br />MFL is not the right tool for binary data, for this you can do a java callout to change it to text or directly to xml.<br /><br />ThanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-64239475539955126702013-10-17T16:52:32.462+02:002013-10-17T16:52:32.462+02:00Hi,
Can you read the transport element of the inb...Hi,<br /><br />Can you read the transport element of the inbound variable, this contains all the data.<br /><br />ThanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-65051188841561671272013-10-15T10:07:06.682+02:002013-10-15T10:07:06.682+02:00I have a requirement to covert a binary data(will...I have a requirement to covert a binary data(will get binary data from JCAPS) to XML format through MFL transformation.<br /><br />Please hlep me out of this . <br /><br />Thanks Anonymoushttps://www.blogger.com/profile/01870779249819501021noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-24123364609615108142013-10-07T15:57:40.420+02:002013-10-07T15:57:40.420+02:00Hi Edwin,
do you know if is possible to read the b...Hi Edwin,<br />do you know if is possible to read the body, sender and subject of emails and process the data included in that?<br />I'm facing with that with no success.<br />Any suggestions?<br /><br />Thanks.<br /><br /><br />IAnonymoushttps://www.blogger.com/profile/11431313697993935795noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-87508774841349978932013-09-26T16:51:47.793+02:002013-09-26T16:51:47.793+02:00Hi,
I am facing an issue in MFL transformation. F...Hi,<br /><br />I am facing an issue in MFL transformation. For new line we are using “/n” in attribute values. When we are testing it in MFL itself, it is working fine. But when we are using it from web service it is not working. <br />e.g <br />Non XML:<br />a,b<br />c,d<br />e,f<br />g,h<br />I want it like <br /><br /><br /> <br /> a<br /> b<br /> <br /> <br />Anonymoushttps://www.blogger.com/profile/01870779249819501021noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-55152622804365215832013-08-26T10:44:05.090+02:002013-08-26T10:44:05.090+02:00Sorry, there was a typo, it should be repeat='...Sorry, there was a typo, it should be repeat='5'.<br /><br />..VikashAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-53741890894250207862013-08-26T07:33:01.111+02:002013-08-26T07:33:01.111+02:00Thanks for sharing knowledge with us Edwin.
I jus...Thanks for sharing knowledge with us Edwin.<br /><br />I just need an information on mfl. We have a complex node to repeat from 0 to 5(not more than that). But when I set repeat='*', it means, minOccurs is 5 as well as maxOccurs also as 5. Is there any alternative that I have missed?<br /><br />Thanks in advance,<br />VikashAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-9446061571405264452013-05-01T22:20:57.200+02:002013-05-01T22:20:57.200+02:00Hi,
MFL can be very tricky especially with the la...Hi,<br /><br />MFL can be very tricky especially with the last line I always end with a CR LF<br />Can you use soa suite?<br /><br />Thanks<br />Edwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-7692532915196243112013-04-25T00:11:59.386+02:002013-04-25T00:11:59.386+02:00MFL is missing in my previous update:
...MFL is missing in my previous update:<br /><br /><br /><br /><br /><br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /><br />Ramana RangaRajuhttps://www.blogger.com/profile/17667412164098251699noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-86505855670944385622013-04-24T22:48:48.278+02:002013-04-24T22:48:48.278+02:00Hi Edwin,
I have created one similar MFL for conv...Hi Edwin,<br /><br />I have created one similar MFL for converting CSV to XML. The result I am getting is inconsistent. Same file works and next run it fails.<br /><br />Only difference in the MFL is, I have added additional attribute called dataDelim='"' as I have to ignore optional delimiter.<br /><br />Input:<br /><br />H,"e1","e2"<br />L,"le1","Ramana RangaRajuhttps://www.blogger.com/profile/17667412164098251699noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-76253828234963926802013-04-19T14:32:08.015+02:002013-04-19T14:32:08.015+02:00Hi,
you can use the JCA File adapter of Jdevelope...Hi,<br /><br />you can use the JCA File adapter of Jdeveloper in OSB. this uses XSD. MFL was already there before Oracle bought Bea.<br /><br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-9848904645019549872013-04-18T15:00:45.790+02:002013-04-18T15:00:45.790+02:00why do we need to read csv file in OSB using MFL?
...why do we need to read csv file in OSB using MFL?<br />can't we do it through XSD instead of MFL as we do in Oracle SOA.<br /><br />MFL is again defining the CSV file structure like fieldname and datatype.<br />Can you please comment on this. I am confused between MFL and XSD.<br />Veereshnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-30756288780205969372013-04-04T11:05:02.653+02:002013-04-04T11:05:02.653+02:00Hi,
I am sorry to reply to such an old post, but t...Hi,<br />I am sorry to reply to such an old post, but the Oracle support team is taking far too long to respond.<br /><br />the trim trailing character feature does not work for many people:<br /><br />https://forums.oracle.com/forums/thread.jspa?threadID=2251182<br /><br />Searching for the Format Builder patch returned no results.<br /><br />My SR returned no results either. <br /><br />Is Nick Aivahttp://nickaiva.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-10680064075999828472013-03-27T13:49:28.105+01:002013-03-27T13:49:28.105+01:00Hi Edwin,
My mfl test works fine.. later during xq...Hi Edwin,<br />My mfl test works fine.. later during xquery transformation I didn't get the fields listed in non XML source type. Since the fields are not listed I couldn't do the mapping with the schema file. Kindly guide me regarding this.<br /><br />Thanks,<br />Tamiltamilnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-37950926291356476622012-12-27T20:29:32.039+01:002012-12-27T20:29:32.039+01:00Hi,
can you try to escape the data and have the e...Hi,<br /><br />can you try to escape the data and have the elements string as data types.<br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-41502081670829971812012-12-24T13:15:20.848+01:002012-12-24T13:15:20.848+01:00Hi,
I am using MFL transform and converting it fr...Hi,<br /> I am using MFL transform and converting it from xml to fixed length message but as soon as i replace body with the fixed length message then the trailing spaces are removed and i need these spaces. How to achieve this.<br /><br />Regards,<br />Nishith Anonymoushttps://www.blogger.com/profile/02308899361699800663noreply@blogger.com