SMTP transport with e-mail address in DataBase

[bokc bokc]

Hi,

I would like to send e-mail trow smtp transport. But the e-mail address is in data base and it depend of data in the payload. Is it possible to take data in the DataBase with the mule ant put it in the e-mail address of the smtp transport ?
If not I can put it on the object in the payload. But how can I extract it for the smtp transport?

Youkoun

[Henry CL Tiong]

First thing first, is the value of the email address static or it will be changed accordingly (if so, how frequent)?

bokc bokc wrote:

Hi,

I would like to send e-mail trow smtp transport. But the e-mail address is
in data base and it depend of data in the payload. Is it possible to take
data in the DataBase with the mule ant put it in the e-mail address of the
smtp transport ?
If not I can put it on the object in the payload. But how can I extract it
for the smtp transport?

Youkoun

[bokc bokc]

Hi,

The e-mail address can change in the data base but the frequency is unknown. I think the easiest way is to put the e-mail in the payload object. But after I don't know how to take and use it in the the smtp transport.

Youkoun

2008/7/1 coo|dude <henry.tiong@...>:

First thing first, is the value of the email address static or it will be
changed accordingly (if so, how frequent)?

bokc bokc wrote:
>
> Hi,
>
> I would like to send e-mail trow smtp transport. But the e-mail address is
> in data base and it depend of data in the payload. Is it possible to take
> data in the DataBase with the mule ant put it in the e-mail address of the
> smtp transport ?
> If not I can put it on the object in the payload. But how can I extract it
> for the smtp transport?
>
> Youkoun
>
>

--
View this message in context: http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[Henry CL Tiong]

hhmm..

1. You may need to write a custom filtering to grab the email address at the router, or
2. Use JDBC connector to query the database directly to grab the email address and echo is back to another Mule descriptor, or
3. Ever thinking of putting the email address onto the Mule's environment properties file and grab the value there?

cheers,

bokc bokc wrote:

Hi,

The e-mail address can change in the data base but the frequency is unknown.
I think the easiest way is to put the e-mail in the payload object. But
after I don't know how to take and use it in the the smtp transport.

Youkoun

2008/7/1 coo|dude <[e-mail]>:

>
> First thing first, is the value of the email address static or it will be
> changed accordingly (if so, how frequent)?
>
>
> bokc bokc wrote:
> >
> > Hi,
> >
> > I would like to send e-mail trow smtp transport. But the e-mail address
> is
> > in data base and it depend of data in the payload. Is it possible to take
> > data in the DataBase with the mule ant put it in the e-mail address of
> the
> > smtp transport ?
> > If not I can put it on the object in the payload. But how can I extract
> it
> > for the smtp transport?
> >
> > Youkoun
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
> Sent from the Mule - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>

[bokc bokc]

The 2nd solution look like the best but I don't see how to do this?
For The JDBC connector, I know how to do this but how can I use data in payload object in the SQL query?

Youkoun

2008/7/1 coo|dude <henry.tiong@...>:

hhmm..

1. You may need to write a custom filtering to grab the email address at the
router, or
2. Use JDBC connector to query the database directly to grab the email
address and echo is back to another Mule descriptor, or
3. Ever thinking of putting the email address onto the Mule's environment
properties file and grab the value there?

cheers,

bokc bokc wrote:
>
> Hi,
>
> The e-mail address can change in the data base but the frequency is
> unknown.
> I think the easiest way is to put the e-mail in the payload object. But
> after I don't know how to take and use it in the the smtp transport.
>
> Youkoun
>
> 2008/7/1 coo|dude <henry.tiong@...>:
>
>>
>> First thing first, is the value of the email address static or it will be
>> changed accordingly (if so, how frequent)?
>>
>>
>> bokc bokc wrote:
>> >
>> > Hi,
>> >
>> > I would like to send e-mail trow smtp transport. But the e-mail address
>> is
>> > in data base and it depend of data in the payload. Is it possible to
>> take
>> > data in the DataBase with the mule ant put it in the e-mail address of
>> the
>> > smtp transport ?
>> > If not I can put it on the object in the payload. But how can I extract
>> it
>> > for the smtp transport?
>> >
>> > Youkoun
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
>> Sent from the Mule - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--

View this message in context: http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[Henry CL Tiong]

hhmm.. are you using Mule 1.x or Mule 2.x? In 1.x, you can actually create a normal Java class with getter and setter and this getter and setter can be used as part of the properties attributes of the router.

As for Mule 2.x, I am not so sure, but I think can you refer to this documentation: http://mulesource.org/display/MULE2USER/Using+Expression+Evaluator The BEAN name and expression might help in your case.

bokc bokc wrote:

The 2nd solution look like the best but I don't see how to do this?
For The JDBC connector, I know how to do this but how can I use data in
payload object in the SQL query?

Youkoun

2008/7/1 coo|dude <[e-mail]>:

>
> hhmm..
>
> 1. You may need to write a custom filtering to grab the email address at
> the
> router, or
> 2. Use JDBC connector to query the database directly to grab the email
> address and echo is back to another Mule descriptor, or
> 3. Ever thinking of putting the email address onto the Mule's environment
> properties file and grab the value there?
>
> cheers,
>
> bokc bokc wrote:
> >
> > Hi,
> >
> > The e-mail address can change in the data base but the frequency is
> > unknown.
> > I think the easiest way is to put the e-mail in the payload object. But
> > after I don't know how to take and use it in the the smtp transport.
> >
> > Youkoun
> >
> > 2008/7/1 coo|dude <[e-mail]>:
> >
> >>
> >> First thing first, is the value of the email address static or it will
> be
> >> changed accordingly (if so, how frequent)?
> >>
> >>
> >> bokc bokc wrote:
> >> >
> >> > Hi,
> >> >
> >> > I would like to send e-mail trow smtp transport. But the e-mail
> address
> >> is
> >> > in data base and it depend of data in the payload. Is it possible to
> >> take
> >> > data in the DataBase with the mule ant put it in the e-mail address of
> >> the
> >> > smtp transport ?
> >> > If not I can put it on the object in the payload. But how can I
> extract
> >> it
> >> > for the smtp transport?
> >> >
> >> > Youkoun
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe from this list, please visit:
> >>
> >>    http://xircles.codehaus.org/manage_email
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
> Sent from the Mule - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>

[bokc bokc]

Hi,

I'm using Mule 2. Do you have an example, even if it was for Mule1 ?

Youkoun

2008/7/2 coo|dude <cooldude_no1@...>:

hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about Mule 2.x,
but in 1.x, you can actually create a normal Java class with getter and
setter and this getter and setter can be used as part of the properties
attributes of the router.

