Hi Saibabu, I understand now. I can see the columns James_Mail.Mail_Bytes and James_Mail.Header_Bytes. The value in these columns is given in something like [BLOB - 76B] But I was expecting the value to such columns to be exact textual value (like header value or body of email message). So, is the body and header values getting stored in just [BLOB-...] values?
regards, *Seyoum T*. On Fri, Feb 22, 2013 at 1:37 PM, Saibabu Vallurupalli < saibabu.vallurupa...@gmail.com> wrote: > Hi Seyoum, > > What Eric means is Message is of type Blob and you can find this in table > JAMES_MAIL column MAIL_BYTES and MAIL_HEADER will have all email header > content. > > Hope this helps. > > Thanks, > Sai > > > On Fri, Feb 22, 2013 at 3:32 AM, seyoum tesfay <syumtes...@gmail.com> > wrote: > > > Hi Eric, > > > > Thank you for your reply but there is no MESSAGE.BLOB column in the > tables > > created by James server 3.0-beta4. There is no table called Message in > the > > tables. > > > > regards, > > > > > > *Seyoum T*. > > > > > > > > On Thu, Feb 21, 2013 at 3:26 PM, Eric Charles <e...@apache.org> wrote: > > > > > Hi, > > > Look at MESSAGE.BLOB for the body of the mail. > > > Thx, Eric > > > > > > > > > On 21/02/2013 05:53, seyoum tesfay wrote: > > > > > >> Hello, > > >> > > >> I am using James server 3.0-beta4 with MySql database as the mail and > > user > > >> repository. James users different table to store the mail and user > > >> information in the database such as james_user, james_domain, > > james_mail, > > >> james_mailbox, james_mail_property, etc. > > >> > > >> So, my question is where exactly is the actual mail message getting > > >> stored? > > >> the james_mail table stores metadata about the mail. But I couldn't > find > > >> where and how the user mails are getting stored. > > >> > > >> regards, > > >> > > >> *Seyoum T*. > > >> > > >> > > > > ------------------------------**------------------------------**--------- > > > To unsubscribe, e-mail: server-user-unsubscribe@james.**apache.org< > > server-user-unsubscr...@james.apache.org> > > > For additional commands, e-mail: server-user-help@james.apache.**org< > > server-user-h...@james.apache.org> > > > > > > > > >