Caused by: javax.naming.NameNotFoundException: pools

[Bin Smith]

I use Glassfish 3.1

I can't anyway deploy my project which I deployed many times before very well...
Everything is preconfigured on Glassfish, including datasource which is in persistence.xml and JavaHelpPool which is used by datasource.
And I see from admin gui that everything is configured well.
The only difference is that I moved to new IDE and I have this stupid error:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: This pool is not registered with the runtime environment : JavaHelpPool
Error Code: 0
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(Entity
ManagerFactoryDelegate.java:188)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:211)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.<init>(PersistenceUnitLoader.java:120)
at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:224)
at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:495)
at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:233)
at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168)
at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:389)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:353)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1085)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291)
at org.glassfish.deployment.autodeploy.AutoOperation.run(AutoOperation.java:145)
at org.glassfish.deployment.autodeploy.AutoDeployer.deploy(AutoDeployer.java:575)
at org.glassfish.deployment.autodeploy.AutoDeployer.deployAll(AutoDeployer.java:461)
at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:389)
at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:380)
at org.glassfish.deployment.autodeploy.AutoDeployService$1.run(AutoDeployService.java:220)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: java.sql.SQLException: This pool is not registered with the runtime environment : JavaHelpPool
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getConnection(ConnectorConnectionPoolAdminServiceImpl.java:1552)
at com.sun.enterprise.connectors.ConnectorRuntime.getConnection(ConnectorRuntime.java:564)
at com.sun.enterprise.connectors.service.ConnectorResourceAdminServiceImpl$MyDataSource.getConnection(ConnectorResourceAdminServiceImpl.java:283)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:132)
... 31 more
Caused by: javax.resource.ResourceException: This pool is not registered with the runtime environment : JavaHelpPool
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:669)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getConnection(ConnectorConnectionPoolAdminServiceImpl.java:1545)
... 34 more
Caused by: com.sun.appserv.connectors.internal.api.ConnectorRuntimeException: This pool is not bound in JNDI : JavaHelpPool
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.obtainManagedConnectionFactory(ConnectorConnectionPoolAdminServiceImpl.java:1087)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:628)
... 35 more
Caused by: javax.naming.NamingException: Lookup failed for '__SYSTEM/pools/JavaHelpPool' in SerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory, java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming} [Root exception is javax.naming.NameNotFoundException: pools]
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:518)
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:455)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at com.sun.appserv.connectors.internal.api.ResourceNamingService.lookup(ResourceNamingService.java:221)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getConnectorConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:870)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.obtainManagedConnectionFactory(ConnectorConnectionPoolAdminServiceImpl.java:1003)
... 36 more
Caused by: javax.naming.NameNotFoundException: pools
at com.sun.enterprise.naming.impl.TransientContext.resolveContext(TransientContext.java:310)
at com.sun.enterprise.naming.impl.TransientContext.lookup(TransientContext.java:218)
at com.sun.enterprise.naming.impl.TransientContext.lookup(TransientContext.java:219)
at com.sun.enterprise.naming.impl.SerialContextProviderImpl.lookup(SerialContextProviderImpl.java:77)
at com.sun.enterprise.naming.impl.LocalSerialContextProviderImpl.lookup(LocalSerialContextProviderImpl.java:119)
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:505)
... 42 more
Can any body suggest something here?

Thank you!

[Bin Smith]

I still have this error!

I put mysql-connector-java-5.1.21-bin inside domain1/lib folder and it did not help!

When I try to ping my pool I get this:

