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 Soeren Hilmer <so...@tietoenator.com> on 2003/06/24 09:27:34 UTC
Re: Attributes on Mail
I am pretty much finished, only needs to do a few more tests, I am hoping to
submit a patch tomorrow or at thursday latest.
If you wish to see what I have now, I can send you the current patch.
--Søren
On Monday 23 June 2003 22:17, Vincenzo Gianferrari Pini wrote:
> Søren,
>
> I started looking a little bit to this feature, and we could share our
> efforts. How far have you got into this?
>
> Vincenzo
>
> > -----Original Message-----
> > From: Noel J. Bergman [mailto:noel@devtech.com]
> > Sent: martedì 6 maggio 2003 21.46
> > To: James Developers List; soren.hilmer@tietoenator.com
> > Subject: Attributes on Mail
> >
> >
> > Søren,
> >
> > > > > I didn't realize that JDBCMailRepository wouldn't
> > > > > use standard serialization for storing the Mail in
> > > > > the DB.
> > > >
> > > > I was considering serializing the attributes hashtable
> > > > into an "Attributes" BLOB field.
> > >
> > > The big problem here is that a datamigration tool is
> > > necessary, there is, as far as I can tell, no clever
> > > shortcut like for the file repository.
> >
> > Are you working on a patch?
> >
> > Seems to me that the changes are:
> >
> > - change sqlResources.xml to accomodate the extra
> > field:
> > - change create
> > - add updateMessageAttributesSQL
> > - add retrieveMessageAttributesSQL
> > - change JDBCMailRepository to store the BLOB if the
> > the updateMessageAttributesSQL is present *AND*
> > there are attributes
> > - change JDBCMailRepository to retrieve the BLOB if
> > the retrieveMessageAttributesSQL is present
> > - comment out updateMessageAttributesSQL and
> > retrieveMessageAttributesSQL by default in
> > sqlResources.xml
> >
> > In JDBCMailRepository, log and discard the SQLException of the
> > table hasn't
> > be updated to allow the operation.
> >
> > --- Noel
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: james-dev-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org
--
Søren Hilmer, M.Sc.
R&D manager Phone: +45 70 27 64 00
TietoEnator IT+ A/S Fax: +45 70 27 64 40
Ved Lunden 12 Direct: +45 87 46 64 57
DK-8230 Åbyhøj Email: soren.hilmer@tietoenator.com
---------------------------------------------------------------------
To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org
RE: Attributes on Mail
Posted by Vincenzo Gianferrari Pini <vi...@praxis.it>.
If you are already testing, it's better that you finish it :-). But, if you wish, as I went through it (eyes only, no coding), if you send your current patch I may help looking for possible oversights.
Vincenzo
> -----Original Message-----
> From: Soeren Hilmer [mailto:soren.hilmer@tietoenator.com]
> Sent: martedì 24 giugno 2003 9.28
> To: James Developers List
> Subject: Re: Attributes on Mail
>
>
> I am pretty much finished, only needs to do a few more tests, I
> am hoping to
> submit a patch tomorrow or at thursday latest.
>
> If you wish to see what I have now, I can send you the current patch.
>
> --Søren
>
> On Monday 23 June 2003 22:17, Vincenzo Gianferrari Pini wrote:
> > Søren,
> >
> > I started looking a little bit to this feature, and we could share our
> > efforts. How far have you got into this?
> >
> > Vincenzo
> >
> > > -----Original Message-----
> > > From: Noel J. Bergman [mailto:noel@devtech.com]
> > > Sent: martedì 6 maggio 2003 21.46
> > > To: James Developers List; soren.hilmer@tietoenator.com
> > > Subject: Attributes on Mail
> > >
> > >
> > > Søren,
> > >
> > > > > > I didn't realize that JDBCMailRepository wouldn't
> > > > > > use standard serialization for storing the Mail in
> > > > > > the DB.
> > > > >
> > > > > I was considering serializing the attributes hashtable
> > > > > into an "Attributes" BLOB field.
> > > >
> > > > The big problem here is that a datamigration tool is
> > > > necessary, there is, as far as I can tell, no clever
> > > > shortcut like for the file repository.
> > >
> > > Are you working on a patch?
> > >
> > > Seems to me that the changes are:
> > >
> > > - change sqlResources.xml to accomodate the extra
> > > field:
> > > - change create
> > > - add updateMessageAttributesSQL
> > > - add retrieveMessageAttributesSQL
> > > - change JDBCMailRepository to store the BLOB if the
> > > the updateMessageAttributesSQL is present *AND*
> > > there are attributes
> > > - change JDBCMailRepository to retrieve the BLOB if
> > > the retrieveMessageAttributesSQL is present
> > > - comment out updateMessageAttributesSQL and
> > > retrieveMessageAttributesSQL by default in
> > > sqlResources.xml
> > >
> > > In JDBCMailRepository, log and discard the SQLException of the
> > > table hasn't
> > > be updated to allow the operation.
> > >
> > > --- Noel
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: james-dev-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: james-dev-help@jakarta.apache.org
>
> --
> Søren Hilmer, M.Sc.
> R&D manager Phone: +45 70 27 64 00
> TietoEnator IT+ A/S Fax: +45 70 27 64 40
> Ved Lunden 12 Direct: +45 87 46 64 57
> DK-8230 Åbyhøj Email: soren.hilmer@tietoenator.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org