InjectionException

[vinay kumar]

Hi,

I am using Glassfish 2.1 app server. I set up a JDBC Resource with the name 'jdbc/myDB'.

And I used @Resource annotation to inject the resource in my ejb (ejb3) as below:

@Stateless
public class BidManagerBean implements BidManager {

@Resource(name="jdbc/myDB") private DataSource ds;
....
}

I didn't mention anything in deployment descriptor as I am using ejb3 with annotations.

Now, when I access this ejb from the client, I am getting the following error:

"com.sun.enterprise.InjectionException: Exception attempting to inject Res-Ref-Env-Property: jdbc/[email protected]@ resolved as: jndi: jdbc/myDB@res principal: null@mail: null
No Runtime properties
Database Vendor : null"


Can you please tell me where I am going wrong.

Thanks
Vinay

[Marcos Serrano]

I think it's missing the "mappedName". I got a derby connection with jboss and works fine.

"java:jdbc/DerbyDS" is defined in jboss

   
@Stateless
public class PlaceBidBean implements PlaceBid {
	private DataSource dataSource;

	private Connection connection;

	@Resource
	private SessionContext sc;

	@Resource(name = "jdbc/DerbyDS", mappedName = "java:jdbc/DerbyDS")
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

[vinay kumar]

Thanks Marcos for reply. But I still have get the following error

com.sun.enterprise.InjectionException: Exception attempting to inject Res-Ref-Env-Property: jdbc/[email protected]@ resolved as: jndi: java:jdbc/vinayDB@res principal: null@mail: null

when I use

@Stateless
public class BidManagerBean implements BidManager {
	
	@Resource(name="jdbc/vinayDB", mappedName="java:jdbc/vinayDB") 
	private DataSource ds;
                ....
}

I created the JDBCResource with name "jdbc/vinayDB". I couldn't figure it out where Im going wrong.

thanks
vinay

[Sai Surya]

Is your client running in the same environment to make DI work? If you are calling client from outside
you can't use DI and you need to use JNDI look up to get reference to JDBC resource. If you want to
use DI from client try running client in ACC.

Hope this helps.

[vinay kumar]

Yes. I am running the client (a web project ) and ejb (ejb project) on the same Glassfish server. I am using eclipse and configured the projects correctly. I am able to access the Session bean created on ejb project from the client project.

I couldn't figure it out still. please help.

[Ramesh Pentakota]

Vinay,

I was able to get connection from Datasource using DI in EJB as shown below.

@Resource(name="jdbc/rameshDB") private javax.sql.DataSource myDB;

May be connection pool configuration has to be reviewed.