Using connection pool in a class (not ejb, servlet ...)

[vijayk]

Hello all,

I am able to lookup a connection pool from within an EJB. I can do from a servlet also. I need to lookup from a class that is neither a servet nor an ejb. How do I do that? From an ejb, I lookup this way:

Context context = new InitialContext();
DataSource ds = (DataSource)context.lookup("java:/jdbc/PBOPool");
connection = ds.getConnection();

Thank you,
Vijay

[vijayk]

Hi,

The class I am tlking about does not exist in the same JVM as JBoss. It runs within Tomcat that uses JBoss' Ejbs. I have no problem looking up EJBs this way. The problem is when I try to obtain a connection. Any help or document is appreciated.

-Vijay

[rajaboobalan]

Vijay,
I am NOT sure, if I have understood your problem correctly. Since you have said you need to look up from TOMCAT (running on a different JVM) you will have to register the DATASOURCE with TOMCAT.

[raja05]

You cannot use java:comp/jdbc or java:/ as they all work if the resource accesssing it is in the same VM.
For non-same VM Calls, use the JNDI name of ur datasource directly, like

ds = (Datasource) ctx.lookup("PBOPool")

Assuming PBOPool is the jndiname of ur datasource,

-Raj

[anthrope]

Sorry,
But it appears that DataSource objects defined in JBOSS are not visible to standalone JDBC clients. WebLogic supports this feature, i.e., remote or serializable DataSource objects.

That's what I have discovered after a lot of looking around. Any idea why this is so?

PN