2012-12-18T10:45:36.421+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.util
SEVERE: RAR6025 : Failed to read the connector deployment descriptors : C:\glassfish3\glassfish\bin\lib\install\applications\__ds_jdbc_ra
2012-12-18T10:45:36.421+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.util
SEVERE: com.sun.appserv.connectors.internal.api.ConnectorRuntimeException: Failed to read the connector deployment descriptors
at com.sun.enterprise.connectors.util.ConnectorDDTransformUtils.getConnectorDescriptor(ConnectorDDTransformUtils.java:212)
at com.sun.enterprise.connectors.service.ResourceAdapterAdminServiceImpl.createActiveResourceAdapter(ResourceAdapterAdminServiceImpl.java:339)
at com.sun.enterprise.connectors.ConnectorRuntime.createActiveResourceAdapter(ConnectorRuntime.java:357)
at com.sun.enterprise.connectors.service.ConnectorService.loadDeferredResourceAdapter(ConnectorService.java:183)
at com.sun.enterprise.connectors.service.ConnectorService.loadResourcesAndItsRar(ConnectorService.java:147)
at com.sun.enterprise.connectors.service.ConnectorService.checkAndLoadPool(ConnectorService.java:324)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:632)
at com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:426)
at com.sun.enterprise.connectors.ConnectorRuntime.pingConnectionPool(ConnectorRuntime.java:1086)
at org.glassfish.connectors.admin.cli.PingConnectionPool.execute(PingConnectionPool.java:130)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:348)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1085)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1259)
at org.glassfish.admin.rest.ResourceUtil.runCommand(ResourceUtil.java:214)
at org.glassfish.admin.rest.resources.TemplateExecCommand.executeCommand(TemplateExecCommand.java:127)
at org.glassfish.admin.rest.resources.TemplateCommandGetResource.processGet(TemplateCommandGetResource.java:78)
at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:134)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:134)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)
at com.sun.jersey.server.impl.container.grizzly.GrizzlyContainer._service(GrizzlyContainer.java:182)
at com.sun.jersey.server.impl.container.grizzly.GrizzlyContainer.service(GrizzlyContainer.java:147)
at org.glassfish.admin.rest.adapter.RestAdapter.service(RestAdapter.java:148)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117)
at com.sun.enterprise.v3.services.impl.ContainerMapper$Hk2DispatcherCallable.call(ContainerMapper.java:354)
at com.sun.enterprise.v3.services.im[/code]pl.ContainerMapper.service(ContainerMapper.java:195)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.io.FileNotFoundException: /C:/glassfish3/glassfish/bin/lib/install/applications/__ds_jdbc_ra
at com.sun.enterprise.deploy.shared.FileArchive.open(FileArchive.java:135)
at com.sun.enterprise.connectors.util.ConnectorDDTransformUtils.getConnectorDescriptor(ConnectorDDTransformUtils.java:191)
... 57 more
2012-12-18T10:45:36.421+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service
SEVERE: RAR8061: failed to load resource-adapter-config or RA [ __ds_jdbc_ra ], com.sun.appserv.connectors.internal.api.ConnectorRuntimeException: Failed to read the connector deployment descriptors
2012-12-18T10:45:36.421+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service
WARNING: RAR7010: Pool not reachable.

Thank you!

[Bin Smith]

After I manually added __ds_jdbc_ra.jar I received another exception:

2012-12-18T11:58:48.375+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.jms.util
WARNING: jmsra.upgrade_check_failed
2012-12-18T11:58:48.375+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service
SEVERE: RAR8061: failed to load resource-adapter-config or RA [ __ds_jdbc_ra ], com.sun.appserv.connectors.internal.api.ConnectorRuntimeException: Unable to get active RA for module __ds_jdbc_ra
2012-12-18T11:58:48.375+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service
WARNING: RAR7010: Pool not reachable.
2012-12-18T11:58:48.375+0200 javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service
WARNING: RAR8054: Exception while creating an unpooled [test] connection for pool [ JavaHelpPool ], This pool is not registered with the runtime environment : JavaHelpPool
2012-12-18T11:58:48.390+0200 org.glassfish.admingui
SEVERE: RestResponse.getResponse() gives FAILURE. endpoint = 'http://localhost:4848/management/domain/resources/ping-connection-pool.json'; attrs = '{id=JavaHelpPool}'


I am using Glassfish 3.1.2.2 (build 5) !

[Bin Smith]

After all in a little fantastic way (probably __ds_jdbc_ra.jar helped) my connection pool was pinged successfully.

Then I managed to deploy my webapp successfully via command line but not from myeclipse.

Then I received usual errors which are beyound this topic.

[Kavita Kothari]

I am facing similar issue. Adding the mentioned jar did not help.

I even tried using 3.1.2 version of embeddable glassfish but no luck.

Any pointers would be really appreciated.

[Bin Smith]

As I remember it was needed to reinstall Glassfish.
But maybe restart will help you.

[Bin Smith]

I want to share my own experience.

At first I've been studying actively EJB, JSF, JPA as JavaEE technologies.

But when I looked at technologies which are most of all asked to have a job as JavaEE developer, I discovered that things like EJB,JSF are really not
in list of main requirenments of IT companies here in Lviv.

Instead they need you to know Spring first of all, SpringMVC, Struts, Hibernate, JSF, Servlets and JSP.

