Hi there, 

I got the following problem. I create some simple test code to get my PSQL
DB connection working. I am aiming to use plain java and no container at
all. The code is executed an no exception is thrown. So maybe I have
forgotten something? My code looks as follows:

        Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
        source.setDataSourceName("testdb");
        source.setServerName("localhost");
        source.setPortNumber(5432);
        source.setDatabaseName("testdb");
        source.setUser("root");
        source.setPassword("password");
        source.setMaxConnections(10);
        JdbcComponent jdbcComponent = new JdbcComponent();
        jdbcComponent.setDataSource(source);
        SimpleRegistry reg = new SimpleRegistry();
        reg.put("testdb", source);
        CamelContext context = new DefaultCamelContext(reg);
        JdbcEndpoint jdbcEndpoint = new JdbcEndpoint("jdbc", jdbcComponent,
source);
        context.addEndpoint("jdbc", jdbcEndpoint);
        context.addComponent("jdbc", jdbcComponent);
        context.addRoutes(new RouteBuilder() {
            public void configure() {
                from("timer://foo?period=1000").setBody(constant("select *
from test")).to("jdbc:testdb").split(body()).to("file:processed"); 
            }
        });
        context.start();

I'd appreciate any hint :) Thx

--
View this message in context: 
http://camel.465427.n5.nabble.com/PSQL-DB-not-returning-values-at-all-tp5583803p5583803.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to