bokc bokc wrote:
>
> The 2nd solution look like the best but I don't see how to do this?
> For The JDBC connector, I know how to do this but how can I use data in
> payload object in the SQL query?
>
> Youkoun
>
> 2008/7/1 coo|dude <henry.tiong@...>:
>
>>
>> hhmm..
>>
>> 1. You may need to write a custom filtering to grab the email address at
>> the
>> router, or
>> 2. Use JDBC connector to query the database directly to grab the email
>> address and echo is back to another Mule descriptor, or
>> 3. Ever thinking of putting the email address onto the Mule's environment
>> properties file and grab the value there?
>>
>> cheers,
>>
>> bokc bokc wrote:
>> >
>> > Hi,
>> >
>> > The e-mail address can change in the data base but the frequency is
>> > unknown.
>> > I think the easiest way is to put the e-mail in the payload object. But
>> > after I don't know how to take and use it in the the smtp transport.
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> First thing first, is the value of the email address static or it will
>> be
>> >> changed accordingly (if so, how frequent)?
>> >>
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > I would like to send e-mail trow smtp transport. But the e-mail
>> address
>> >> is
>> >> > in data base and it depend of data in the payload. Is it possible to
>> >> take
>> >> > data in the DataBase with the mule ant put it in the e-mail address
>> of
>> >> the
>> >> > smtp transport ?
>> >> > If not I can put it on the object in the payload. But how can I
>> extract
>> >> it
>> >> > for the smtp transport?
>> >> >
>> >> > Youkoun
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
>> Sent from the Mule - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context: http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18230823.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[Henry CL Tiong]

I will not write the entire thing here, I think the below will be sufficient for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(), uri);
                Object emailAdd = response.getPayload();

Map map = new HashMap();
                map.put("email", emailAdd);
client.send("vm://in", "foobar", map);

then in your Mule config file, you can use ${email} for your other connector

bokc bokc wrote:

Hi,

I'm using Mule 2. Do you have an example, even if it was for Mule1 ?

Youkoun

2008/7/2 coo|dude <[e-mail]>:

>
> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about Mule 2.x,
> but in 1.x, you can actually create a normal Java class with getter and
> setter and this getter and setter can be used as part of the properties
> attributes of the router.
>
>
>
> bokc bokc wrote:
> >
> > The 2nd solution look like the best but I don't see how to do this?
> > For The JDBC connector, I know how to do this but how can I use data in
> > payload object in the SQL query?
> >
> > Youkoun
> >
> > 2008/7/1 coo|dude <[e-mail]>:
> >
> >>
> >> hhmm..
> >>
> >> 1. You may need to write a custom filtering to grab the email address at
> >> the
> >> router, or
> >> 2. Use JDBC connector to query the database directly to grab the email
> >> address and echo is back to another Mule descriptor, or
> >> 3. Ever thinking of putting the email address onto the Mule's
> environment
> >> properties file and grab the value there?
> >>
> >> cheers,
> >>
> >> bokc bokc wrote:
> >> >
> >> > Hi,
> >> >
> >> > The e-mail address can change in the data base but the frequency is
> >> > unknown.
> >> > I think the easiest way is to put the e-mail in the payload object.
> But
> >> > after I don't know how to take and use it in the the smtp transport.
> >> >
> >> > Youkoun
> >> >
> >> > 2008/7/1 coo|dude <[e-mail]>:
> >> >
> >> >>
> >> >> First thing first, is the value of the email address static or it
> will
> >> be
> >> >> changed accordingly (if so, how frequent)?
> >> >>
> >> >>
> >> >> bokc bokc wrote:
> >> >> >
> >> >> > Hi,
> >> >> >
> >> >> > I would like to send e-mail trow smtp transport. But the e-mail
> >> address
> >> >> is
> >> >> > in data base and it depend of data in the payload. Is it possible
> to
> >> >> take
> >> >> > data in the DataBase with the mule ant put it in the e-mail address
> >> of
> >> >> the
> >> >> > smtp transport ?
> >> >> > If not I can put it on the object in the payload. But how can I
> >> extract
> >> >> it
> >> >> > for the smtp transport?
> >> >> >
> >> >> > Youkoun
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe from this list, please visit:
> >> >>
> >> >>    http://xircles.codehaus.org/manage_email
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe from this list, please visit:
> >>
> >>    http://xircles.codehaus.org/manage_email
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18230823.html
> Sent from the Mule - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>

[bokc bokc]

Hi

I understand your example but I try to juste put the ${email} in the mule configuration. But when I run mule (juste mule/no message for the moment) I have an error :
Exception stack is:
1. Invalid bean definition with name 'smtp' defined in null: Could not resolve placeholder 'email' (org.springframework.beans.factory.BeanDefinitionStoreException)
  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer:268 (null)
2. Invalid bean definition with name 'smtp' defined in null: Could not resolve placeholder 'email' (org.springframework.beans.factory.BeanDefinitionStoreException) (org.mule.api.config.ConfigurationException)
  org.mule.config.builders.AbstractConfigurationBuilder:44 (http://mule.mulesource.org/docs/apidocs/org/mule/api/config/ConfigurationException.html)

My service configuration is :
         <service name="Smtp">
            <inbound>
                <vm:inbound-endpoint path="smtp" />
            </inbound>
            <outbound>
                <outbound-pass-through-router>
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." to="${email}" transformer-refs="SessionToHtml"/>
                </outbound-pass-through-router>
            </outbound>
        </service>

Did I have to declar it befort ?

youkoun

2008/7/3 coo|dude <cooldude_no1@...>:

I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector

bokc bokc wrote:
>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about Mule
>> 2.x,
>> but in 1.x, you can actually create a normal Java class with getter and
>> setter and this getter and setter can be used as part of the properties
>> attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use data in
>> > payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the email
>> >> address and echo is back to another Mule descriptor, or
>> >> 3. Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency is
>> >> > unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18230823.html
>> Sent from the Mule - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context: http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[antoine.borg]

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
                Object emailAdd = response.getPayload();

Map map = new HashMap();
                map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153
616p18250848.html
Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Henry CL Tiong]

Most likely 'email' properties and value weren't loaded and that's why it couldn't be found. Can you attach your mule config file here?

cheers,

bokc bokc wrote:

Hi

I understand your example but I try to juste put the ${email} in the mule
configuration. But when I run mule (juste mule/no message for the moment) I
have an error :
Exception stack is:
1. Invalid bean definition with name 'smtp' defined in null: Could not
resolve placeholder 'email'
(org.springframework.beans.factory.BeanDefinitionStoreException)
  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer:268
(null)
2. Invalid bean definition with name 'smtp' defined in null: Could not
resolve placeholder 'email'
(org.springframework.beans.factory.BeanDefinitionStoreException)
(org.mule.api.config.ConfigurationException)
  org.mule.config.builders.AbstractConfigurationBuilder:44 (
http://mule.mulesource.org/docs/apidocs/org/mule/api/config/ConfigurationException.html
)

My service configuration is :
         <service name="Smtp">
            <inbound>
                <vm:inbound-endpoint path="smtp" />
            </inbound>
            <outbound>
                <outbound-pass-through-router>
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr"
subject="Mule test" from="[e-mail]" to="${email}"
transformer-refs="SessionToHtml"/>
                </outbound-pass-through-router>
            </outbound>
        </service>

Did I have to declar it befort ?

youkoun

2008/7/3 coo|dude <[e-mail]>:

