JNDI connection problem

[chaitanya karthikk]

Hi all,

I have an ear in which there is a war and an ejb jar. In my ejb jar under META-INF there is glassfish-resources.xml. I created a jdbc-connection-pool whose name is java:app/mydb_pool. Then I created a resource which refers to this pool whose jndi name is "java:app/mydb".

In my ejb I created an InitialContext which lookups the jndi. I am getting error. Can anyone please explain me what is wrong. Here is the code and configuration.
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE resources PUBLIC "-//GlassFish.org//DTD GlassFish Application Server 3.1 Resource Definitions//EN" "http://glassfish.org/dtds/glassfish-resources_1_5.dtd"> <resources> <jdbc-connection-pool name="java:app/mydb_pool" ....> ... ... </jdbc-connection-pool> <jdbc-resource jndi-name="java:app/mydb" pool-name="java:app/mydb_pool" /> </resources>

@Stateless
@LocalBean
public class EmployeeService {
  public EmployeeService() {
    InitialContext ctx = new InitialContext();
    ctx.lookup("java:app/mydb");
  }
}

Thank you all in advance.

[K. Tsang]

The IntialContext lookup the JNDI name not the pool name. You probably typed wrong in the XML.

[chaitanya karthikk]

Oops!! My bad, corrected it. Its just a typing mistake. But my code is right. I get the error

[chaitanya karthikk]

Previously I was using glassfish 3.0, then I tried to deploy it on 3.1.2. Then I got this error while deploying

remote failure: Error occurred during deployment: Exception while deploying the
app [simple-ejb-project-ear] : Failue while processing glassfish-resources.xml(s
) in the archive  -- Resource [ java:app/jdbc/mydb_pool ] is not allowed to spe
cify the scope [ java:app/ ]. Acceptable scope for this resource is [ java:modul
e/ ]. Please see server.log for more details.
Command deploy failed.

Then I changed the scope to java:module. Even then I am not able to lookup the jndi name from my EJB.

Any ideas?

[chaitanya karthikk]

I tried checking whether the resources are being created are not. So I removed the lookup code from my EJB's constructor and then redeployed the application and listsed the resources using

asadmin --host localhost --user admin --port 20048 list-applications --subcomponents --resources

I was able to see the resources. Somehow the jndi lookup is not working.

Can anyone please tell me what am I missing.

Thank you all in advance.

[chaitanya karthikk]

Holy shit!! Its working if I use @Resources annotation. But with InitialContext its not working.

Any ideas?

[chaitanya karthikk]

Sorry!! I just came to know that only in post construct I can do that. The issue is resolved now