[The Lizzard's corner] - Hypersonic - "database is already in use"
by jbossadrian
Hello all,
We are experiencing a problem that we did not expect with migrating our application over to JBoss 4.2.0 CP1. We are able to run it locally within our development desktops, but cannot get it to start properly on the Linux (Redhat) machines. Below is a long snip of the problem (this one comes from just trying to launch the 'all' configuration). Anyone have any ideas as to what could be causing this?
Thanks in advance for your valuable time and support.
10:49:06,403 WARN [ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@3862fa86[file =/apps/xmladm/jboss-as-4.2.0/server/all/data/hypersonic/localDB.lck, exists=true, locked=false, valid=false, fl =null]:
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:768)
at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:618)
at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:564)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
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:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy51.start(Unknown Source)
at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy9.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
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:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:595)
10:49:06,525 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
10:49:06,570 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
10:49:06,745 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@3862fa86[file =/apps/xmladm/jboss-as-4.2.0/server/all/data/hypersonic/localDB.lck, exists=true, locked=false, valid=false, fl =null]:
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=DefaultDS
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@3862fa86[file =/apps/xmladm/jboss-as-4.2.0/server/all/data/hypersonic/localDB.lck, exists=true, locked=false, valid=false, fl =null]:
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=DefaultDS
10:49:06,809 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
10:49:06,828 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
10:49:06,839 INFO [Server] JBoss (MX MicroKernel) [4.2.0.GA_CP01 (build: SVNTag=JBPAPP_4_2_0_GA_CP01 date=200709131706)] Started in 26s:973ms
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134007#4134007
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134007
18 years, 1 month
[JBoss Portal] - Re: Missing windowId for portlets events test
by rpa_rio
I wrote two pages publisher-view.jsp and listener-view.jsp, in publisher-view.jsp I used portlet tags to generate the actionURL, exactly like we have below:
| <%@ page contentType="text/html"%>
| <%@ taglib uri="http://java.sun.com/portlet" prefix="portlet" %>
| <portlet:defineObjects />
| <portlet:actionURL var="submitUrl" portletMode="view" />
| <div>
| <br />
| <br />
| <center>
| <form action="<%=submitUrl%>" method="post">
| <label for="input">Type your text:</label>
| <input type="text" id="input" name="input" value="" />
| <input type="submit" value="Send" />
| </form>
| </center>
| </div>
|
When the submit button is clicked the processAction on PublisherPortlet must be invoked and then the event is set:
| package br.eti.faces.portlet.publisher;
|
| import java.io.IOException;
|
| import javax.portlet.ActionRequest;
| import javax.portlet.ActionResponse;
| import javax.portlet.GenericPortlet;
| import javax.portlet.PortletContext;
| import javax.portlet.PortletException;
| import javax.portlet.PortletRequestDispatcher;
| import javax.portlet.RenderRequest;
| import javax.portlet.RenderResponse;
|
| import br.eti.faces.portlet.events.Literal;
|
| public class PublisherPortlet extends GenericPortlet {
|
| @Override
| protected void doView(RenderRequest renderRequest,
| RenderResponse renderResponse) throws PortletException, IOException {
|
| renderResponse.setContentType("text/html");
|
| PortletContext ctx = getPortletContext();
| PortletRequestDispatcher dispatcher = ctx
| .getRequestDispatcher("/publisher-view.jsp");
|
| dispatcher.include(renderRequest, renderResponse);
| }
|
| @Override
| public void processAction(ActionRequest actionRequest,
| ActionResponse actionResponse) throws PortletException, IOException {
| String value = actionRequest.getParameter("input");
| actionResponse.setEvent(Literal.QNAME, new Literal(value));
| }
|
| }
|
I defined this class as my event class:
| package br.eti.faces.portlet.events;
|
| import java.io.Serializable;
|
| import javax.xml.bind.annotation.XmlRootElement;
| import javax.xml.namespace.QName;
|
| @XmlRootElement
| public class Literal implements Serializable {
|
| public static final QName QNAME = new QName("urn:jboss:portal:samples:event" , "Literal");
|
| private String data;
|
| public Literal(String data) {
| this.data = data;
| }
|
| public String getData() {
| return data;
| }
|
| public void setData(String data) {
| this.data = data;
| }
| }
|
Finally, I registered both (porlet and event) on portlet.xml:
| <?xml version="1.0" encoding="UTF-8"?>
| <portlet-app
| xmlns="http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd"
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd"
| id="portlet-event" version="2.0">
|
| <event-definition>
| <qname xmlns:jbp="urn:jboss:portal:samples:event">jbp:Literal</qname>
| <value-type>br.eti.faces.portlet.events.Literal</value-type>
| </event-definition>
|
| <portlet id="publisher">
| <init-param>
| <name>default-view</name>
| <value>/publisher-view.jsp</value>
| </init-param>
| <init-param>
| <name>ViewPage</name>
| <value>/publisher-view.jsp</value>
| </init-param>
| <description>Event Publisher JSP Portlet</description>
| <portlet-name>publisher</portlet-name>
| <display-name>Event Publisher JSP Portlet</display-name>
| <portlet-class>
| br.eti.faces.portlet.publisher.PublisherPortlet
| </portlet-class>
| <supports>
| <mime-type>text/html</mime-type>
| <portlet-mode>VIEW</portlet-mode>
| </supports>
| <portlet-info>
| <title>Event Publisher JSP Portlet</title>
| <short-title>Event Publisher JSP Portlet</short-title>
| </portlet-info>
|
| <supported-publishing-event>
| <qname xmlns:jbp="urn:jboss:portal:samples:event">jbp:Literal</qname>
| </supported-publishing-event>
| </portlet>
|
| <portlet id="listener">
| <init-param>
| <name>default-view</name>
| <value>/listener-view.jsp</value>
| </init-param>
| <init-param>
| <name>ViewPage</name>
| <value>/listener-view.jsp</value>
| </init-param>
| <description>Event Listener JSP Portlet</description>
| <portlet-name>listener</portlet-name>
| <display-name>Event Listener JSP Portlet</display-name>
| <portlet-class>
| br.eti.faces.portlet.listener.ListenerPortlet
| </portlet-class>
| <supports>
| <mime-type>text/html</mime-type>
| <portlet-mode>VIEW</portlet-mode>
| </supports>
| <portlet-info>
| <title>Event Listener JSP Portlet</title>
| <short-title>Event Listener JSP Portlet</short-title>
| </portlet-info>
|
| <supported-processing-event>
| <qname xmlns:jbp="urn:jboss:portal:samples:event">jbp:Literal</qname>
| </supported-processing-event>
| </portlet>
| </portlet-app>
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134002#4134002
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134002
18 years, 1 month