>
> I will not write the entire thing here, I think the below will be
> sufficient
> for you. :)
>
> You can do something like that in your class file:
>
> UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
> uri);
>                Object emailAdd = response.getPayload();
>
> Map map = new HashMap();
>                map.put("email", emailAdd);
> client.send("vm://in", "foolie", map);
>
> then in your Mule config file, you can use ${email} for your other
> connector
>
>
> bokc bokc wrote:
> >
> > Hi,
> >
> > I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
> >
> > Youkoun
> >
> > 2008/7/2 coo|dude <[e-mail]>:
> >
> >>
> >> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about Mule
> >> 2.x,
> >> but in 1.x, you can actually create a normal Java class with getter and
> >> setter and this getter and setter can be used as part of the properties
> >> attributes of the router.
> >>
> >>
> >>
> >> bokc bokc wrote:
> >> >
> >> > The 2nd solution look like the best but I don't see how to do this?
> >> > For The JDBC connector, I know how to do this but how can I use data
> in
> >> > payload object in the SQL query?
> >> >
> >> > Youkoun
> >> >
> >> > 2008/7/1 coo|dude <[e-mail]>:
> >> >
> >> >>
> >> >> hhmm..
> >> >>
> >> >> 1. You may need to write a custom filtering to grab the email address
> >> at
> >> >> the
> >> >> router, or
> >> >> 2. Use JDBC connector to query the database directly to grab the
> email
> >> >> address and echo is back to another Mule descriptor, or
> >> >> 3. Ever thinking of putting the email address onto the Mule's
> >> environment
> >> >> properties file and grab the value there?
> >> >>
> >> >> cheers,
> >> >>
> >> >> bokc bokc wrote:
> >> >> >
> >> >> > Hi,
> >> >> >
> >> >> > The e-mail address can change in the data base but the frequency is
> >> >> > unknown.
> >> >> > I think the easiest way is to put the e-mail in the payload object.
> >> But
> >> >> > after I don't know how to take and use it in the the smtp
> transport.
> >> >> >
> >> >> > Youkoun
> >> >> >
> >> >> > 2008/7/1 coo|dude <[e-mail]>:
> >> >> >
> >> >> >>
> >> >> >> First thing first, is the value of the email address static or it
> >> will
> >> >> be
> >> >> >> changed accordingly (if so, how frequent)?
> >> >> >>
> >> >> >>
> >> >> >> bokc bokc wrote:
> >> >> >> >
> >> >> >> > Hi,
> >> >> >> >
> >> >> >> > I would like to send e-mail trow smtp transport. But the e-mail
> >> >> address
> >> >> >> is
> >> >> >> > in data base and it depend of data in the payload. Is it
> possible
> >> to
> >> >> >> take
> >> >> >> > data in the DataBase with the mule ant put it in the e-mail
> >> address
> >> >> of
> >> >> >> the
> >> >> >> > smtp transport ?
> >> >> >> > If not I can put it on the object in the payload. But how can I
> >> >> extract
> >> >> >> it
> >> >> >> > for the smtp transport?
> >> >> >> >
> >> >> >> > Youkoun
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
> >> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe from this list, please visit:
> >> >> >>
> >> >> >>    http://xircles.codehaus.org/manage_email
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe from this list, please visit:
> >> >>
> >> >>    http://xircles.codehaus.org/manage_email
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18230823.html
> >> Sent from the Mule - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe from this list, please visit:
> >>
> >>    http://xircles.codehaus.org/manage_email
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18250848.html
> Sent from the Mule - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>

[bokc bokc]

Here it is,

youkoun

2008/7/3 coo|dude <cooldude_no1@...>:

Most likely 'email' properties and value weren't loaded and that's why it
couldn't be found. Can you attach your mule config file here?

cheers,


bokc bokc wrote:
>
> Hi
>
> I understand your example but I try to juste put the ${email} in the mule
> configuration. But when I run mule (juste mule/no message for the moment)
> I
> have an error :
> Exception stack is:
> 1. Invalid bean definition with name 'smtp' defined in null: Could not
> resolve placeholder 'email'
> (org.springframework.beans.factory.BeanDefinitionStoreException)
>
> org.springframework.beans.factory.config.PropertyPlaceholderConfigurer:268
> (null)
> 2. Invalid bean definition with name 'smtp' defined in null: Could not
> resolve placeholder 'email'
> (org.springframework.beans.factory.BeanDefinitionStoreException)
> (org.mule.api.config.ConfigurationException)
>   org.mule.config.builders.AbstractConfigurationBuilder:44 (
> http://mule.mulesource.org/docs/apidocs/org/mule/api/config/ConfigurationException.html
> )
>
> My service configuration is :
>          <service name="Smtp">
>             <inbound>
>                 <vm:inbound-endpoint path="smtp" />
>             </inbound>
>             <outbound>
>                 <outbound-pass-through-router>
>                     <smtp:outbound-endpoint
> address="smtp://smtp.orange.fr"
> subject="Mule test" from="test@..." to="${email}"
> transformer-refs="SessionToHtml"/>
>                 </outbound-pass-through-router>
>             </outbound>
>         </service>
>
> Did I have to declar it befort ?
>
> youkoun
>
> 2008/7/3 coo|dude <cooldude_no1@...>:
>
>>
>> I will not write the entire thing here, I think the below will be
>> sufficient
>> for you. :)
>>
>> You can do something like that in your class file:
>>
>> UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
>> uri);
>>                Object emailAdd = response.getPayload();
>>
>> Map map = new HashMap();
>>                map.put("email", emailAdd);
>> client.send("vm://in", "foolie", map);
>>
>> then in your Mule config file, you can use ${email} for your other
>> connector
>>
>>
>> bokc bokc wrote:
>> >
>> > Hi,
>> >
>> > I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>> >
>> > Youkoun
>> >
>> > 2008/7/2 coo|dude <cooldude_no1@...>:
>> >
>> >>
>> >> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about Mule
>> >> 2.x,
>> >> but in 1.x, you can actually create a normal Java class with getter
>> and
>> >> setter and this getter and setter can be used as part of the
>> properties
>> >> attributes of the router.
>> >>
>> >>
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > The 2nd solution look like the best but I don't see how to do this?
>> >> > For The JDBC connector, I know how to do this but how can I use data
>> in
>> >> > payload object in the SQL query?
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> hhmm..
>> >> >>
>> >> >> 1. You may need to write a custom filtering to grab the email
>> address
>> >> at
>> >> >> the
>> >> >> router, or
>> >> >> 2. Use JDBC connector to query the database directly to grab the
>> email
>> >> >> address and echo is back to another Mule descriptor, or
>> >> >> 3. Ever thinking of putting the email address onto the Mule's
>> >> environment
>> >> >> properties file and grab the value there?
>> >> >>
>> >> >> cheers,
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > The e-mail address can change in the data base but the frequency
>> is
>> >> >> > unknown.
>> >> >> > I think the easiest way is to put the e-mail in the payload
>> object.
>> >> But
>> >> >> > after I don't know how to take and use it in the the smtp
>> transport.
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >> >
>> >> >> >>
>> >> >> >> First thing first, is the value of the email address static or
>> it
>> >> will
>> >> >> be
>> >> >> >> changed accordingly (if so, how frequent)?
>> >> >> >>
>> >> >> >>
>> >> >> >> bokc bokc wrote:
>> >> >> >> >
>> >> >> >> > Hi,
>> >> >> >> >
>> >> >> >> > I would like to send e-mail trow smtp transport. But the
>> e-mail
>> >> >> address
>> >> >> >> is
>> >> >> >> > in data base and it depend of data in the payload. Is it
>> possible
>> >> to
>> >> >> >> take
>> >> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> >> address
>> >> >> of
>> >> >> >> the
>> >> >> >> > smtp transport ?
>> >> >> >> > If not I can put it on the object in the payload. But how can
>> I
>> >> >> extract
>> >> >> >> it
>> >> >> >> > for the smtp transport?
>> >> >> >> >
>> >> >> >> > Youkoun
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18211553.html
>> >> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe from this list, please visit:
>> >> >> >>
>> >> >> >>    http://xircles.codehaus.org/manage_email
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18212282.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18230823.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18250848.html
>> Sent from the Mule - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context: http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153616p18255815.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesource.org/schema/mule/core/2.0"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:beans="http://www.springframework.org/schema/beans"
       xmlns:stdio="http://www.mulesource.org/schema/mule/stdio/2.0"
       xmlns:vm="http://www.mulesource.org/schema/mule/vm/2.0"
       xmlns:smtp="http://www.mulesource.org/schema/mule/smtp/2.0"
       xmlns:jdbc="http://www.mulesource.org/schema/mule/jdbc/2.0"
       xmlns:ognl="http://www.mulesource.org/schema/mule/ognl/2.0"
    xsi:schemaLocation="
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
       http://www.mulesource.org/schema/mule/core/2.0 http://www.mulesource.org/schema/mule/core/2.0/mule.xsd
       http://www.mulesource.org/schema/mule/stdio/2.0 http://www.mulesource.org/schema/mule/stdio/2.0/mule-stdio.xsd
       http://www.mulesource.org/schema/mule/vm/2.0 http://www.mulesource.org/schema/mule/vm/2.0/mule-vm.xsd
       http://www.mulesource.org/schema/mule/smtp/2.0 http://www.mulesource.org/schema/mule/smtp/2.0/mule-smtp.xsd
       http://www.mulesource.org/schema/mule/jdbc/2.0 http://www.mulesource.org/schema/mule/jdbc/2.0/mule-jdbc.xsd
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
       http://www.mulesource.org/schema/mule/ognl/2.0 http://www.mulesource.org/schema/mule/ognl/2.0/mule-ognl.xsd">

