cast the entityManager.getDelegate() (Session in Hibernate case) and get the connection from there.

or look it up in JNDI

Or standard EJB3 injection

E.g.

@Stateless
@Name("bankBalanceManager")
public class BankBalanceManagerBean implements BankBalanceManager {
...
     @Resource (mappedName=BLJndi.DataSourceName)
     private DataSource jnetDS; 
...
}

Something like that, if it works, it ain't broken ;-) At least not yet

Hi!

I am curious... Why would you need to change the datasource name often?

AFAIK if you are creating your project with  eclipse, your datasource configuration should be stored in a file like nameofyourproject-ds.xml, its contents look like this:

 

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE datasources
    PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
    "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
    
<datasources>
   
   <local-tx-datasource>
      <jndi-name>nameofyourprojectDatasource</jndi-name>
      <connection-url>jdbc:hsqldb:hsql://localhost/xdb</connection-url>
      <driver-class>org.hsqldb.jdbcDriver</driver-class>
      <user-name>sa</user-name>
      <password></password>
   </local-tx-datasource>
    
</datasources>

In this case the name of you datasource is nameofyourprojectDatasource,and it shouldn't change... unless you manually change it (you can change the connection string and even the driver but keep the name without change).

Regards,
LuxSpes