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<stan.ieu...@gmail.com>wrote:
2012/3/21 Saibabu Vallurupalli<saibabu.vallurupa...@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.ieu...@gmail.com
wrote:
2012/3/20 Saibabu Vallurupalli<saibabu.vallurupa...@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<e...@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-unsubscr...@james.apache.org>
For additional commands, e-mail: server-dev-help@james.apache.**org<
server-dev-h...@james.apache.org>
--
Ioan Eugen Stan
http://ieugen.blogspot.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
--
Ioan Eugen Stan
http://ieugen.blogspot.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