So, be careful when you choose JavaEE technology to learn amd better consult some experienced developers at your location.

[Kalpesh Soni]

This is how I solved it

I use createEjbContainer api without passing properties

look for your temp folder, it creates a glassfish 3 temp domain there

checkin that folder structure under src/test/resources/gfv3

this is what i have

src\test\resources\gfv3
src\test\resources\META-INF
src\test\resources\gfv3\domains
src\test\resources\gfv3\lib
src\test\resources\gfv3\domains\domain1
src\test\resources\gfv3\domains\domain1\config
src\test\resources\gfv3\domains\domain1\config\admin-keyfile
src\test\resources\gfv3\domains\domain1\config\cacerts.jks
src\test\resources\gfv3\domains\domain1\config\cadump.txt
src\test\resources\gfv3\domains\domain1\config\domain.xml
src\test\resources\gfv3\domains\domain1\config\keyfile
src\test\resources\gfv3\domains\domain1\config\keystore.jks
src\test\resources\gfv3\domains\domain1\config\login.conf
src\test\resources\gfv3\domains\domain1\config\server.policy
src\test\resources\gfv3\lib\install
src\test\resources\gfv3\lib\install\applications
src\test\resources\gfv3\lib\install\applications\jaxr-ra
src\test\resources\gfv3\lib\install\applications\jmsra
src\test\resources\gfv3\lib\install\applications\__cp_jdbc_ra
src\test\resources\gfv3\lib\install\applications\__dm_jdbc_ra
src\test\resources\gfv3\lib\install\applications\__ds_jdbc_ra
src\test\resources\gfv3\lib\install\applications\__xa_jdbc_ra
src\test\resources\gfv3\lib\install\applications\jaxr-ra\jaxr-ra.jar
src\test\resources\gfv3\lib\install\applications\jmsra\fscontext.jar
src\test\resources\gfv3\lib\install\applications\jmsra\imqbroker.jar
src\test\resources\gfv3\lib\install\applications\jmsra\imqjmsbridge.jar
src\test\resources\gfv3\lib\install\applications\jmsra\imqjmsra.jar
src\test\resources\gfv3\lib\install\applications\jmsra\imqjmx.jar
src\test\resources\gfv3\lib\install\applications\jmsra\imqstomp.jar
src\test\resources\gfv3\lib\install\applications\__cp_jdbc_ra\__cp_jdbc_ra.jar
src\test\resources\gfv3\lib\install\applications\__dm_jdbc_ra\__dm_jdbc_ra.jar
src\test\resources\gfv3\lib\install\applications\__ds_jdbc_ra\__ds_jdbc_ra.jar
src\test\resources\gfv3\lib\install\applications\__xa_jdbc_ra\__xa_jdbc_ra.jar
src\test\resources\META-INF\persistence.xml

Then you can edit domain.xml add datasources there

then use code to test ejb

I used glassfish v3, maven, oracle db

Map<String, Object> p = new HashMap<String, Object>();
//        p.put(EJBContainer.APP_NAME, "TON_APP_NAME");

        File[] modules = {
            new File("target/test-classes"),
            new File("target/classes")

        };
        p.put(EJBContainer.MODULES, modules);
        p.put("org.glassfish.ejb.embedded.glassfish.installation.root", "src/test/resources/gfv3");

        ejbContainer = EJBContainer.createEJBContainer(p);
        ctx = ejbContainer.getContext();
        ejbFacade = (AllocnGrpFacade) ctx.lookup("java:global/classes/AllocnGrpFacade");

and test

@Test
    public void testFindAll() throws Exception {
        final List<AllocnGrp> all = ejbFacade.findAll();
        assertNotNull(all);
        for (AllocnGrp allocationGroup : all) {
            System.out.println(allocationGroup);
        }
    }

this is how the config looks

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="ACP-warPU" transaction-type="JTA"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <jta-data-source>jdbc/acp</jta-data-source> <exclude-unlisted-classes>false</exclude-unlisted-classes> <shared-cache-mode>ALL</shared-cache-mode> <properties> <property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.oracle.Oracle11Platform"/> <property name="eclipselink.logging.level" value="FINE"/> <property name="eclipselink.logging.timestamp" value="true"/> <property name="eclipselink.logging.thread" value="true"/> <property name="eclipselink.logging.logger" value="ServerLogger"/> </properties> </persistence-unit> </persistence>

good luck