error_message and message_state

[Matt Wiseley <ma...@openspoke.com>]

Can someone explain how the "error_message" and "message_state" table columns are used in JDBC message stores? Would these columns ever have any data of interest to a client application reading the inbox table? I can't seem to get them to have any values other than NULL and "root", respectively.

Thanks,
Matt

Re: error_message and message_state

[Serge Knystautas <se...@lokitech.com>]

Matt Wiseley wrote:
> Can someone explain how the "error_message" and "message_state" table columns are used in JDBC message stores? Would these columns ever have any data of interest to a client application reading the inbox table? I can't seem to get them to have any values other than NULL and "root", respectively.

They could have useful information, but depends on how your James file 
is configured.

error_message is Mail.getErrorMessage()
message_state is Mail.getState()

Mail.getState() translates to what spooler the message is in, be it root 
(the default) or error or spam or outgoing or whatever.  The error 
message is just text that can be stored on a Mail object and in the 
Mailet v3 spec will get enhanced to support generic attributes.

-- 
Serge Knystautas
President
Lokitech >> software . strategy . design >> http://www.lokitech.com/
p. 1.301.656.5501
e. sergek@lokitech.com



---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org

RE: error_message and message_state

["Noel J. Bergman" <no...@devtech.com>]

The message state contains the name of the current processor that is/will be
processing the message.  The error_message is used in the event of an error.

I would not recommend considering anything in the database schema to be
guaranteed across major versions of James, other than in terms of migration.
We already have plans that will change the schema, e.g., mail attributes,
and error_message is one of the likely things to change.

	--- Noel

-----Original Message-----
From: Matt Wiseley [mailto:matt@openspoke.com]
Sent: Sunday, March 02, 2003 11:08
To: James Users List
Subject: error_message and message_state


Can someone explain how the "error_message" and "message_state" table
columns are used in JDBC message stores? Would these columns ever have any
data of interest to a client application reading the inbox table? I can't
seem to get them to have any values other than NULL and "root",
respectively.

Thanks,
Matt


---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org