<!--
    Document   : config.xml
    Created on : 20 juin 2008, 16:38
    Author     : OlivierKUNTZ
    Description:
        Mule configuration
-->
    <description>Mule configuration for Forms2 Ash</description>
    <context:property-placeholder location="db.properties"/>
    <!-- ***** connector ***** -->
    <beans:beans>
        <beans:bean name="serviceorder-datasource" class="org.enhydra.jdbc.standard.StandardDataSource">
            <beans:property name="driverName" value="${database.driver}"/>
            <beans:property name="url" value="${database.url}"/>
            <beans:property name="user" value="${database.user}"/>
            <beans:property name="password" value="${database.password}"/>
        </beans:bean>
    </beans:beans>
    <jdbc:connector name="jdbcConnector" dataSource-ref="serviceorder-datasource" pollingFrequency="5000">
        <jdbc:query key="get.needProcess" value="select Min(fih.ID) id from dbo.FormInstanceHistoric fih where fih.Status = ${status.needProcess} and fih.ID_FormInstance in (select fi.ID from dbo.FormInstanceHistoric fih, dbo.FormInstance fi where fih.ID_FormInstance=fi.ID and fih.Status!=${status.inProcess}) group by fih.ID_FormInstance"/>
        <!--jdbc:query key="set.InProcess" value="UPDATE dbo.FormInstanceHistoric SET status = ${status.inProcess} WHERE id = ${payload}"/-->
    </jdbc:connector>
    <custom-transformer name="SessionToHtml" class="fr.kayentis.forms.mule.transformer.SessionToHtml" />

   
    <!-- ***** service ***** -->
    <model>
        <default-service-exception-strategy>
            <vm:outbound-endpoint path="serviceException" />
        </default-service-exception-strategy>
        <service name="StartingProcess">
            <inbound>
                <jdbc:inbound-endpoint queryKey="get.needProcess" />
                <wire-tap-router>
                    <vm:outbound-endpoint path="output" />
                </wire-tap-router>
            </inbound>
            <component class="fr.kayentis.forms.mule.component.ComponentID2Session" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="startProcess" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="UserProcess">
            <inbound>
                <vm:inbound-endpoint path="startProcess" />
            </inbound>
            <component class="com.kayentis.forms.affectation.Affectation" />
            <outbound>
                <filtering-router>
                    <vm:outbound-endpoint path="userProcess" >
                        <ognl:filter>
                            <ognl:expression>payload.getErrors().getSize()==0</ognl:expression>
                        </ognl:filter>
                    </vm:outbound-endpoint>
                </filtering-router>
                <filtering-router>
                    <vm:outbound-endpoint path="errorProcess" >
                        <ognl:filter>
                            <ognl:expression>payload.getErrors().getSize()>0</ognl:expression>
                        </ognl:filter>
                    </vm:outbound-endpoint>
                </filtering-router>
            </outbound>
        </service>
        <service name="XFDFProcess">
            <inbound>
                <vm:inbound-endpoint path="userProcess" />
            </inbound>
            <component class="com.kayentis.forms.traitement.xfdf.TraitementXfdf" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="xfdfProcess" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="ImageProcess">
            <inbound>
                <vm:inbound-endpoint path="xfdfProcess" />
            </inbound>
            <component class="com.kayentis.forms.image.Image" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="imageProcess" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="PenSessionProcess">
            <inbound>
                <vm:inbound-endpoint path="imageProcess" />
            </inbound>
            <component class="com.kayentis.forms.traitement.penSession.TraitementPenSession" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="penSessionProcess" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="HwrProcess">
            <inbound>
                <vm:inbound-endpoint path="penSessionProcess" synchronous="true" />
            </inbound>
            <component class="com.kayentis.forms.hwr.Hwr" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="hwrProcess" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="EndProcess">
            <inbound>
                <vm:inbound-endpoint path="hwrProcess" />
            </inbound>
            <component class="com.kayentis.forms.endProcess.EndProcess" />
        </service>
        <service name="Output">
            <inbound>
                <vm:inbound-endpoint path="output" />
            </inbound>
            <outbound>
                <outbound-pass-through-router>
                    <stdio:outbound-endpoint system="OUT"/>
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <component class="fr.kayentis.forms.component.ExceptionToMail" />
            <outbound>
                <outbound-pass-through-router>
                    <vm:outbound-endpoint path="smtp" />
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="Smtp">
            <inbound>
                <vm:inbound-endpoint path="smtp" />
            </inbound>
            <outbound>
                <outbound-pass-through-router>
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." to="${email}" transformer-refs="SessionToHtml"/>
                </outbound-pass-through-router>
            </outbound>
        </service>
        <service name="ErrorProcess">
            <inbound>
                <vm:inbound-endpoint path="errorProcess" />
            </inbound>
            <outbound>
                <outbound-pass-through-router>
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." to="okuntz@..." transformer-refs="SessionToHtml"/>
                </outbound-pass-through-router>
            </outbound>
        </service>
        <queue-profile persistent="true" maxOutstandingMessages="1000"/>
    </model>
</mule>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[bokc bokc]

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:
>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[antoine.borg]

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[bokc bokc]

Hi,

So I do in my recipientListRouter :

    @Override
    protected List getRecipients(MuleMessage message) {
        List list = new ArrayList();
        Object payload = message.getOrginalPayload();
        if (payload instanceof ExceptionMessage) {
            ExceptionMessage ex = (ExceptionMessage) payload;
            Object payloadEx = ex.getPayload();
            if (payloadEx instanceof Session) {
                Session session = (Session) payloadEx;
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", session.getFormVersion().getForm().getProject().getSupportEmail());
                message.addProperties(properties);
                list.add(message);
            } else {
                LOG.warn("Bad class in ex : " + payloadEx.getClass());
                LOG.debug("payload : " + payload.toString());
                LOG.debug("payloadEx : " + payloadEx.toString());
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", DEFAULT_MAIL);
                message.addProperties(properties);
                list.add(message);
            }
        } else {
            LOG.warn("Bad class : " + payload.getClass());
        }
        return list;
    }

