users@glassfish.java.net

glassfishv 3.1 + openjdk + create jdbc connection pool

From: <forums_at_java.net>
Date: Mon, 23 May 2011 04:36:16 -0500 (CDT)

 I try to run glassfish with openjdk.

When I try to create jdbc connection pool I got the following error in a
server.log.

Command itself returns succesfully but ping fails with the error. See below
my server.log.

I located mysql connector into domains/domain1/lib/ext.

I used this command to create jdbc connection pool

./asadmin create-jdbc-connection-pool --datasourceclassname
com.mysql.jdbc.jdbc2.optional.MysqlDataSource --restype
javax.sql.ConnectionPoolDataSource --property
user=root:password=root:DatabaseName=calc_sample:ServerName=localhost:port=3306:URL=jdbc\\:mysql\\://localhost\\:3306/calc_sample
--ping true calc_sample

/*********************************************************************************************************************************************************************************************************

                                                   
                                                   
   server.log

/*********************************************************************************************************************************************************************************************************

-Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory
-DANTLR_USE_DIRECT_CLASS_LOADING=true -Dosgi.shell.telnet.maxconn=1
-Djava.security.auth.login.config=/mnt/sda4/apps/domains/domain1/config/login.conf
-Dfelix.fileinstall.dir=/usr/local/glassfish3/glassfish/modules/autostart/
-Dosgi.shell.telnet.ip=127.0.0.1
-Djavax.net.ssl.keyStore=/mnt/sda4/apps/domains/domain1/config/keystore.jks
-Dgosh.args=--nointeractive
-Dcom.sun.aas.installRoot=/usr/local/glassfish3/glassfish
-Djava.endorsed.dirs=/usr/local/glassfish3/glassfish/modules/endorsed:/usr/local/glassfish3/glassfish/lib/endorsed
-Djava.security.policy=/mnt/sda4/apps/domains/domain1/config/server.policy
-Djavax.net.ssl.trustStore=/mnt/sda4/apps/domains/domain1/config/cacerts.jks
-Dfelix.fileinstall.bundles.new.start=true
-Djdbc.drivers=org.apache.derby.jdbc.ClientDriver
-Dfelix.fileinstall.log.level=2
-Dcom.sun.enterprise.security.httpsOutboundKeyAlias=s1as
-Djava.ext.dirs=/usr/local/ibm-java-ppc-60/lib/ext:/usr/local/ibm-java-ppc-60/jre/lib/ext:/mnt/sda4/apps/domains/domain1/lib/ext
-Djava.library.path=/usr/local/glassfish3/glassfish/lib:/usr/local/ibm-java-ppc-60/jre/lib/ppc:/usr/lib
com.sun.enterprise.glassfish.bootstrap.ASMain -asadmin-classpath
/usr/local/glassfish3/glassfish/modules/admin-cli.jar -verbose false
-asadmin-classname com.sun.enterprise.admin.cli.AsadminMain -debug false
-type DAS -asadmin-args
--host,,,localhost,,,--port,,,4848,,,--secure=false,,,--terse=false,,,--echo=false,,,--interactive=true,,,start-domain,,,--verbose=false,,,--debug=false,,,--domaindir,,,/mnt/sda4/apps/domains,,,domain1
-domainname domain1 -domaindir /mnt/sda4/apps/domains/domain1 -instancename
server -read-stdin true -upgrade false May 23, 2011 8:56:14 AM
com.sun.enterprise.admin.launcher.GFLauncherLogger info INFO: Successfully
launched in 73 msec.
[#|2011-05-23T08:57:25.094+0000|INFO|glassfish3.1|null|_ThreadID=1;_ThreadName=Thread-8;|Running
GlassFish Version: GlassFish Server Open Source Edition 3.1 (build 43)|#]  
[#|2011-05-23T08:57:25.663+0000|INFO|glassfish3.1|org.glassfish.ha.store.spi.BackingStoreFactoryRegistry|_ThreadID=0;_ThreadName=Thread-8;|Registered
org.glassfish.ha.store.adapter.cache.ShoalBackingStoreProxy for
persistence-type = replicated in BackingStoreFactoryRegistry|#]  
[#|2011-05-23T08:57:29.529+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.services.impl|_ThreadID=26;_ThreadName=Thread-8;|Grizzly
Framework 1.9.31 started in: 1251ms - bound to [0.0.0.0:8080]|#]  
[#|2011-05-23T08:57:29.523+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.services.impl|_ThreadID=25;_ThreadName=Thread-8;|Grizzly
Framework 1.9.31 started in: 526ms - bound to [0.0.0.0:8181]|#]  
[#|2011-05-23T08:57:29.801+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.services.impl|_ThreadID=30;_ThreadName=Thread-8;|Grizzly
Framework 1.9.31 started in: 130ms - bound to [0.0.0.0:4848]|#]  
[#|2011-05-23T08:57:30.178+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.services.impl|_ThreadID=33;_ThreadName=Thread-8;|Grizzly
Framework 1.9.31 started in: 324ms - bound to [0.0.0.0:3700]|#]  
[#|2011-05-23T08:57:30.294+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.services.impl|_ThreadID=36;_ThreadName=Thread-8;|Grizzly
Framework 1.9.31 started in: 52ms - bound to [0.0.0.0:7676]|#]  
[#|2011-05-23T08:57:32.188+0000|INFO|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=1;_ThreadName=Thread-8;|GlassFish
Server Open Source Edition 3.1 (43) startup time : Felix (59,636ms), startup
services(14,690ms), total(74,326ms)|#]  
[#|2011-05-23T08:57:38.934+0000|INFO|glassfish3.1|javax.enterprise.system.tools.admin.org.glassfish.server|_ThreadID=46;_ThreadName=Thread-8;|JMXStartupService:
Started JMXConnector, JMXService URL =
service:jmx:rmi://localhost:8686/jndi/rmi://localhost:8686/jmxrmi|#]  
[#|2011-05-23T09:00:10.167+0000|INFO|glassfish3.1|javax.enterprise.system.tools.admin.com.sun.enterprise.container.common|_ThreadID=60;_ThreadName=Thread-8;|User
[] from host localhost does not have administration access|#]  
[#|2011-05-23T09:00:11.217+0000|INFO|glassfish3.1|javax.enterprise.system.tools.admin.com.sun.enterprise.container.common|_ThreadID=62;_ThreadName=Thread-8;|User
[] from host localhost does not have administration access|#]  
[#|2011-05-23T09:00:22.143+0000|INFO|glassfish3.1|org.hibernate.validator.util.Version|_ThreadID=9;_ThreadName=Thread-8;|Hibernate
Validator 4.1.0.Final|#]  
[#|2011-05-23T09:00:22.227+0000|INFO|glassfish3.1|org.hibernate.validator.engine.resolver.DefaultTraversableResolver|_ThreadID=9;_ThreadName=Thread-8;|Instantiated
an instance of
org.hibernate.validator.engine.resolver.JPATraversableResolver.|#]  
[#|2011-05-23T09:00:27.847+0000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.util|_ThreadID=64;_ThreadName=Thread-8;|RAR8068:
Using default datasource : __ds_jdbc_ra for pool : calc_sample|#]  
[#|2011-05-23T09:00:36.886+0000|SEVERE|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=64;_ThreadName=Thread-8;|RAR6035
: Resource adapter start failed : {0} javax.validation.ValidationException:
Unable to find a default provider         at
javax.validation.Validation$GenericBootstrapImpl.configure(Validation.java:264)
        at
com.sun.enterprise.connectors.util.ConnectorJavaBeanValidator.getBeanValidator(ConnectorJavaBeanValidator.java:109)
        at
com.sun.enterprise.connectors.util.ConnectorJavaBeanValidator.validateJavaBean(ConnectorJavaBeanValidator.java:64)
        at
com.sun.enterprise.connectors.ActiveOutboundResourceAdapter.init(ActiveOutboundResourceAdapter.java:118)
        at
com.sun.enterprise.connectors.ActiveRAFactory.instantiateActiveResourceAdapter(ActiveRAFactory.java:135)
        at
com.sun.enterprise.connectors.ActiveRAFactory.createActiveResourceAdapter(ActiveRAFactory.java:106)
        at
com.sun.enterprise.connectors.service.ResourceAdapterAdminServiceImpl.createActiveResourceAdapter(ResourceAdapterAdminServiceImpl.java:212)
        at
com.sun.enterprise.connectors.service.ResourceAdapterAdminServiceImpl.createActiveResourceAdapter(ResourceAdapterAdminServiceImpl.java:348)
        at
com.sun.enterprise.connectors.ConnectorRuntime.createActiveResourceAdapter(ConnectorRuntime.java:356)
        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:634)
        at
com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:427)
        at
com.sun.enterprise.connectors.ConnectorRuntime.pingConnectionPool(ConnectorRuntime.java:1110)
        at
org.glassfish.connectors.admin.cli.PingConnectionPool.execute(PingConnectionPool.java:130)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:360)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1235)
        at
org.glassfish.jdbc.admin.cli.CreateJdbcConnectionPool.execute(CreateJdbcConnectionPool.java:276)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:355)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
        at
com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1235)
        at
com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:465)  
      at
com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:222)    
    at
com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:168)  
      at
com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117)  
      at
com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:234)
        at
com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)  
      at
com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)      
  at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)  
      at
com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
        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:736) |#]  
[#|2011-05-23T09:00:36.930+0000|SEVERE|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service|_ThreadID=64;_ThreadName=Thread-8;|RAR8061:
failed to load resource-adapter-config or RA [ __ds_jdbc_ra ],
com.sun.appserv.connectors.internal.api.ConnectorRuntimeException: Failed to
start resource adapter : Unable to find a default provider|#]  
[#|2011-05-23T09:00:36.939+0000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service|_ThreadID=64;_ThreadName=Thread-8;|RAR7010:
Pool not reachable. |#]  
[#|2011-05-23T09:00:36.948+0000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service|_ThreadID=64;_ThreadName=Thread-8;|RAR8054:
Exception while creating an unpooled [test] connection for pool [ calc_sample
], This pool is not registered with the runtime environment : calc_sample|#]
           


--
[Message sent by forum member 'daniil_k']
View Post: http://forums.java.net/node/805064