Datasource injection not working on Web Services ?

[dimar1975]

Hi all !
I'm trying to inject a Datasource in a Webservice....

@WebService(name = "CalculatorWS", targetNamespace = "http://webservice_calc/calculator")
public class CalculatorWS
{
 @Resource(mappedName="java:/OracleDS")
 DataSource datasource;

 @WebMethod
 public Person calculate(Object obj) {
 System.out.println("Datasource is " + datasource; // NULL !!
 // .....
 }
}

The Datasource injected is null in the method calculate.....
so I have tried to get the datasource with the InitialContext

DataSource ds = (DataSource)new InitialContext().lookup("java:/OracleDS");

Connection conn = null;
try {

conn = ds.getConnection();
System.out.println("Connection with initial context" +conn);
}

and the Connection is correctly retrieved.

Do I miss something to make it work also with injection ???
Thanks a lot
Marco

[dimar1975]

Forgot to say: I'm using JBoss AS 5.0 GA but I have tried with no success also with JBoss 4.2

[skajotde]

Try add @Stateless to class, so webserwice will be also ejb bean (we use that case in our application). Injection should work.

[sannegrinovero]

Hello, same problem here:
the DataSource returned is null, even from stateful beans: remoting beans, message driven beans, MBeans. (tryed them all!)

It's also null when trying to create a new EntityManagerFactory, as in this thread:
https://forum.hibernate.org/viewtopic.php?f=9&t=982137

The configuration is right, otherwise you wouldn't get null but an exception.
please, some suggestion?

[sannegrinovero]

sorry forgot to mention some info:

testing on JBoss 5.1.0.GA

the datasource I'm trying to retrieve is correctly used by other apps, and I can see it's fine in the jmx console.

[jaikiran]

"sannegrinovero" wrote:
Hello, same problem here:
the DataSource returned is null, even from stateful beans: remoting beans, message driven beans, MBeans. (tryed them all!)

Packaging any jars containing javax.sql.* or any other javax.ejb.* or javax.annotation.* in your application? If yes then remove those jars.