List available data sources in EJB

[Alex Molochnikov]

Is there any way to get the list of all data sources available to a session
bean? E.g. if the server (JBoss) configuration has files mssql-ds.xml and
mysql-ds.xml with jndi-name tags "MSSQLDS" and "MySqlDS" respectively, I
want to pack Strings "MSSQLDS" and "MySqlDS" into a Collection and pass it
to the client. The client will display the list of available sources and let
the user choose the database to work with.

Is it possible at all?

TIA

Alex Molochnikov
Gestalt Corporation

 

[Alex Molochnikov]

Responding to my own post:

It is possible. Here is the code:

InitialContext context = new InitialContext();
NamingEnumeration ne = context.listBindings("java:/");
while (ne.hasMore())
{
Binding b = (Binding) ne.next();
if (b.getClassName().endsWith(".DataSource"))
System.out.println(" data source = " + b.getName());
}