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:[EMAIL PROTECTED] > Sent: martedì 6 maggio 2003 21.46 > To: James Developers List; [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]