But I have this error message :
WARN  2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Bad class in ex : class java.lang.String
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payload : ExceptionMessage{message=com.kayentis.forms.session.Session@22b29a, context={MULE_CORRELATION_ID=3f7613b4-49a4-11dd-8ca6-bf389d27912d, MULE_ENDPOINT=vm://penSessionProcess, MULE_ORIGINATING_ENDPOINT=endpoint.vm.penSessionProcess}exception=org.mule.api.service.ServiceException: Component that caused exception is: HwrProcess. Message payload is of type: Session, componentName='HwrProcess', endpointUri=vm://penSessionProcess, timeStamp=Fri Jul 04 10:36:12 CEST 2008}
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payloadEx : com.kayentis.forms.session.Session@22b29a
ERROR 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message               : Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
Type                  : org.mule.api.registry.RegistrationException
Code                  : MULE_ERROR--2
JavaDoc               : http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html
********************************************************************************
Exception stack is:
1. Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869} (org.mule.api.registry.RegistrationException)
  org.mule.routing.outbound.AbstractRecipientList:147 (http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html)
********************************************************************************
Root Exception stack trace:
org.mule.api.registry.RegistrationException: Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
    at org.mule.routing.outbound.AbstractRecipientList.getRecipientEndpoint(AbstractRecipientList.java:147)
    at org.mule.routing.outbound.AbstractRecipientList.route(AbstractRecipientList.java:87)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:65)
    at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:44)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:70)
    at org.mule.service.AbstractService.sendToOutboundRouter(AbstractService.java:894)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:235)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:106)
    at org.mule.transport.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:104)
    at org.mule.transport.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:157)
    at org.mule.transport.AbstractConnector.send(AbstractConnector.java:1889)
    at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:76)
    at org.mule.AbstractExceptionListener.routeException(AbstractExceptionListener.java:307)
    at org.mule.service.DefaultServiceExceptionStrategy.routeException(DefaultServiceExceptionStrategy.java:60)
    at org.mule.DefaultExceptionStrategy.handleMessagingException(DefaultExceptionStrategy.java:30)
    at org.mule.AbstractExceptionListener.exceptionThrown(AbstractExceptionListener.java:144)
    at org.mule.service.AbstractService.handleException(AbstractService.java:561)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:249)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:262)
    at org.mule.transport.vm.VMMessageReceiver.onMessage(VMMessageReceiver.java:98)
    at org.mule.transport.vm.VMMessageDispatcher.doDispatch(VMMessageDispatcher.java:66)
    at org.mule.transport.AbstractMessageDispatcher$Worker.run(AbstractMessageDispatcher.java:262)
    at org.mule.work.WorkerContext.run(WorkerContext.java:310)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
    at java.lang.Thread.run(Unknown Source)

My Mule service configuration :
        <custom-transformer name="ExceptionToHtml" class="fr.kayentis.forms.mule.transformer.ExceptionToHtml" />
        <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <outbound>
                <custom-outbound-router class="fr.kayentis.forms.mule.component.ExceptionToMail">
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." transformer-refs="ExceptionToHtml"/>
                </custom-outbound-router>
            </outbound>
        </service>


I put log in my transformer. But they are not on log file. So I don't enter the transformer.

Can you help me to find my error?

Youkoun

2008/7/4 Antoine Borg <antoine.borg@...>:

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-

>> tp18153616p18211553.html

>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[antoine.borg]

Hi,

 

Since the endpoint does not seem to work, it makes sense that the transformation isn't invoked.

 

It looks like the list that you return is not recognised by the router mechanism - I notice that you're adding the e-mail address as a property to the MuleMessage. What if you change that so the To address is the endpoint URL?

 

A

 

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Friday, July 04, 2008 10:57 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

Hi,

So I do in my recipientListRouter :

    @Override
    protected List getRecipients(MuleMessage message) {
        List list = new ArrayList();
        Object payload = message.getOrginalPayload();
        if (payload instanceof ExceptionMessage) {
            ExceptionMessage ex = (ExceptionMessage) payload;
            Object payloadEx = ex.getPayload();
            if (payloadEx instanceof Session) {
                Session session = (Session) payloadEx;
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", session.getFormVersion().getForm().getProject().getSupportEmail());
                message.addProperties(properties);
                list.add(message);
            } else {
                LOG.warn("Bad class in ex : " + payloadEx.getClass());
                LOG.debug("payload : " + payload.toString());
                LOG.debug("payloadEx : " + payloadEx.toString());
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", DEFAULT_MAIL);
                message.addProperties(properties);
                list.add(message);
            }
        } else {
            LOG.warn("Bad class : " + payload.getClass());
        }
        return list;
    }

But I have this error message :
WARN  2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Bad class in ex : class java.lang.String
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payload : ExceptionMessage{message=com.kayentis.forms.session.Session@22b29a, context={MULE_CORRELATION_ID=3f7613b4-49a4-11dd-8ca6-bf389d27912d, MULE_ENDPOINT=vm://penSessionProcess, MULE_ORIGINATING_ENDPOINT=endpoint.vm.penSessionProcess}exception=org.mule.api.service.ServiceException: Component that caused exception is: HwrProcess. Message payload is of type: Session, componentName='HwrProcess', endpointUri=vm://penSessionProcess, timeStamp=Fri Jul 04 10:36:12 CEST 2008}
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payloadEx : com.kayentis.forms.session.Session@22b29a
ERROR 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message               : Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
Type                  : org.mule.api.registry.RegistrationException
Code                  : MULE_ERROR--2
JavaDoc               : http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html
********************************************************************************
Exception stack is:
1. Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869} (org.mule.api.registry.RegistrationException)
  org.mule.routing.outbound.AbstractRecipientList:147 (http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html)
********************************************************************************
Root Exception stack trace:
org.mule.api.registry.RegistrationException: Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
    at org.mule.routing.outbound.AbstractRecipientList.getRecipientEndpoint(AbstractRecipientList.java:147)
    at org.mule.routing.outbound.AbstractRecipientList.route(AbstractRecipientList.java:87)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:65)
    at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:44)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:70)
    at org.mule.service.AbstractService.sendToOutboundRouter(AbstractService.java:894)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:235)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:106)
    at org.mule.transport.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:104)
    at org.mule.transport.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:157)
    at org.mule.transport.AbstractConnector.send(AbstractConnector.java:1889)
    at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:76)
    at org.mule.AbstractExceptionListener.routeException(AbstractExceptionListener.java:307)
    at org.mule.service.DefaultServiceExceptionStrategy.routeException(DefaultServiceExceptionStrategy.java:60)
    at org.mule.DefaultExceptionStrategy.handleMessagingException(DefaultExceptionStrategy.java:30)
    at org.mule.AbstractExceptionListener.exceptionThrown(AbstractExceptionListener.java:144)
    at org.mule.service.AbstractService.handleException(AbstractService.java:561)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:249)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:262)
    at org.mule.transport.vm.VMMessageReceiver.onMessage(VMMessageReceiver.java:98)
    at org.mule.transport.vm.VMMessageDispatcher.doDispatch(VMMessageDispatcher.java:66)
    at org.mule.transport.AbstractMessageDispatcher$Worker.run(AbstractMessageDispatcher.java:262)
    at org.mule.work.WorkerContext.run(WorkerContext.java:310)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
    at java.lang.Thread.run(Unknown Source)

