db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nat Gross <natgross.rentalsyst...@verizon.net>
Subject Re: Sun 8.0.1 Appserver pooling
Date Mon, 27 Dec 2004 17:03:07 GMT
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.:

Log Level:
	
INFO
Logger:
	
javax.enterprise.system.tools.admin
Name-Value Pairs:
	
_ThreadID=12;
Record Number:
	
6149
Message ID:
	
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

Mime
View raw message