How to connect from non-EJB application

[cbowditch]

Hi,

does anyone know if it is possible to connect to a JDBC data source from a standalone Java application.

I can do this with Weblogic Data sources. The application simply connects to the JNDI, and does a lookup of the Datasource. However, in JBoss, the Data source names are always prefixed java: meaning they are only available within the server VM.

Any idea would be gratefully received

Chris

[adrian.brock]

Does it really make sense to pool DB connections
only to send them over the network?

Regards,
Adrian

[kbirch]

If you are connecting to Oracle, then their JDBC driver has built-in support for standalone pooling. Check out the Oracle JDBC Developer's guide 8i or 9i on otn.oracle.com. Look at the sections on using DataSources without JNDI or Connection Caching.

kevin