My Mule service configuration :
        <custom-transformer name="ExceptionToHtml" class="fr.kayentis.forms.mule.transformer.ExceptionToHtml" />
        <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <outbound>
                <custom-outbound-router class="fr.kayentis.forms.mule.component.ExceptionToMail">
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." transformer-refs="ExceptionToHtml"/>
                </custom-outbound-router>
            </outbound>
        </service>


I put log in my transformer. But they are not on log file. So I don't enter the transformer.

Can you help me to find my error?

Youkoun

2008/7/4 Antoine Borg <antoine.borg@...>:

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[bokc bokc]

Hi,

I thought that my transformer is not good. It make String and not email message. I will try to change it.

Youkoun

2008/7/7 Antoine Borg <antoine.borg@...>:

Hi,

 

Since the endpoint does not seem to work, it makes sense that the transformation isn't invoked.

 

It looks like the list that you return is not recognised by the router mechanism - I notice that you're adding the e-mail address as a property to the MuleMessage. What if you change that so the To address is the endpoint URL?

 

A

 

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]

Sent: Friday, July 04, 2008 10:57 AM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

Hi,

So I do in my recipientListRouter :

    @Override
    protected List getRecipients(MuleMessage message) {
        List list = new ArrayList();
        Object payload = message.getOrginalPayload();
        if (payload instanceof ExceptionMessage) {
            ExceptionMessage ex = (ExceptionMessage) payload;
            Object payloadEx = ex.getPayload();
            if (payloadEx instanceof Session) {
                Session session = (Session) payloadEx;
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", session.getFormVersion().getForm().getProject().getSupportEmail());
                message.addProperties(properties);
                list.add(message);
            } else {
                LOG.warn("Bad class in ex : " + payloadEx.getClass());
                LOG.debug("payload : " + payload.toString());
                LOG.debug("payloadEx : " + payloadEx.toString());
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", DEFAULT_MAIL);
                message.addProperties(properties);
                list.add(message);
            }
        } else {
            LOG.warn("Bad class : " + payload.getClass());
        }
        return list;
    }

But I have this error message :
WARN  2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Bad class in ex : class java.lang.String
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payload : ExceptionMessage{message=com.kayentis.forms.session.Session@22b29a, context={MULE_CORRELATION_ID=3f7613b4-49a4-11dd-8ca6-bf389d27912d, MULE_ENDPOINT=vm://penSessionProcess, MULE_ORIGINATING_ENDPOINT=endpoint.vm.penSessionProcess}exception=org.mule.api.service.ServiceException: Component that caused exception is: HwrProcess. Message payload is of type: Session, componentName='HwrProcess', endpointUri=vm://penSessionProcess, timeStamp=Fri Jul 04 10:36:12 CEST 2008}
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payloadEx : com.kayentis.forms.session.Session@22b29a
ERROR 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message               : Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
Type                  : org.mule.api.registry.RegistrationException
Code                  : MULE_ERROR--2
JavaDoc               : http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html
********************************************************************************
Exception stack is:
1. Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869} (org.mule.api.registry.RegistrationException)
  org.mule.routing.outbound.AbstractRecipientList:147 (http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html)
********************************************************************************
Root Exception stack trace:
org.mule.api.registry.RegistrationException: Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
    at org.mule.routing.outbound.AbstractRecipientList.getRecipientEndpoint(AbstractRecipientList.java:147)
    at org.mule.routing.outbound.AbstractRecipientList.route(AbstractRecipientList.java:87)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:65)
    at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:44)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:70)
    at org.mule.service.AbstractService.sendToOutboundRouter(AbstractService.java:894)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:235)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:106)
    at org.mule.transport.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:104)
    at org.mule.transport.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:157)
    at org.mule.transport.AbstractConnector.send(AbstractConnector.java:1889)
    at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:76)
    at org.mule.AbstractExceptionListener.routeException(AbstractExceptionListener.java:307)
    at org.mule.service.DefaultServiceExceptionStrategy.routeException(DefaultServiceExceptionStrategy.java:60)
    at org.mule.DefaultExceptionStrategy.handleMessagingException(DefaultExceptionStrategy.java:30)
    at org.mule.AbstractExceptionListener.exceptionThrown(AbstractExceptionListener.java:144)
    at org.mule.service.AbstractService.handleException(AbstractService.java:561)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:249)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:262)
    at org.mule.transport.vm.VMMessageReceiver.onMessage(VMMessageReceiver.java:98)
    at org.mule.transport.vm.VMMessageDispatcher.doDispatch(VMMessageDispatcher.java:66)
    at org.mule.transport.AbstractMessageDispatcher$Worker.run(AbstractMessageDispatcher.java:262)
    at org.mule.work.WorkerContext.run(WorkerContext.java:310)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
    at java.lang.Thread.run(Unknown Source)

My Mule service configuration :
        <custom-transformer name="ExceptionToHtml" class="fr.kayentis.forms.mule.transformer.ExceptionToHtml" />
        <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <outbound>
                <custom-outbound-router class="fr.kayentis.forms.mule.component.ExceptionToMail">
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." transformer-refs="ExceptionToHtml"/>
                </custom-outbound-router>
            </outbound>
        </service>


I put log in my transformer. But they are not on log file. So I don't enter the transformer.

Can you help me to find my error?

Youkoun

2008/7/4 Antoine Borg <antoine.borg@...>:

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[bokc bokc]

I make the transformer but the exception is the same.
ERROR 2008-07-07 11:41:42,102 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy: Message being processed is: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@b0a518{id=e4d89000-4c08-11dd-8d90-71cc6a54fc66, payload=com.kayentis.forms.session.Session, correlationId=e4d89000-4c08-11dd-8d90-71cc6a54fc66, correlationGroup=-1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@126f304}
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.transformer.ObjectToEmailMessage: Setting transformer name to: objectToEmailMessage
INFO  2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] org.mule.transport.vm.VMMessageDispatcher: Connected: VMMessageDispatcher{this=4577f9, endpoint=vm://serviceException, disposed=false}
WARN  2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Bad class in payloadEx : class java.lang.String
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payload : ExceptionMessage{message=com.kayentis.forms.session.Session@38c8c5, context={MULE_CORRELATION_ID=e4d89000-4c08-11dd-8d90-71cc6a54fc66, MULE_ENDPOINT=vm://penSessionProcess, MULE_ORIGINATING_ENDPOINT=endpoint.vm.penSessionProcess}exception=org.mule.api.service.ServiceException: Component that caused exception is: HwrProcess. Message payload is of type: Session, componentName='HwrProcess', endpointUri=vm://penSessionProcess, timeStamp=Mon Jul 07 11:41:42 CEST 2008}
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payloadEx : com.kayentis.forms.session.Session@38c8c5
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Propertie : MULE_CORRELATION_ID=e4d89000-4c08-11dd-8d90-71cc6a54fc66
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Propertie : MULE_ENDPOINT=vm://serviceException
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Propertie : MULE_ORIGINATING_ENDPOINT=endpoint.vm.serviceException
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Propertie : to=okuntz@...
DEBUG 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Return list (1)
ERROR 2008-07-07 11:41:42,212 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message               : Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@c78e02{id=e4d89000-4c08-11dd-8d90-71cc6a54fc66, payload=org.mule.message.ExceptionMessage, correlationId=e4d89000-4c08-11dd-8d90-71cc6a54fc66, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@126f304}
Type                  : org.mule.api.registry.RegistrationException
Code                  : MULE_ERROR--2
JavaDoc               : http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html
********************************************************************************
Exception stack is:
1. Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@c78e02{id=e4d89000-4c08-11dd-8d90-71cc6a54fc66, payload=org.mule.message.ExceptionMessage, correlationId=e4d89000-4c08-11dd-8d90-71cc6a54fc66, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@126f304} (org.mule.api.registry.RegistrationException)
  org.mule.routing.outbound.AbstractRecipientList:147 (http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html)
********************************************************************************
Root Exception stack trace:
org.mule.api.registry.RegistrationException: Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@c78e02{id=e4d89000-4c08-11dd-8d90-71cc6a54fc66, payload=org.mule.message.ExceptionMessage, correlationId=e4d89000-4c08-11dd-8d90-71cc6a54fc66, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@126f304}
    at org.mule.routing.outbound.AbstractRecipientList.getRecipientEndpoint(AbstractRecipientList.java:147)
    at org.mule.routing.outbound.AbstractRecipientList.route(AbstractRecipientList.java:87)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:65)
    at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:44)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:70)
    at org.mule.service.AbstractService.sendToOutboundRouter(AbstractService.java:894)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:235)
