look up datasource from session bean

[Anuj Troy]

hii how can we lookup dataSource(to accessa db connection pool) from a session bean?

regards
anuj

[Keerthi P]

Context context = new InitialContext();
Object namedObject = context.lookup("<data-source-jndi-name>");
javax.sql.DataSource dataSource = (javax.sql.DataSource)namedObject;
java.sql.Connection con = dataSource.getConnection();
 
doCRUD(con); // perform any database operations.

[Anuj Troy]

hii Keerthi

thanks a lot for the help i tried it today and it worked.


regards
anuj