Hi all, In my EJB i get the databse connection using this code <env-entry> <env-entry-name>poolname</env-entry-name> <env-entry-type>java.lang.String </env-entry-type> <env-entry-value>MyConnectionPool</env-entry-value> </env-entry> and i get the database connection using the code below initCtx = new InitialContext(); String pool = (String) ((Context)initCtx.lookup("java:comp/env/poolname"); DataSource ds = (javax.sql.DataSource)initCtx.lookup(pool); I use the above "ds" to get the database connection Also i read that we can get the connection by using <resource-ref> as shown below <resource-ref> <res-ref-name>MyconnectionPool</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Can any one tell me the diffrence between the 2 approaches. thanks in advance Hari
references is used when an alias name is required to access a particular resource. like the jndi name of an ejb session bean is "ejb/mybean" but the bean has to be accessed as "mysessionbean", in this kind of a situation u give a reference and use the second name to access the bean. likewise for the resource references. env-entry is like having a static variable in the bean class. since having a static variable in a bean is not good practice, u can make use of the env-entry to get a value. hope this helps kiran
Thanks<br /> <br />Kiran <br /> <br />SCEA, SCJP 1.4,<br /> <br />"First they ignore u, then they laugh at u, then they fight u, <br />then u will win<br /> <br />Mahatma Gandhi"