....


My Mule configuration :
       <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <!--component class="fr.kayentis.forms.mule.component.ExceptionToHtml" /-->
            <outbound>
                <custom-outbound-router class="fr.kayentis.forms.mule.component.ExceptionToMail">
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." transformer-refs="objectToHtml stringToEmail">
                        <property key="contentType" value="text/html" />
                    </smtp:outbound-endpoint>
                </custom-outbound-router>
            </outbound>
        </service>

The Exception To Mail class :
   @Override
    protected List getRecipients(MuleMessage message) {
        List list = new ArrayList();
        Object payload = message.getOrginalPayload();
        if (payload instanceof ExceptionMessage) {
            ExceptionMessage ex = (ExceptionMessage) payload;
            Object payloadEx = ex.getPayload();
            if (payloadEx instanceof Session) {
                Session session = (Session) payloadEx;
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", session.getFormVersion().getForm().getProject().getSupportEmail());
                message.addProperties(properties);
                list.add(message);
            } else {
                LOG.warn("Bad class in payloadEx : " + payloadEx.getClass());
                LOG.debug("payload : " + payload.toString());
                LOG.debug("payloadEx : " + payloadEx.toString());
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                    LOG.debug("Propertie : " + propertyKey + "=" + message.getProperty(propertyKey));
                }
                properties.put("to", DEFAULT_MAIL);
                LOG.debug("Propertie : to=" + DEFAULT_MAIL);
                message.addProperties(properties);
                list.add(message);
            }
        } else {
            LOG.warn("Bad class : " + payload.getClass());
        }
        LOG.debug("Return list (" + list.size() + ")");
        return list;
    }

I try to add the To attribute in the smtp outbound. But it's not the cause. I think I have problem in my class But where??

youkoun

2008/7/7 bokc bokc <youkoun@...>:

Hi,

I thought that my transformer is not good. It make String and not email message. I will try to change it.

Youkoun

2008/7/7 Antoine Borg <antoine.borg@...>:

Hi,

 

Since the endpoint does not seem to work, it makes sense that the transformation isn't invoked.

 

It looks like the list that you return is not recognised by the router mechanism - I notice that you're adding the e-mail address as a property to the MuleMessage. What if you change that so the To address is the endpoint URL?

 

A

 

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]

Sent: Friday, July 04, 2008 10:57 AM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

Hi,

So I do in my recipientListRouter :

    @Override
    protected List getRecipients(MuleMessage message) {
        List list = new ArrayList();
        Object payload = message.getOrginalPayload();
        if (payload instanceof ExceptionMessage) {
            ExceptionMessage ex = (ExceptionMessage) payload;
            Object payloadEx = ex.getPayload();
            if (payloadEx instanceof Session) {
                Session session = (Session) payloadEx;
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", session.getFormVersion().getForm().getProject().getSupportEmail());
                message.addProperties(properties);
                list.add(message);
            } else {
                LOG.warn("Bad class in ex : " + payloadEx.getClass());
                LOG.debug("payload : " + payload.toString());
                LOG.debug("payloadEx : " + payloadEx.toString());
                Map properties = new HashMap();
                for (Iterator iterator = message.getPropertyNames().iterator(); iterator.hasNext();) {
                    String propertyKey = (String) iterator.next();
                    properties.put(propertyKey, message.getProperty(propertyKey));
                }
                properties.put("to", DEFAULT_MAIL);
                message.addProperties(properties);
                list.add(message);
            }
        } else {
            LOG.warn("Bad class : " + payload.getClass());
        }
        return list;
    }

But I have this error message :
WARN  2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: Bad class in ex : class java.lang.String
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payload : ExceptionMessage{message=com.kayentis.forms.session.Session@22b29a, context={MULE_CORRELATION_ID=3f7613b4-49a4-11dd-8ca6-bf389d27912d, MULE_ENDPOINT=vm://penSessionProcess, MULE_ORIGINATING_ENDPOINT=endpoint.vm.penSessionProcess}exception=org.mule.api.service.ServiceException: Component that caused exception is: HwrProcess. Message payload is of type: Session, componentName='HwrProcess', endpointUri=vm://penSessionProcess, timeStamp=Fri Jul 04 10:36:12 CEST 2008}
DEBUG 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] fr.kayentis.forms.mule.component.ExceptionToMail: payloadEx : com.kayentis.forms.session.Session@22b29a
ERROR 2008-07-04 10:36:12,555 [connector.VM.0.dispatcher.6] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message               : Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
Type                  : org.mule.api.registry.RegistrationException
Code                  : MULE_ERROR--2
JavaDoc               : http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html
********************************************************************************
Exception stack is:
1. Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869} (org.mule.api.registry.RegistrationException)
  org.mule.routing.outbound.AbstractRecipientList:147 (http://mule.mulesource.org/docs/apidocs/org/mule/api/registry/RegistrationException.html)
********************************************************************************
Root Exception stack trace:
org.mule.api.registry.RegistrationException: Failed to create endpoint for: org.mule.transport.DefaultMessageAdapter/org.mule.transport.DefaultMessageAdapter@88e83d{id=3f7613b4-49a4-11dd-8ca6-bf389d27912d, payload=org.mule.message.ExceptionMessage, correlationId=3f7613b4-49a4-11dd-8ca6-bf389d27912d, correlationGroup=1, correlationSeq=-1, encoding=UTF-8, exceptionPayload=org.mule.message.DefaultExceptionPayload@836869}
    at org.mule.routing.outbound.AbstractRecipientList.getRecipientEndpoint(AbstractRecipientList.java:147)
    at org.mule.routing.outbound.AbstractRecipientList.route(AbstractRecipientList.java:87)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:65)
    at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:44)
    at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:70)
    at org.mule.service.AbstractService.sendToOutboundRouter(AbstractService.java:894)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:235)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:106)
    at org.mule.transport.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:104)
    at org.mule.transport.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:157)
    at org.mule.transport.AbstractConnector.send(AbstractConnector.java:1889)
    at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:76)
    at org.mule.AbstractExceptionListener.routeException(AbstractExceptionListener.java:307)
    at org.mule.service.DefaultServiceExceptionStrategy.routeException(DefaultServiceExceptionStrategy.java:60)
    at org.mule.DefaultExceptionStrategy.handleMessagingException(DefaultExceptionStrategy.java:30)
    at org.mule.AbstractExceptionListener.exceptionThrown(AbstractExceptionListener.java:144)
    at org.mule.service.AbstractService.handleException(AbstractService.java:561)
    at org.mule.model.seda.SedaService.doSend(SedaService.java:249)
    at org.mule.service.AbstractService.sendEvent(AbstractService.java:510)
    at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:351)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:196)
    at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:164)
    at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:604)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:346)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:269)
    at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:262)
    at org.mule.transport.vm.VMMessageReceiver.onMessage(VMMessageReceiver.java:98)
    at org.mule.transport.vm.VMMessageDispatcher.doDispatch(VMMessageDispatcher.java:66)
    at org.mule.transport.AbstractMessageDispatcher$Worker.run(AbstractMessageDispatcher.java:262)
    at org.mule.work.WorkerContext.run(WorkerContext.java:310)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
    at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
    at java.lang.Thread.run(Unknown Source)

