You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Saibabu Vallurupalli <sa...@gmail.com> on 2012/03/20 20:00:09 UTC
EMail attachments
Hi Team,
At present I have a requirement to extract the email attachment and put
them in a separate folder for different use.
What is the best way to do this? Does the attachments are stored in MySQL
database?
Any inputs on this will be really helpful.
Thank you,
Sai
Re: EMail attachments
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
My plan is to use JPA as well. I like the idea.
Thanks Eric.
On Wed, Mar 21, 2012 at 2:18 AM, Eric Charles <er...@apache.org> wrote:
> Hi Sai,
>
> You could do it
> - with plain SQL
> - use the James JPA classes and build your own queries
> - completely reuse the mailbox API (you will have an InputStream to be
> given to mime4j - can be good in case of large attachments)
>
>
> Eric
>
>
> On 21/03/12 00:26, Saibabu Vallurupalli wrote:
>
>> Hi Ioan,
>>
>> I see what you are saying, Thank you for recommendations I guess we need
>> to
>> write a new code to read the BLOB content and extract attachments.
>>
>> Thank you, Sai
>>
>>
>> On Tue, Mar 20, 2012 at 7:15 PM, Ioan Eugen Stan<st...@gmail.com>**
>> wrote:
>>
>> 2012/3/21 Saibabu Vallurupalli<sa...@gmail.com>
>>> >:
>>>
>>>> Hi Ioan,
>>>>
>>>> My name is Sai :-)
>>>>
>>>
>>> Hi,
>>>
>>> I noticed the mistake just after sending, sorry about that.
>>>
>>> Also, I am aware of the code you pointed to me any ways Thank you. I
>>>>
>>> wrote
>>>
>>>> JPAEncryptedMessage.java :-)
>>>>
>>>> What I am looking for is how to extract just attachment from body
>>>> content
>>>> BLOB without any code modifications to James source.
>>>>
>>>> Please let me know if you have any ideas?
>>>>
>>>> Thanks, Sai.
>>>>
>>>
>>> Well, you can't do a job and not have your hands dirty ;). I can't
>>> seem to think how you could do that besides a mailet or an external
>>> tool that accesses the database and processes the messages. I would go
>>> with a mailet, should be pretty easy to implement mime parsing there.
>>>
>>>
>>>> On Tue, Mar 20, 2012 at 6:56 PM, Ioan Eugen Stan<stan.ieugen@gmail.com
>>>> wrote:
>>>>
>>>> 2012/3/20 Saibabu Vallurupalli<sa...@gmail.com>
>>>>> >:
>>>>>
>>>>>> Hi Eric,
>>>>>>
>>>>>> We are trying to retrieve it after storing to make it more simple.
>>>>>>
>>>>> During
>>>
>>>> process might need a code change in mailets I guess.
>>>>>> If it is a completed email in BLOB, is there a way to extract just
>>>>>> attachment?
>>>>>>
>>>>>> Thanks, Sai
>>>>>>
>>>>>>
>>>>> Hello Say,
>>>>>
>>>>> You will have to load the email and use mime4j to process it and
>>>>> extract attachments. The code that maps one message to a database
>>>>> table is in JPAMessage class [1]. If you look closely, you will see
>>>>> the JPA annotations for headers and body like bellow. JPAMessage class
>>>>> has getBodyContent and getHeaderContent methods to get an InputStream
>>>>> for each value.
>>>>>
>>>>> 5 /** The value for the body field. Lazy loaded */
>>>>> 46 /** We use a max length to represent 1gb data. Thats prolly
>>>>> overkill, but who knows */
>>>>> 47 @Basic(optional = false, fetch = FetchType.LAZY)
>>>>> 48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable =
>>>>>
>>>> false)
>>>
>>>> 49 @Lob private byte[] body;
>>>>>
>>>>> 52 /** The value for the header field. Lazy loaded */
>>>>> 53 /** We use a max length to represent 1gb data. Thats prolly
>>>>> overkill, but who knows */
>>>>> 54 @Basic(optional = false, fetch = FetchType.LAZY)
>>>>> 55 @Column(name = "HEADER_BYTES", length = 10485760, nullable =
>>>>>
>>>> false)
>>>
>>>> 56 @Lob private byte[] header;
>>>>>
>>>>>
>>>>> [1]
>>>>>
>>>>> http://svn.apache.org/viewvc/**james/mailbox/trunk/jpa/src/**
>>> main/java/org/apache/james/**mailbox/jpa/mail/model/**
>>> openjpa/JPAMessage.java?view=**markup<http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup>
>>>
>>>>
>>>>> On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles<er...@apache.org>
>>>>>>
>>>>> wrote:
>>>
>>>>
>>>>>> Hi Sai,
>>>>>>> If you use JPA, the complete mail is stored as a blob in the
>>>>>>>
>>>>>> JAMES_MESSAGE
>>>>>
>>>>>> table (see http://james.apache.org/****server/3/images/database/**<http://james.apache.org/**server/3/images/database/**>
>>>>>>> james-database-schema-derby_****1000.png<
>>>>>>>
>>>>>>
>>>>> http://james.apache.org/**server/3/images/database/**
>>> james-database-schema-derby_**1000.png<http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png>
>>>
>>>> for
>>>>
>>>>> an old version of the schema).
>>>>>
>>>>>>
>>>>>>> Are you looking to extract it when processing the mail in a mailet,
>>>>>>>
>>>>>> or
>>>
>>>> extract afterwards when already stored in the database? The
>>>>>>>
>>>>>> implementations
>>>>>
>>>>>> will be quite different depending on your need.
>>>>>>>
>>>>>>> Thx, Eric
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
>>>>>>>
>>>>>>> Hi Team,
>>>>>>>>
>>>>>>>> At present I have a requirement to extract the email attachment and
>>>>>>>>
>>>>>>> put
>>>
>>>> them in a separate folder for different use.
>>>>>>>>
>>>>>>>> What is the best way to do this? Does the attachments are stored in
>>>>>>>>
>>>>>>> MySQL
>>>>>
>>>>>> database?
>>>>>>>>
>>>>>>>> Any inputs on this will be really helpful.
>>>>>>>>
>>>>>>>> Thank you,
>>>>>>>> Sai
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>> eric | http://about.echarles.net | @echarles
>>>>>>>
>>>>>>>
>>>>>>>
>>>>> ------------------------------****----------------------------**
>>> --**---------
>>>
>>>> To unsubscribe, e-mail: server-dev-unsubscribe@james.****apache.org<
>>>>>>>
>>>>>> server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
>>>>> >
>>>>>
>>>>>> For additional commands, e-mail: server-dev-help@james.apache.***
>>>>>>> *org<
>>>>>>>
>>>>>> server-dev-help@james.apache.**org <se...@james.apache.org>
>>>>> >
>>>>>
>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Ioan Eugen Stan
>>>>> http://ieugen.blogspot.com/
>>>>>
>>>>> ------------------------------**------------------------------**
>>>>> ---------
>>>>> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
>>>>> For additional commands, e-mail: server-dev-help@james.apache.**org<se...@james.apache.org>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>> --
>>> Ioan Eugen Stan
>>> http://ieugen.blogspot.com/
>>>
>>> ------------------------------**------------------------------**
>>> ---------
>>> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
>>> For additional commands, e-mail: server-dev-help@james.apache.**org<se...@james.apache.org>
>>>
>>>
>>>
>>
> --
> eric | http://about.echarles.net | @echarles
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
> For additional commands, e-mail: server-dev-help@james.apache.**org<se...@james.apache.org>
>
>
Re: EMail attachments
Posted by Eric Charles <er...@apache.org>.
Hi Sai,
You could do it
- with plain SQL
- use the James JPA classes and build your own queries
- completely reuse the mailbox API (you will have an InputStream to be
given to mime4j - can be good in case of large attachments)
Eric
On 21/03/12 00:26, Saibabu Vallurupalli wrote:
> Hi Ioan,
>
> I see what you are saying, Thank you for recommendations I guess we need to
> write a new code to read the BLOB content and extract attachments.
>
> Thank you, Sai
>
>
> On Tue, Mar 20, 2012 at 7:15 PM, Ioan Eugen Stan<st...@gmail.com>wrote:
>
>> 2012/3/21 Saibabu Vallurupalli<sa...@gmail.com>:
>>> Hi Ioan,
>>>
>>> My name is Sai :-)
>>
>> Hi,
>>
>> I noticed the mistake just after sending, sorry about that.
>>
>>> Also, I am aware of the code you pointed to me any ways Thank you. I
>> wrote
>>> JPAEncryptedMessage.java :-)
>>>
>>> What I am looking for is how to extract just attachment from body content
>>> BLOB without any code modifications to James source.
>>>
>>> Please let me know if you have any ideas?
>>>
>>> Thanks, Sai.
>>
>> Well, you can't do a job and not have your hands dirty ;). I can't
>> seem to think how you could do that besides a mailet or an external
>> tool that accesses the database and processes the messages. I would go
>> with a mailet, should be pretty easy to implement mime parsing there.
>>
>>>
>>> On Tue, Mar 20, 2012 at 6:56 PM, Ioan Eugen Stan<stan.ieugen@gmail.com
>>> wrote:
>>>
>>>> 2012/3/20 Saibabu Vallurupalli<sa...@gmail.com>:
>>>>> Hi Eric,
>>>>>
>>>>> We are trying to retrieve it after storing to make it more simple.
>> During
>>>>> process might need a code change in mailets I guess.
>>>>> If it is a completed email in BLOB, is there a way to extract just
>>>>> attachment?
>>>>>
>>>>> Thanks, Sai
>>>>>
>>>>
>>>> Hello Say,
>>>>
>>>> You will have to load the email and use mime4j to process it and
>>>> extract attachments. The code that maps one message to a database
>>>> table is in JPAMessage class [1]. If you look closely, you will see
>>>> the JPA annotations for headers and body like bellow. JPAMessage class
>>>> has getBodyContent and getHeaderContent methods to get an InputStream
>>>> for each value.
>>>>
>>>> 5 /** The value for the body field. Lazy loaded */
>>>> 46 /** We use a max length to represent 1gb data. Thats prolly
>>>> overkill, but who knows */
>>>> 47 @Basic(optional = false, fetch = FetchType.LAZY)
>>>> 48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable =
>> false)
>>>> 49 @Lob private byte[] body;
>>>>
>>>> 52 /** The value for the header field. Lazy loaded */
>>>> 53 /** We use a max length to represent 1gb data. Thats prolly
>>>> overkill, but who knows */
>>>> 54 @Basic(optional = false, fetch = FetchType.LAZY)
>>>> 55 @Column(name = "HEADER_BYTES", length = 10485760, nullable =
>> false)
>>>> 56 @Lob private byte[] header;
>>>>
>>>>
>>>> [1]
>>>>
>> http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup
>>>>
>>>>> On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles<er...@apache.org>
>> wrote:
>>>>>
>>>>>> Hi Sai,
>>>>>> If you use JPA, the complete mail is stored as a blob in the
>>>> JAMES_MESSAGE
>>>>>> table (see http://james.apache.org/**server/3/images/database/**
>>>>>> james-database-schema-derby_**1000.png<
>>>>
>> http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png
>>> for
>>>> an old version of the schema).
>>>>>>
>>>>>> Are you looking to extract it when processing the mail in a mailet,
>> or
>>>>>> extract afterwards when already stored in the database? The
>>>> implementations
>>>>>> will be quite different depending on your need.
>>>>>>
>>>>>> Thx, Eric
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
>>>>>>
>>>>>>> Hi Team,
>>>>>>>
>>>>>>> At present I have a requirement to extract the email attachment and
>> put
>>>>>>> them in a separate folder for different use.
>>>>>>>
>>>>>>> What is the best way to do this? Does the attachments are stored in
>>>> MySQL
>>>>>>> database?
>>>>>>>
>>>>>>> Any inputs on this will be really helpful.
>>>>>>>
>>>>>>> Thank you,
>>>>>>> Sai
>>>>>>>
>>>>>>>
>>>>>> --
>>>>>> eric | http://about.echarles.net | @echarles
>>>>>>
>>>>>>
>>>>
>> ------------------------------**------------------------------**---------
>>>>>> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<
>>>> server-dev-unsubscribe@james.apache.org>
>>>>>> For additional commands, e-mail: server-dev-help@james.apache.**org<
>>>> server-dev-help@james.apache.org>
>>>>>>
>>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Ioan Eugen Stan
>>>> http://ieugen.blogspot.com/
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>>>> For additional commands, e-mail: server-dev-help@james.apache.org
>>>>
>>>>
>>
>>
>>
>> --
>> Ioan Eugen Stan
>> http://ieugen.blogspot.com/
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-dev-help@james.apache.org
>>
>>
>
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: EMail attachments
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
Hi Ioan,
I see what you are saying, Thank you for recommendations I guess we need to
write a new code to read the BLOB content and extract attachments.
Thank you, Sai
On Tue, Mar 20, 2012 at 7:15 PM, Ioan Eugen Stan <st...@gmail.com>wrote:
> 2012/3/21 Saibabu Vallurupalli <sa...@gmail.com>:
> > Hi Ioan,
> >
> > My name is Sai :-)
>
> Hi,
>
> I noticed the mistake just after sending, sorry about that.
>
> > Also, I am aware of the code you pointed to me any ways Thank you. I
> wrote
> > JPAEncryptedMessage.java :-)
> >
> > What I am looking for is how to extract just attachment from body content
> > BLOB without any code modifications to James source.
> >
> > Please let me know if you have any ideas?
> >
> > Thanks, Sai.
>
> Well, you can't do a job and not have your hands dirty ;). I can't
> seem to think how you could do that besides a mailet or an external
> tool that accesses the database and processes the messages. I would go
> with a mailet, should be pretty easy to implement mime parsing there.
>
> >
> > On Tue, Mar 20, 2012 at 6:56 PM, Ioan Eugen Stan <stan.ieugen@gmail.com
> >wrote:
> >
> >> 2012/3/20 Saibabu Vallurupalli <sa...@gmail.com>:
> >> > Hi Eric,
> >> >
> >> > We are trying to retrieve it after storing to make it more simple.
> During
> >> > process might need a code change in mailets I guess.
> >> > If it is a completed email in BLOB, is there a way to extract just
> >> > attachment?
> >> >
> >> > Thanks, Sai
> >> >
> >>
> >> Hello Say,
> >>
> >> You will have to load the email and use mime4j to process it and
> >> extract attachments. The code that maps one message to a database
> >> table is in JPAMessage class [1]. If you look closely, you will see
> >> the JPA annotations for headers and body like bellow. JPAMessage class
> >> has getBodyContent and getHeaderContent methods to get an InputStream
> >> for each value.
> >>
> >> 5 /** The value for the body field. Lazy loaded */
> >> 46 /** We use a max length to represent 1gb data. Thats prolly
> >> overkill, but who knows */
> >> 47 @Basic(optional = false, fetch = FetchType.LAZY)
> >> 48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable =
> false)
> >> 49 @Lob private byte[] body;
> >>
> >> 52 /** The value for the header field. Lazy loaded */
> >> 53 /** We use a max length to represent 1gb data. Thats prolly
> >> overkill, but who knows */
> >> 54 @Basic(optional = false, fetch = FetchType.LAZY)
> >> 55 @Column(name = "HEADER_BYTES", length = 10485760, nullable =
> false)
> >> 56 @Lob private byte[] header;
> >>
> >>
> >> [1]
> >>
> http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup
> >>
> >> > On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles <er...@apache.org>
> wrote:
> >> >
> >> >> Hi Sai,
> >> >> If you use JPA, the complete mail is stored as a blob in the
> >> JAMES_MESSAGE
> >> >> table (see http://james.apache.org/**server/3/images/database/**
> >> >> james-database-schema-derby_**1000.png<
> >>
> http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png
> >for
> >> an old version of the schema).
> >> >>
> >> >> Are you looking to extract it when processing the mail in a mailet,
> or
> >> >> extract afterwards when already stored in the database? The
> >> implementations
> >> >> will be quite different depending on your need.
> >> >>
> >> >> Thx, Eric
> >> >>
> >> >>
> >> >>
> >> >> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
> >> >>
> >> >>> Hi Team,
> >> >>>
> >> >>> At present I have a requirement to extract the email attachment and
> put
> >> >>> them in a separate folder for different use.
> >> >>>
> >> >>> What is the best way to do this? Does the attachments are stored in
> >> MySQL
> >> >>> database?
> >> >>>
> >> >>> Any inputs on this will be really helpful.
> >> >>>
> >> >>> Thank you,
> >> >>> Sai
> >> >>>
> >> >>>
> >> >> --
> >> >> eric | http://about.echarles.net | @echarles
> >> >>
> >> >>
> >>
> ------------------------------**------------------------------**---------
> >> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<
> >> server-dev-unsubscribe@james.apache.org>
> >> >> For additional commands, e-mail: server-dev-help@james.apache.**org<
> >> server-dev-help@james.apache.org>
> >> >>
> >> >>
> >>
> >>
> >>
> >> --
> >> Ioan Eugen Stan
> >> http://ieugen.blogspot.com/
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> >> For additional commands, e-mail: server-dev-help@james.apache.org
> >>
> >>
>
>
>
> --
> Ioan Eugen Stan
> http://ieugen.blogspot.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: EMail attachments
Posted by Ioan Eugen Stan <st...@gmail.com>.
2012/3/21 Saibabu Vallurupalli <sa...@gmail.com>:
> Hi Ioan,
>
> My name is Sai :-)
Hi,
I noticed the mistake just after sending, sorry about that.
> Also, I am aware of the code you pointed to me any ways Thank you. I wrote
> JPAEncryptedMessage.java :-)
>
> What I am looking for is how to extract just attachment from body content
> BLOB without any code modifications to James source.
>
> Please let me know if you have any ideas?
>
> Thanks, Sai.
Well, you can't do a job and not have your hands dirty ;). I can't
seem to think how you could do that besides a mailet or an external
tool that accesses the database and processes the messages. I would go
with a mailet, should be pretty easy to implement mime parsing there.
>
> On Tue, Mar 20, 2012 at 6:56 PM, Ioan Eugen Stan <st...@gmail.com>wrote:
>
>> 2012/3/20 Saibabu Vallurupalli <sa...@gmail.com>:
>> > Hi Eric,
>> >
>> > We are trying to retrieve it after storing to make it more simple. During
>> > process might need a code change in mailets I guess.
>> > If it is a completed email in BLOB, is there a way to extract just
>> > attachment?
>> >
>> > Thanks, Sai
>> >
>>
>> Hello Say,
>>
>> You will have to load the email and use mime4j to process it and
>> extract attachments. The code that maps one message to a database
>> table is in JPAMessage class [1]. If you look closely, you will see
>> the JPA annotations for headers and body like bellow. JPAMessage class
>> has getBodyContent and getHeaderContent methods to get an InputStream
>> for each value.
>>
>> 5 /** The value for the body field. Lazy loaded */
>> 46 /** We use a max length to represent 1gb data. Thats prolly
>> overkill, but who knows */
>> 47 @Basic(optional = false, fetch = FetchType.LAZY)
>> 48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable = false)
>> 49 @Lob private byte[] body;
>>
>> 52 /** The value for the header field. Lazy loaded */
>> 53 /** We use a max length to represent 1gb data. Thats prolly
>> overkill, but who knows */
>> 54 @Basic(optional = false, fetch = FetchType.LAZY)
>> 55 @Column(name = "HEADER_BYTES", length = 10485760, nullable = false)
>> 56 @Lob private byte[] header;
>>
>>
>> [1]
>> http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup
>>
>> > On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles <er...@apache.org> wrote:
>> >
>> >> Hi Sai,
>> >> If you use JPA, the complete mail is stored as a blob in the
>> JAMES_MESSAGE
>> >> table (see http://james.apache.org/**server/3/images/database/**
>> >> james-database-schema-derby_**1000.png<
>> http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png>for
>> an old version of the schema).
>> >>
>> >> Are you looking to extract it when processing the mail in a mailet, or
>> >> extract afterwards when already stored in the database? The
>> implementations
>> >> will be quite different depending on your need.
>> >>
>> >> Thx, Eric
>> >>
>> >>
>> >>
>> >> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
>> >>
>> >>> Hi Team,
>> >>>
>> >>> At present I have a requirement to extract the email attachment and put
>> >>> them in a separate folder for different use.
>> >>>
>> >>> What is the best way to do this? Does the attachments are stored in
>> MySQL
>> >>> database?
>> >>>
>> >>> Any inputs on this will be really helpful.
>> >>>
>> >>> Thank you,
>> >>> Sai
>> >>>
>> >>>
>> >> --
>> >> eric | http://about.echarles.net | @echarles
>> >>
>> >>
>> ------------------------------**------------------------------**---------
>> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<
>> server-dev-unsubscribe@james.apache.org>
>> >> For additional commands, e-mail: server-dev-help@james.apache.**org<
>> server-dev-help@james.apache.org>
>> >>
>> >>
>>
>>
>>
>> --
>> Ioan Eugen Stan
>> http://ieugen.blogspot.com/
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-dev-help@james.apache.org
>>
>>
--
Ioan Eugen Stan
http://ieugen.blogspot.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: EMail attachments
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
Hi Ioan,
My name is Sai :-)
Also, I am aware of the code you pointed to me any ways Thank you. I wrote
JPAEncryptedMessage.java :-)
What I am looking for is how to extract just attachment from body content
BLOB without any code modifications to James source.
Please let me know if you have any ideas?
Thanks, Sai.
On Tue, Mar 20, 2012 at 6:56 PM, Ioan Eugen Stan <st...@gmail.com>wrote:
> 2012/3/20 Saibabu Vallurupalli <sa...@gmail.com>:
> > Hi Eric,
> >
> > We are trying to retrieve it after storing to make it more simple. During
> > process might need a code change in mailets I guess.
> > If it is a completed email in BLOB, is there a way to extract just
> > attachment?
> >
> > Thanks, Sai
> >
>
> Hello Say,
>
> You will have to load the email and use mime4j to process it and
> extract attachments. The code that maps one message to a database
> table is in JPAMessage class [1]. If you look closely, you will see
> the JPA annotations for headers and body like bellow. JPAMessage class
> has getBodyContent and getHeaderContent methods to get an InputStream
> for each value.
>
> 5 /** The value for the body field. Lazy loaded */
> 46 /** We use a max length to represent 1gb data. Thats prolly
> overkill, but who knows */
> 47 @Basic(optional = false, fetch = FetchType.LAZY)
> 48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable = false)
> 49 @Lob private byte[] body;
>
> 52 /** The value for the header field. Lazy loaded */
> 53 /** We use a max length to represent 1gb data. Thats prolly
> overkill, but who knows */
> 54 @Basic(optional = false, fetch = FetchType.LAZY)
> 55 @Column(name = "HEADER_BYTES", length = 10485760, nullable = false)
> 56 @Lob private byte[] header;
>
>
> [1]
> http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup
>
> > On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles <er...@apache.org> wrote:
> >
> >> Hi Sai,
> >> If you use JPA, the complete mail is stored as a blob in the
> JAMES_MESSAGE
> >> table (see http://james.apache.org/**server/3/images/database/**
> >> james-database-schema-derby_**1000.png<
> http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png>for
> an old version of the schema).
> >>
> >> Are you looking to extract it when processing the mail in a mailet, or
> >> extract afterwards when already stored in the database? The
> implementations
> >> will be quite different depending on your need.
> >>
> >> Thx, Eric
> >>
> >>
> >>
> >> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
> >>
> >>> Hi Team,
> >>>
> >>> At present I have a requirement to extract the email attachment and put
> >>> them in a separate folder for different use.
> >>>
> >>> What is the best way to do this? Does the attachments are stored in
> MySQL
> >>> database?
> >>>
> >>> Any inputs on this will be really helpful.
> >>>
> >>> Thank you,
> >>> Sai
> >>>
> >>>
> >> --
> >> eric | http://about.echarles.net | @echarles
> >>
> >>
> ------------------------------**------------------------------**---------
> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<
> server-dev-unsubscribe@james.apache.org>
> >> For additional commands, e-mail: server-dev-help@james.apache.**org<
> server-dev-help@james.apache.org>
> >>
> >>
>
>
>
> --
> Ioan Eugen Stan
> http://ieugen.blogspot.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: EMail attachments
Posted by Ioan Eugen Stan <st...@gmail.com>.
2012/3/20 Saibabu Vallurupalli <sa...@gmail.com>:
> Hi Eric,
>
> We are trying to retrieve it after storing to make it more simple. During
> process might need a code change in mailets I guess.
> If it is a completed email in BLOB, is there a way to extract just
> attachment?
>
> Thanks, Sai
>
Hello Say,
You will have to load the email and use mime4j to process it and
extract attachments. The code that maps one message to a database
table is in JPAMessage class [1]. If you look closely, you will see
the JPA annotations for headers and body like bellow. JPAMessage class
has getBodyContent and getHeaderContent methods to get an InputStream
for each value.
5 /** The value for the body field. Lazy loaded */
46 /** We use a max length to represent 1gb data. Thats prolly
overkill, but who knows */
47 @Basic(optional = false, fetch = FetchType.LAZY)
48 @Column(name = "MAIL_BYTES", length = 1048576000, nullable = false)
49 @Lob private byte[] body;
52 /** The value for the header field. Lazy loaded */
53 /** We use a max length to represent 1gb data. Thats prolly
overkill, but who knows */
54 @Basic(optional = false, fetch = FetchType.LAZY)
55 @Column(name = "HEADER_BYTES", length = 10485760, nullable = false)
56 @Lob private byte[] header;
[1] http://svn.apache.org/viewvc/james/mailbox/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/openjpa/JPAMessage.java?view=markup
> On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles <er...@apache.org> wrote:
>
>> Hi Sai,
>> If you use JPA, the complete mail is stored as a blob in the JAMES_MESSAGE
>> table (see http://james.apache.org/**server/3/images/database/**
>> james-database-schema-derby_**1000.png<http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png>for an old version of the schema).
>>
>> Are you looking to extract it when processing the mail in a mailet, or
>> extract afterwards when already stored in the database? The implementations
>> will be quite different depending on your need.
>>
>> Thx, Eric
>>
>>
>>
>> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
>>
>>> Hi Team,
>>>
>>> At present I have a requirement to extract the email attachment and put
>>> them in a separate folder for different use.
>>>
>>> What is the best way to do this? Does the attachments are stored in MySQL
>>> database?
>>>
>>> Any inputs on this will be really helpful.
>>>
>>> Thank you,
>>> Sai
>>>
>>>
>> --
>> eric | http://about.echarles.net | @echarles
>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
>> For additional commands, e-mail: server-dev-help@james.apache.**org<se...@james.apache.org>
>>
>>
--
Ioan Eugen Stan
http://ieugen.blogspot.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: EMail attachments
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
Hi Eric,
We are trying to retrieve it after storing to make it more simple. During
process might need a code change in mailets I guess.
If it is a completed email in BLOB, is there a way to extract just
attachment?
Thanks, Sai
On Tue, Mar 20, 2012 at 3:23 PM, Eric Charles <er...@apache.org> wrote:
> Hi Sai,
> If you use JPA, the complete mail is stored as a blob in the JAMES_MESSAGE
> table (see http://james.apache.org/**server/3/images/database/**
> james-database-schema-derby_**1000.png<http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png>for an old version of the schema).
>
> Are you looking to extract it when processing the mail in a mailet, or
> extract afterwards when already stored in the database? The implementations
> will be quite different depending on your need.
>
> Thx, Eric
>
>
>
> On 20/03/12 20:00, Saibabu Vallurupalli wrote:
>
>> Hi Team,
>>
>> At present I have a requirement to extract the email attachment and put
>> them in a separate folder for different use.
>>
>> What is the best way to do this? Does the attachments are stored in MySQL
>> database?
>>
>> Any inputs on this will be really helpful.
>>
>> Thank you,
>> Sai
>>
>>
> --
> eric | http://about.echarles.net | @echarles
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.**apache.org<se...@james.apache.org>
> For additional commands, e-mail: server-dev-help@james.apache.**org<se...@james.apache.org>
>
>
Re: EMail attachments
Posted by Eric Charles <er...@apache.org>.
Hi Sai,
If you use JPA, the complete mail is stored as a blob in the
JAMES_MESSAGE table (see
http://james.apache.org/server/3/images/database/james-database-schema-derby_1000.png
for an old version of the schema).
Are you looking to extract it when processing the mail in a mailet, or
extract afterwards when already stored in the database? The
implementations will be quite different depending on your need.
Thx, Eric
On 20/03/12 20:00, Saibabu Vallurupalli wrote:
> Hi Team,
>
> At present I have a requirement to extract the email attachment and put
> them in a separate folder for different use.
>
> What is the best way to do this? Does the attachments are stored in MySQL
> database?
>
> Any inputs on this will be really helpful.
>
> Thank you,
> Sai
>
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org