Problem with EJB lookup on GlassFish 2

[sanchit dua]

I'm trying to do an EJB lookup on GlassFish vr2 for a class like this: .

InitialContext ctx = new InitialContext();
			Context envCtx = (Context) ctx.lookup("java:comp/env");
			ds = (DataSource) envCtx.lookup("jdbc/TestDB");
			

And it gives Exception while I'm trying to look up from the hibernate as:

<session-factory>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.datasource">jdbc/TestDB</property>
        <property name="connection.username">root</property>
        <property name="connection.password">pwd</property>
        <property name="jndi.url">jdbc:mysql://3306/sam</property>
    <property name="show_sql">true</property>
    <property name="hibernate.hbm2ddl.auto">create</property>
    <mapping resource="hibernate.mapping.xml"/>
    </session-factory>

The connection pool made at glassfish site is giving me the ping successful.
The Exceptio I get is :

Errors occurred: com.sun.gjc.spi.jdbc40.DataSource40 cannot be cast to javax.naming.Context

Stack Trace java.lang.ClassCastException: com.sun.gjc.spi.jdbc40.DataSource40 cannot be cast to javax.naming.Context 
at command.CommandExecutor.getDataSource(CommandExecutor.java:48) at command.CommandExecutor.(CommandExecutor.java:39) 
at command.CommandExecutor.getInstance(CommandExecutor.java:32) 
at actions.CreateCustomerAction.performAction(CreateCustomerAction.java:42) 
at actions.AbstractAction.execute(AbstractAction.java:28) 
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) 
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) 
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) 
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:705) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:818) 
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:398) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277) 
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:258) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:189) 
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611) 
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) 
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:81) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:193) 
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611) 
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) 
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:558) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1067) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611)
 at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:558) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1067) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:255)
 at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:618) 
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:549) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:790) 
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:326) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:248) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:199) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252) at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:93)

Thanks!

[E Armitage]

The exception says you are trying to cast a datasource to a Context.
You probably just need to do

InitialContext ctx = new InitialContext();
ds = (DataSource) envCtx.lookup("java:comp/env/jdbc/TestDB");

[sanchit dua]

The connection pooling is done I think...
But I'm getting an exception like this:

Errors occurred: Could not find datasource

Stack Trace org.hibernate.HibernateException: Could not find datasource at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:48) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:80) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:362) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004) at command.CommandExecutor.getSessionFactory(CommandExecutor.java:66) at command.CommandExecutor.executeHibernateCommand(CommandExecutor.java:95) at actions.CreateCustomerAction.performAction(CreateCustomerAction.java:42) at actions.AbstractAction.execute(AbstractAction.java:28) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context at org.apache.naming.NamingContext.lookup(NamingContext.java:770) at org.apache.naming.NamingContext.lookup(NamingContext.java:153) at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137) at javax.naming.InitialContext.lookup(InitialContext.java:392) at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:44) ... 29 more

Thanks!

[sanchit dua]

I have made some changes in this.
But I'm unable to lookup the resources from connection pool. And I'm getting exception as:

Errors occurred: TestDB not found
Stack Trace javax.naming.NameNotFoundException: TestDB not found at com.sun.enterprise.naming.TransientContext.doLookup(TransientContext.java:203) at 
com.sun.enterprise.naming.TransientContext.lookup(TransientContext.java:175) at 
com.sun.enterprise.naming.TransientContext.lookup(TransientContext.java:179) at 
com.sun.enterprise.naming.SerialContextProviderImpl.lookup(SerialContextProviderImpl.java:61) at 
com.sun.enterprise.naming.LocalSerialContextProviderImpl.lookup(LocalSerialContextProviderImpl.java:98) at 
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:315) at javax.naming.InitialContext.lookup(InitialContext.java:392) at 
command.CommandExecutor.getDataSource(CommandExecutor.java:49) at command.CommandExecutor.(CommandExecutor.java:39) at 
command.CommandExecutor.getInstance(CommandExecutor.java:32) at actions.CreateCustomerAction.performAction(CreateCustomerAction.java:38) at 
actions.AbstractAction.execute(AbstractAction.java:28) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at

org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at 
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:705) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:818) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:398) at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277) at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:258) at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:189) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:81) at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:193) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:558) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1067) at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:611) at 
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:558) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1067) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:255) at 
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:618) at 
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:549) at 
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:790) at 
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:326) at 
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:248) at 
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:199) at 
com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252) at 
com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:93

I'm trying to do lookup with the following code of bussiness bean:

public DataSource getDataSource() throws NamingException {
		
		if (ds == null) {
			
			InitialContext ctx = new InitialContext();
			//Context envCtx = (Context) ctx.lookup("java:comp/env");
			ds = (DataSource) ctx.lookup("jdbc/TestDB");
			
		}
		
		return ds;
	}

I have set the connection pool name to be jdbc/TestDB and I have done ping successfully using mysql database.
Even after I'm getting this exception. !!

Thanks!

[sanchit dua]

the problem is resolved by renaming java/TestDB with TestDB.
Thanks....!