Datasource not bound problem

[huskerchen]

Hi:

I am running Postgresql on a remote server. JBOSS sits on the local server. I am trying to test the data source. I deployed the "Postgresal-ds.xml" to the deployment folder, and the JBOSS log says:

[PostgresDS] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=PostgresDS to JNDI name 'java:/PostgresDS'

Then I use the following code to look up the datasource:

props.put(InitialContext.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory");

props.put(InitialContext.PROVIDER_URL, "jnp://localhost:1099");
 Context ctx = new InitialContext(props);
DataSource ds = (DataSource)ctx.lookup("java:/PostgresDS");

An exception comes out:

javax.naming.NameNotFoundException: PostgresDS not bound

What's missing here? It seems the JBOSS log said the data source was bound to "java:/PostgresDS", why this JNDI name is not bound when I tried to connect to the data source?

Thanks a lot!

[juha]

You cannot lookup a datasource remotely, it is only visible to the components within app server.

[timo.waldschmidt1]

Hi juha,

to all appearances your I can't confirm your answer. Instead its the main-advantage to look local for your remote database, even if you have access to the jndi-context. Or did you mean something else?

[darranl]

If you application is running in a different JVM to JBoss you will not be able to access the data connection registered in the JBoss JNDI.

By doing props.put(InitialContext.PROVIDER_URL, "jnp://localhost:1099");
you are effectively accessing JNDI from the outside regardless of where your code is being exeuted.