myrnap wrote:
Nat Gross wrote:

Hi;
Although I have no problems connecting to my new Derby, via jdbc, I cannot get a 'ping' when setting up a j2ee pool and jndi connector in the Sun app server. I followed the instructions on the java.net blog,for embedded, the classpath is set, have tried various javax connectors, the xa version and non xa version, to no avail.
Your help will be appreciated.
Thanks
-nat

Nat,

What's the error you see?
What's in the server.log?
Does a derby.log get created? If so, is it where you expect it to be?

Myrna

Progress.... For some reason the sdk's bin directory wasn't in the PATH. I didn't dream that the gui admin uses the cmdline stuff behind the scenes. Anyhow, now there is a new error when pinging.
The first exception sais that it couldn't open the database and the next exception has the details why. But the next exception list some gui framework error, for the ping button. Here it is.:

INFO
javax.enterprise.system.tools.admin
_ThreadID=12;
6149
com.sun.enterprise.tools.guiframework.exception.FrameworkError
Complete Message
 com.sun.enterprise.tools.guiframework.exception.FrameworkException: java.lang.reflect.InvocationTargetException on 'class com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean'.  This occurred while attempting to process a 'command' event for 'pingButton'.
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(DescriptorViewHelper.java:279)
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewBeanBase.execute(DescriptorViewBeanBase.java:187)
	at com.iplanet.jato.view.RequestHandlingViewBase.handleRequest(RequestHandlingViewBase.java:308)
	at com.iplanet.jato.view.ViewBeanBase.dispatchInvocation(ViewBeanBase.java:822)
	at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.java:760)
	at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.java:780)
	at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandler(ViewBeanBase.java:590)
	at com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase.java:951)
	at com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.java:622)
	at com.sun.enterprise.tools.guiframework.view.BaseServlet.processRequest(BaseServlet.java:186)
	at com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:480)
	at com.sun.enterprise.tools.admingui.AdminGUIServlet.doPost(AdminGUIServlet.java:65)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:768)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
	at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:246)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:268)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:236)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:141)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:109)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:522)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:168)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:109)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:536)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:522)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:109)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:133)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:539)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at com.sun.enterprise.webservice.EjbWebServiceValve.invoke(EjbWebServiceValve.java:134)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at com.sun.enterprise.security.web.SingleSignOn.invoke(SingleSignOn.java:305)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at com.sun.enterprise.web.VirtualServerValve.invoke(VirtualServerValve.java:209)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:522)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:114)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:109)
	at com.sun.enterprise.web.VirtualServerMappingValve.invoke(VirtualServerMappingValve.java:166)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:107)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:522)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:936)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:165)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:683)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:604)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:542)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:647)
	at java.lang.Thread.run(Thread.java:534)
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: java.lang.reflect.InvocationTargetException on 'class com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean'.  This occurred while attempting to process a 'command' event for 'pingButton'.
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(DescriptorViewHelper.java:735)
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(DescriptorViewHelper.java:250)
	... 60 more
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandler(DescriptorViewHelper.java:785)
	at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(DescriptorViewHelper.java:731)
	... 61 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
Target exception message: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHandlers.java:91)
	... 66 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
Target exception message: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:38)
	at com.sun.enterprise.tools.admingui.util.MBeanUtil.invokeMBean(MBeanUtil.java:140)
	at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHandlers.java:83)
	... 66 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
Target exception message: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:112)
	at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:35)
	... 68 more
Caused by: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
Target exception message: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.enterprise.admin.MBeanHelper.extractAndWrapTargetException(MBeanHelper.java:353)
	at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:302)
	at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:221)
	at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:228)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:823)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:792)
	at sun.reflect.GeneratedMethodAccessor102.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:54)
	at $Proxy1.invoke(Unknown Source)
	at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:282)
	at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:105)
	... 69 more
Caused by: javax.resource.ResourceException: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:605)
	at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:520)
	at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:1805)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:287)
	at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:280)
	... 80 more
Caused by: javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:100)
	at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:597)
	... 88 more
Caused by: SQL Exception: Failed to start database 'q:\data\servers\Derby\db1', see the next exception for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java)
	at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java)
	at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:91)
	... 89 more
      





Thanks;
-nat