| Author |
Message
|
| RaviSavi |
 Posted: Mon Apr 27, 2015 2:08 am Post subject: handling large message contains MIMEs (such as images) |
 |
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi All ,
Can someone help me here :
how to handle large message contains MIMEs (such as images) in IIB.
help is appreciated and thanks.
[/i] |
|
| Back to top |
|
 |
| shanson |
| Posted: Mon Apr 27, 2015 3:27 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Apr 27, 2015 4:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| I do not believe the MIME parser is a streaming parser, so you will have to make sure your system can handle reading and processing the entire contents of the "large" message in one go. |
|
| Back to top |
|
|
| RaviSavi |
| Posted: Wed May 06, 2015 3:50 am Post subject: Request to provide large message which contains MIMEs |
|
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi All,
Can someone give me " large message which contains MIMEs (such as images)" which I can use it as input message ...where I have MQinput node in that selected MIME as my parser.
from there I need to store the msg in database and same msg shud go to mq output queue.
my several thanks .... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed May 06, 2015 5:05 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Use a message flow to construct your sample message.
Fill the mime data parts with random bitstreams, or known document content. |
|
| Back to top |
|
|
| RaviSavi |
| Posted: Wed May 06, 2015 10:50 pm Post subject: |
|
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi,
I am really very new to this concept.
can you please provide me input message which contains MIMEs(images) so that i can use |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 07, 2015 4:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RaviSavi wrote: |
| I am really very new to this concept. |
Yes. That's why I suggested you should use the product to build the message you want to test against. This will help you understand how the logical message tree will look when you receive it at input.
It will also fail to send the message until the logical message tree is correct.
| RaviSavi wrote: |
| can you please provide me input message which contains MIMEs(images) so that i can use |
Oddly enough, I don't happen to have one lying around.
http://www-01.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ac30060_.htm |
|
| Back to top |
|
|
| RaviSavi |
| Posted: Tue May 12, 2015 9:53 pm Post subject: |
|
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi All,
can someone help me here:
How to store MIME message into db2 database. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed May 13, 2015 4:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RaviSavi wrote: |
Hi All,
can someone help me here:
How to store MIME message into db2 database. |
By using the DB2 ODBC drivers to put data into a db2 database. With an INSERT statement.
Is that not completely obvious to you?
Perhaps you should discuss this with your DBA, to find out what your actual database looks like, to determine what you personally need to do to process the data in your MIME document so that it matches the relevant tables.
I'm sure we can't answer that for you. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 13, 2015 5:39 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| RaviSavi wrote: |
can someone help me here:
How to store MIME message into db2 database. |
We did.
That's about all the help we can give. We certainly can't write code or provide test data. That's on you, and somebody is probably giving you money in return for the incovienience caused to you.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| inMo |
| Posted: Wed May 13, 2015 10:54 am Post subject: |
|
|
Master
Joined: 27 Jun 2009
Posts: 216
Location: NY
|
Did a quick search for a sample:
http://www.oreilly.com/openbook/mh/mulmes.htm
Pay attention to the "Content-type: image/gif" part (I suspect I should mention a good portion of the encoding is omitted for space reasons).
As for storing something like this message, deciding what part(s) do you want to store is probably the first step. |
|
| Back to top |
|
|
| RaviSavi |
| Posted: Wed May 13, 2015 10:00 pm Post subject: |
|
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi All,
Thanks for the replies.
my simple question is :
In which format the MIME message is stored in database.
I have only one column with datatype Varchar(256) intowhich the MIME msg comes and stores in DB. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 14, 2015 4:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RaviSavi wrote: |
| In which format the MIME message is stored in database. |
Whatever format you want.
| RaviSavi wrote: |
| I have only one column with datatype Varchar(256) intowhich the MIME msg comes and stores in DB. |
Then you won't be able to store more than 256 characters. That seems like it would only support small messages.
Also, without an index, selects on this colum will be slow.
Have you considered talking to a DBA, or asking questions on DB2 forum? |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 14, 2015 4:27 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| RaviSavi wrote: |
| In which format the MIME message is stored in database. |
However you chose to store it. A MIME (Multipart Internet Mail Extension) message holds any kind of data as separate "sections" in a message. So you'd hold a MIME section that contained an XML document differently to one that contained a JPG image.
All the MIME domain parser does inside broker is break up the message into it's sections. It's the responsibility of your code to interpret, parse and process the individual sections as needed.
| RaviSavi wrote: |
| I have only one column with datatype Varchar(256) intowhich the MIME msg comes and stores in DB. |
Well that's a) too small to be any practical value and b) assumes all the MIME content is text. Given that you started this thread asking how to store large messages with images, I would assert that you're out of luck. Quart in a pint pot and so forth.
I would take a step back, ask yourself how you'd store these images if they were not in a MIME message but being ftp's to you (and having stored them, how you'd find and retrieve them again) and having decided that, then ask yourself how that maps onto a MIME format.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 14, 2015 4:31 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Vitor wrote: |
| RaviSavi wrote: |
| In which format the MIME message is stored in database. |
However you chose to store it. A MIME (Multipart Internet Mail Extension) message holds any kind of data as separate "sections" in a message. So you'd hold a MIME section that contained an XML document differently to one that contained a JPG image. |
Or not. |
|
| Back to top |
|
|
|
|
