Hi,

If you publish your DataSource as OSGi service then you can use OSGi style jndi name to refer it, configure the OSGi style jndi name looks like
<property name="DataSource" value="osgi:services/oracle.jdbc.pool.OracleDataSource/(osgi.jndi.service.name=jndiPARUS)" />

take a look at related discussion[1] & [2] to get more details.

[1]http://fusesource.com/forums/thread.jspa?messageID=10587
[2]http://fusesource.com/forums/thread.jspa?messageID=10525

Freeman

Hello,
I can not run camel-jdbc in java.

I defines a route with camel-blueprint, via a road builder (not in XML)
because I know the road to be built when bundle start.

when starting the bundle, I read a database that contains definitions of endpoints. with there informations, I build the road. where in the database I have a record defining an endpoint jdbc datasource I create a datasource "myDataSourceName" and the uri "jdbc:myDataSourceName"

in the documentation I've read, I had to do
JndiRegistry reg = super.createRegistry();
reg.bind("testdb", db);
return reg;

but I'm in the configure method or in constructor of route builder
I can not call super.createRegistry(); the register already exists
I tried context.getRegistry (); who gets a JndiRegistry but getRegistry() return a simple Registry.
The bind method does not exist on Registry.
I tried (JndiRegistry) context.getRegistry();
but I get a CastException.

public RouteBuilder()
super();
inUrl = getParameter("input.url");
... read configuration datas
DataSourceName = "myDataSourceName";

DataSource DS = DataSourceFactory.create(DataSourceName, ....); //using pooled datasource factory (c3p0)

JndiRegistry reg = (JndiRegistry) getContext().getRegistry(); //CastException
reg.bind("myDataSourceName", reg);//
//Or
Registry reg = getContext().getRegistry();
reg.bind("myDataSourceName", reg);//

dsUri = "jdbc:" DataSourceName;
}

public void configure() {{color}
RouteDefinition r = from(inUrl);
if ("sommeValue".equals(sommeParameter) {}
r.bean(MyBean.class);
...
r.to("dsUri)

I have a similar problem in JUnit
CamelTestSupport created a camelContext and a Registry
then create the RouteBuilder (calls constructor)
and calls the configure() method

I've created an object datasource but inpossible to put it in the registry.

can you help me ?
A JYT

Hi

No this is not the same problem.

bundle is when I start I do not know if the datasource exists
if it does not exist I create it and then I must save it in JNDI

but getContext().GetRegistry(); can not call the bind method.
for that you need to use.
new InitialContext();

but if we make new InitialContext();
the datasource is not recorded in camel Registry when you're in a JUnit test.

test set for a camel routebuilder
public class extends MyRouteBuilder RouteBuilder
public RouteBuilder () {
/ / Create a datasource
datasource = ....;
/ / Save it in camel registry
InitialContext = new InitialContext ();
InitialContext. bind (datasourcename, datasource);
}

on junit camelTestSupport, the datasource is not present in the Camel registry
public void configure() {
Registry reg = getContext().getRegistry();
dataSource = (DataSource) reg.lookup(datasourcename);
}

and with this code the datasource is not present in JNDI Registry
public void configure() {
InitialContext reg= new InitialContext();
dataSource = (DataSource) reg.lookup(datasourcename);
}

and the following code does not work either
public void configure() {
from(...)
.to("jdbc:" + datasourcename);
}

I've debugged step by step:
In the constructor the datasource is in the registry.
After the constructor is no longer present.
A+JYT

Edited by: sekaijin on Apr 2, 2012 4:00 PM

Hi,

Thanks for sharing your solution.

Freeman