Camel and PostgreSQL

[Eagleye <ni...@gmail.com>]

How do I configure camel with PostgreSQL? Please let me know.



--
View this message in context: http://camel.465427.n5.nabble.com/Camel-and-PostgreSQL-tp5741232.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel and PostgreSQL

[Christian Mueller <ch...@gmail.com>]

Can you please subscribe to the discussion forum as we describe here [1].
Otherwise all your mails has to be moderate by the Camel team and is may
missed/delayed.

[1] http://camel.apache.org/discussion-forums.html

Thanks in advance,
Christian



--
View this message in context: http://camel.465427.n5.nabble.com/Camel-and-PostgreSQL-tp5741232p5741241.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel and PostgreSQL

[Bob Jolliffe <bo...@gmail.com>]

Does seem to be a strange question.

If you are just trying to access a postgresql database from within a camel
route, using for example the sql component, then you need to:

1.  setup a bean for the postgresql datasource, something like

<bean id="dhisdb"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="org.postgresql.Driver"/>
        <property name="url" value="jdbc:postgresql://localhost:5432/ddd"/>
        <property name="username" value="user"/>
        <property name="password" value="password"/>
    </bean>

2.  then you can execute sql as part of route, eg
<route>
            <description>select some rows</description>
            <from uri="direct:doPG" />
            <to  uri="sql:{{sql.selectOus}}?dataSourceRef=dhisdb"/>
            ....
</route>

(Note in this case the actual select query is defined externally in a
properties file)


On 9 October 2013 14:29, Charles Moulliard <ch...@gmail.com> wrote:

> What a strange question ? What do you plan to do / develop with Camel ?
> Which component would you like to use ? Which framework do you plan to use
> (Spring, Blueprint, CDI, EE, ...) ?
>
> Without such info, we can't help you.
>
>
> On Wed, Oct 9, 2013 at 2:27 PM, Eagleye <ni...@gmail.com> wrote:
>
> > How do I configure camel with PostgreSQL? Please let me know.
> >
> >
> >
> > --
> > View this message in context:
> > http://camel.465427.n5.nabble.com/Camel-and-PostgreSQL-tp5741232.html
> > Sent from the Camel - Users mailing list archive at Nabble.com.
> >
>
>
>
> --
> Charles Moulliard
> Apache Committer / Architect @RedHat
> Twitter : @cmoulliard | Blog :  http://cmoulliard.github.io
>

Re: Camel and PostgreSQL

[Charles Moulliard <ch...@gmail.com>]

What a strange question ? What do you plan to do / develop with Camel ?
Which component would you like to use ? Which framework do you plan to use
(Spring, Blueprint, CDI, EE, ...) ?

Without such info, we can't help you.


On Wed, Oct 9, 2013 at 2:27 PM, Eagleye <ni...@gmail.com> wrote:

> How do I configure camel with PostgreSQL? Please let me know.
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Camel-and-PostgreSQL-tp5741232.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>



-- 
Charles Moulliard
Apache Committer / Architect @RedHat
Twitter : @cmoulliard | Blog :  http://cmoulliard.github.io