[asookazian]

using MyEclipseIDE 6.0.1-GA-200710.

when I connect to HSQLDB via DB manager view, close connection and then start JBoss and my app deploys, I get the following error. What can I do to prevent this or how to fix? Is this a bug in Eclipse/MyEclipse?? When I shut down and re-launch MyEclipseIDE the error goes away… thx.

2008-02-26 15:18:07,799 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/C:/jboss-4.2.1.GA/server/default/deploy/SecurityAuditPOC.ear -> file:/C:/jboss-4.2.1.GA/server/default/deploy/SecurityAuditPOC.ear
2008-02-26 15:18:07,814 ERROR [org.jboss.deployment.scanner.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@711f26b4[file =C:\jboss-4.2.1.GA\server\default\data\hypersonic\localDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  The process cannot access the file because another process has locked a portion of the file : C:\jboss-4.2.1.GA\server\default\data\hypersonic\localDB.lck
  Depends On Me:
    jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=SecurityAuditPOC.jar,name=Authenticator,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=SecurityAuditPOC.jar,name=SecurityRoleManager,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=jboss-seam.jar,name=TimerServiceDispatcher,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

--- 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@711f26b4[file =C:\jboss-4.2.1.GA\server\default\data\hypersonic\localDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  The process cannot access the file because another process has locked a portion of the file : C:\jboss-4.2.1.GA\server\default\data\hypersonic\localDB.lck
  Depends On Me:
    jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=SecurityAuditPOC.jar,name=Authenticator,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=SecurityAuditPOC.jar,name=SecurityRoleManager,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

ObjectName: jboss.j2ee:ear=SecurityAuditPOC.ear,jar=jboss-seam.jar,name=TimerServiceDispatcher,service=EJB3
  State: FAILED
  Reason: java.lang.NullPointerException

[Loyal Water]

Can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me. I want to know what OS your working on.

[asookazian]

*** Date:
Wednesday, February 27, 2008 8:04:40 AM PST

** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 6.0.1 GA
Build id: 6.0.1-GA-200710

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 6.0.1 GA
Build id: 6.0.1-GA-200710

Eclipse Graphical Editing Framework

Version: 3.3.1.v20070814
Build id: 20070814-1555

Eclipse Platform

Version: 3.3.2.R33x_v20071022-_19UEksF-G8Yc6bUv3Dz
Build id: M20071023-1652

Eclipse RCP

Version: 3.3.2.R33x_r20071022-8y8eE9CEV3FspP8HJrY1M2dS
Build id: M20070921-1145

Eclipse Java Development Tools

Version: 3.3.1.r331_v20070629-7o7jE72EDlXAbqAcnbmyg1rf8RIL
Build id: M20070921-1145

Eclipse Plug-in Development Environment

Version: 3.3.2.R33x_r20071022-7N7M4CYWLBCz-yHkMIuHN
Build id: M20070921-1145

Eclipse Project SDK

Version: 3.3.2.R33x_r20071022-7M7J7C_Mu2gop0b_GAwplOBhyuKO
Build id: M20071023-1652

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Program Files\MyEclipse 6.0\eclipse\eclipse.exe
-name
Eclipse
–launcher.library
C:\Program Files\MyEclipse 6.0\eclipse\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.2.R331_v20071019\eclipse_1021.dll
-startup
C:\Program Files\MyEclipse 6.0\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33x_v20070828.jar
-exitdata
b84_78
-vm
C:\Program Files\MyEclipse 6.0\jre\bin\javaw.exe

[Riyad Kalla]

asookazian,
We had a user report a very similar issue a while back when using the Derby driver. Brian posted a really long workaround here and explanation of the issue:
https://www.genuitec.com/forums/topic/derby-and-plugins/#post-280685

It boils down to the issue of using the embedded DB driver to connect to the DB, actually spins up the DB and won’t let anything else connect. I’m guessing HSQL is the same, you likely want to run it as a service and use the client JDBC driver to connect to it instead of the embedded driver if that is what you are doing.

[Author]

Posts