Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Problem encountered when building connection to derby 10.1

1 view

Skip to first unread message

daili

unread,

Apr 20, 2007, 3:57:30 AM4/20/07

I can open the database choosing derby 10.1, however when in WAS server 6, it always says

"Test connection failed for data source Derby JDBC Driver DataSource on server server1 at node wpsiut with the following exception: java.lang.Exception: java.sql.SQLException: Failed to start database 'D:\TEMP2\cloudscape_derby\dashboarddb', see the next exception for details.DSRA0010E: SQL ?? = XJ040????? = 40,000. View JVM logs for further details.
"
Could you pls tell me how to resolved it? Here only was is started, not portal. I don't think there are any other applications using this db, I copied it to some other places, failed too.

Thanks

The log regarding it is

"[07-4-20 15:52:46:891 CST] 00000026 SystemErr R java.lang.Exception: java.sql.SQLException: Failed to start database 'D:\TEMP2\cloudscape_derby\dashboarddb', see the next exception for details.DSRA0010E: SQL ?? = XJ040????? = 40,000
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2243)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:528)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:456)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1366)
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)
at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:990)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:906)
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:278)
at com.ibm.ws.console.resources.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:290)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:322)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1070)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:273)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:319)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:306)
at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:185)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.handleAsyncComplete(SSLReadServiceContext.java:505)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:467)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:305)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:107)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.handleAsyncComplete(SSLReadServiceContext.java:505)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:467)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:305)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:107)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1698)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2243)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:528)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:456)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1366)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:990)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:906)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:278)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.console.resources.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:290)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:322)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1070)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:273)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:319)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:306)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:185)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
[07-4-20 15:52:46:891 CST] 00000026 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.handleAsyncComplete(SSLReadServiceContext.java:505)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:467)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:305)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:107)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.handleAsyncComplete(SSLReadServiceContext.java:505)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:467)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext.read(SSLReadServiceContext.java:305)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:107)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1698)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
[07-4-20 15:52:46:906 CST] 00000026 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
"

0 new messages