My Mule service configuration :
        <custom-transformer name="ExceptionToHtml" class="fr.kayentis.forms.mule.transformer.ExceptionToHtml" />
        <service name="ServiceException">
            <inbound>
                <vm:inbound-endpoint path="serviceException" />
            </inbound>
            <outbound>
                <custom-outbound-router class="fr.kayentis.forms.mule.component.ExceptionToMail">
                    <smtp:outbound-endpoint address="smtp://smtp.orange.fr" subject="Mule test" from="test@..." transformer-refs="ExceptionToHtml"/>
                </custom-outbound-router>
            </outbound>
        </service>


I put log in my transformer. But they are not on log file. So I don't enter the transformer.

Can you help me to find my error?

Youkoun

2008/7/4 Antoine Borg <antoine.borg@...>:

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18211553.html
>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[bokc bokc]

Hi,

Do you have an example? I try to do this but I'm in the wrong way.

youkoun

2008/7/4 Antoine Borg <antoine.borg@...>:

What you'd need to do is create your own RecipientList router which creates outbound endpoints dynamically based upon the list of e-mail addresses that it loads from your database.  The e-mail address should then be set as one of the properties of the endpoint - as the value of the "to" field to be precise

 

HTH

A

Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borgantoine.borg@... | blog: blog.ricston.com | web: ricston.com 

 

---

From: bokc bokc [mailto:youkoun@...]
Sent: Thursday, July 03, 2008 12:06 PM

To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase

If I understand what you suggest is to make my own RecipientList router (extends from AbstractRecipientList). Add an OutboundEndpoint (new DefaultOutboundEndpoint(...) ?) in the list with smtpConnector? And I add the e-mail address in the OuntboundEndpoint properties?

Youkoun

2008/7/3 Antoine Borg <antoine.borg@...>:

Hi,

Another possibility would be to use the RecipientList router (See my blog:
http://ricston.com/blog/?p=18) and perhaps customise it to look for the
addresses from the payload or its properties.

HTH


Antoine Borg, Senior Consultant | Tel: [phone] | Fax: [phone]
ricston Ltd., Lincoln, 7 Ferdinand Grech Street, Lija LJA1142, MALTA
email: antoine.borg@... | blog: blog.ricston.com | web: ricston.com

-----Original Message-----
From: coo|dude [mailto:cooldude_no1@...]
Sent: Thursday, July 03, 2008 4:52 AM
To: user@...
Subject: Re: [mule-user] SMTP transport with e-mail address in DataBase


I will not write the entire thing here, I think the below will be sufficient
for you. :)

You can do something like that in your class file:

UMOMessage response = eventContext.sendEvent(eventContext.getMessage(),
uri);
               Object emailAdd = response.getPayload();

Map map = new HashMap();
               map.put("email", emailAdd);
client.send("vm://in", "foolie", map);

then in your Mule config file, you can use ${email} for your other connector


bokc bokc wrote:

>
> Hi,
>
> I'm using Mule 2. Do you have an example, even if it was for Mule1 ?
>
> Youkoun
>
> 2008/7/2 coo|dude <cooldude_no1@...>:
>
>>
>> hhmm.. are you using Mule 1.x or Mule 2.x? I am not so sure about
>> Mule 2.x, but in 1.x, you can actually create a normal Java class
>> with getter and setter and this getter and setter can be used as part
>> of the properties attributes of the router.
>>
>>
>>
>> bokc bokc wrote:
>> >
>> > The 2nd solution look like the best but I don't see how to do this?
>> > For The JDBC connector, I know how to do this but how can I use
>> > data in payload object in the SQL query?
>> >
>> > Youkoun
>> >
>> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >
>> >>
>> >> hhmm..
>> >>
>> >> 1. You may need to write a custom filtering to grab the email
>> >> address
>> at
>> >> the
>> >> router, or
>> >> 2. Use JDBC connector to query the database directly to grab the
>> >> email address and echo is back to another Mule descriptor, or 3.
>> >> Ever thinking of putting the email address onto the Mule's
>> environment
>> >> properties file and grab the value there?
>> >>
>> >> cheers,
>> >>
>> >> bokc bokc wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > The e-mail address can change in the data base but the frequency
>> >> > is unknown.
>> >> > I think the easiest way is to put the e-mail in the payload object.
>> But
>> >> > after I don't know how to take and use it in the the smtp transport.
>> >> >
>> >> > Youkoun
>> >> >
>> >> > 2008/7/1 coo|dude <henry.tiong@...>:
>> >> >
>> >> >>
>> >> >> First thing first, is the value of the email address static or
>> >> >> it
>> will
>> >> be
>> >> >> changed accordingly (if so, how frequent)?
>> >> >>
>> >> >>
>> >> >> bokc bokc wrote:
>> >> >> >
>> >> >> > Hi,
>> >> >> >
>> >> >> > I would like to send e-mail trow smtp transport. But the
>> >> >> > e-mail
>> >> address
>> >> >> is
>> >> >> > in data base and it depend of data in the payload. Is it
>> >> >> > possible
>> to
>> >> >> take
>> >> >> > data in the DataBase with the mule ant put it in the e-mail
>> address
>> >> of
>> >> >> the
>> >> >> > smtp transport ?
>> >> >> > If not I can put it on the object in the payload. But how can
>> >> >> > I
>> >> extract
>> >> >> it
>> >> >> > for the smtp transport?
>> >> >> >
>> >> >> > Youkoun
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-

>> tp18153616p18211553.html

>> >> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe from this list, please visit:
>> >> >>
>> >> >>    http://xircles.codehaus.org/manage_email
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18212282.html
>> >> Sent from the Mule - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ------------------------------------------------------------------
>> >> --- To unsubscribe from this list, please visit:
>> >>
>> >>    http://xircles.codehaus.org/manage_email
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-
>> tp18153616p18230823.html Sent from the Mule - User mailing list
>> archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>>
>
>

--
View this message in context:
http://www.nabble.com/SMTP-transport-with-e-mail-address-in-DataBase-tp18153

616p18250848.html

Sent from the Mule - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email

[pangea]

check this thread.....

http://www.nabble.com/Sharing-a-solution-for-creating-dynamic-TCP-endpoints-to17085030.html