Posted on 2010-08-26
Last Modified: 2013-12-02
HI Experts

When i start up my local environment I get the following Error.
-- MBeans waiting for other MBeans ---

ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo

  State: FAILED

  Reason: org.jboss.deployment.DeploymentException: Error while checking if table aleady exists HILOSEQUENCES; - nested throwable: (java.sql.SQLException: Table not found: SYSTEM_TABLES in statement [SELECT * FROM SYSTEM_TABLES])

  I Depend On:



ObjectName: jboss.web.deployment:id=-136325042,war=mmticket.war

  State: FAILED

  Reason: org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.0.2/server/default/tmp/deploy/tmp350937522146439789DealApp.ear-contents/mmticket-exp.war/ deployment failed


ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo

  State: FAILED

  Reason: org.jboss.deployment.DeploymentException: Error while checking if table aleady exists HILOSEQUENCES; - nested throwable: (java.sql.SQLException: Table not found: SYSTEM_TABLES in statement [SELECT * FROM SYSTEM_TABLES])

  I Depend On:



Open in new window

Question by:abooysen2
  • 5
  • 2
LVL 40

Expert Comment

ID: 33530435
can you post the data source file?
check this for reference

Author Comment

ID: 33531023
This ds file name is hsqldb-ds.xml and I am using mmticket-ds.xml
<?xml version="1.0" encoding="UTF-8"?>

<!-- The Hypersonic embedded database JCA connection factory config

$Id: hsqldb-ds.xml,v 1.15 2004/09/15 14:37:40 loubyansky Exp $ -->



      <!-- The jndi name of the DataSource, it is prefixed with java:/ -->

      <!-- Datasources are not available outside the virtual machine -->


      <!-- for tcp connection, allowing other processes to use the hsqldb

      database. This requires the org.jboss.jdbc.HypersonicDatabase mbean.   -->


      <!-- for totally in-memory db, not saved when jboss stops. 

      The org.jboss.jdbc.HypersonicDatabase mbean necessary



      <!-- for in-process persistent db, saved when jboss stops. The

      org.jboss.jdbc.HypersonicDatabase mbean is necessary for properly db shutdown



      <!-- The driver class -->


      <!-- The login and password -->



      <!--example of how to specify class that determines if exception means connection should be destroyed-->


      <!-- this will be run before a managed connection is removed from the pool for use by a client-->

      <!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> -->

      <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->


      <!-- The maximum connections in a pool/sub-pool -->


      <!-- The time before an unused connection is destroyed -->

      <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->

      <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections -->


      <!-- sql to call when connection is created

        <new-connection-sql>some arbitrary sql</new-connection-sql>


      <!-- sql to call on an existing pooled connection when it is obtained from pool 

         <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>


      <!-- example of how to specify a class that determines a connection is valid before it is handed out from the pool



      <!-- Whether to check all statements are closed when the connection is returned to the pool,

           this is a debugging feature that should be turned off in production -->


      <!-- Use the getConnection(user, pw) for logins



      <!-- Use the security domain defined in conf/login-config.xml -->


      <!-- Use the security domain defined in conf/login-config.xml or the

           getConnection(user, pw) for logins. The security domain takes precedence.



      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->


         <type-mapping>Hypersonic SQL</type-mapping>


      <!-- This mbean can be used when using in process persistent hypersonic -->



   <!-- This mbean should be used only when using tcp connections. Uncomment

   when the tcp based connection-url is used. 


   <mbean code="org.jboss.jdbc.HypersonicDatabase" 


     <attribute name="Port">11701</attribute>

     <attribute name="Silent">true</attribute>

     <attribute name="Database">default</attribute>

     <attribute name="Trace">false</attribute>

     <attribute name="No_system_exit">true</attribute>



   <!-- This mbean can be used when using in process persistent db  -->

   <mbean code="org.jboss.jdbc.HypersonicDatabase" 


     <attribute name="Database">localDB</attribute>

     <attribute name="InProcessMode">true</attribute>




Open in new window


Author Comment

ID: 33531456
Hi gurvinder372:

My file is exactly the same as on

what about ejb-deployer.xml file below. DO i have to change anything

<?xml version="1.0" encoding="UTF-8"?>

<!-- The JBoss service configuration file for the EJB deployer service.

$Id: ejb-deployer.xml,v 2004/11/11 14:26:38 tdiesler Exp $



  <!-- ==================================================================== -->

  <!-- J2EE Timer Service                                                   -->

  <!-- ==================================================================== -->

  <!-- An EJB Timer Service that is Tx aware -->

  <mbean code="org.jboss.ejb.txtimer.EJBTimerServiceImpl"


    <attribute name="RetryPolicy">jboss.ejb:service=EJBTimerService,retryPolicy=fixedDelay</attribute>

    <attribute name="PersistencePolicy">jboss.ejb:service=EJBTimerService,persistencePolicy=database</attribute>

    <attribute name="TimerIdGeneratorClassName">org.jboss.ejb.txtimer.BigIntegerTimerIdGenerator</attribute>

    <attribute name="TimedObjectInvokerClassName">org.jboss.ejb.txtimer.TimedObjectInvokerImpl</attribute>


  <!-- A retry policy that uses a fixed interval in milli seconds -->

  <mbean code="org.jboss.ejb.txtimer.FixedDelayRetryPolicy" name="jboss.ejb:service=EJBTimerService,retryPolicy=fixedDelay">

    <attribute name="Delay">100</attribute>


  <!-- A persistence policy that does not persist the timer

  <mbean code="org.jboss.ejb.txtimer.NoopPersistencePolicy" name="jboss.ejb:service=EJBTimerService,persistencePolicy=noop"/>


  <!-- A persistence policy that persistes timers to a database -->

  <mbean code="org.jboss.ejb.txtimer.DatabasePersistencePolicy" name="jboss.ejb:service=EJBTimerService,persistencePolicy=database">

    <!-- DataSource JNDI name -->

    <depends optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>

    <!-- The plugin that handles database persistence -->

    <attribute name="DatabasePersistencePlugin">org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin</attribute>


  <!-- ==================================================================== -->

  <!-- EJB Deployer                                                         -->

  <!-- ==================================================================== -->

  <!-- EJB deployer, remove to disable EJB behavior-->

  <mbean code="org.jboss.ejb.EJBDeployer" name="jboss.ejb:service=EJBDeployer">

    <!-- A flag indicating if the deployer should validate the

    ejb-jar.xml/jboss.xml descriptors and components


    <attribute name="VerifyDeployments">true</attribute>

    <!-- A flag indicating if the xml parser should validate the descriptor



    <attribute name="ValidateDTDs">false</attribute>

    <!-- A flag indicating if the verifier should be verbose about its



    <attribute name="VerifierVerbose">true</attribute>

    <!-- Setting this to 'true' will cause all deployments

     to fail when the Verifier detected a problem with the contained

     Beans. If false, warnings/errors will be logged but the deployment

     will not fail.


    <attribute name="StrictVerifier">true</attribute>

    <!-- The EJBDeployer needs the JTA transaction manager service -->

    <depends optional-attribute-name="TransactionManagerServiceName">jboss:service=TransactionManager</depends>

    <!-- The dynamic class loading simple web server -->

    <depends optional-attribute-name="WebServiceName">jboss:service=WebService</depends>



Open in new window

LVL 10

Expert Comment

ID: 33533511
Is the original hsqldb-ds.xml still unchanged ? Are you sure you are not using the same JNDI name DefaultDS in the -ds file of your application ?
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.


Author Comment

ID: 33539438
The original ds file (hsqldb-ds.xm) is unchanged.  I am using the mmticket-ds.xml file that looks like this

<?xml version="1.0" encoding="UTF-8"?>

LVL 10

Accepted Solution

Hegemon earned 125 total points
ID: 33540169
Looks fine.

The server complains about something wrong it the HSQLDB database it uses for its key generator service. Try investigating what is wrong with it. If you don't need this service, you can undeploy it (just move the uuid-key-generator.sar folder away) and see if the error disappears.

Author Comment

ID: 33584124
will try this and will give you feedback

Author Closing Comment

ID: 33912018
Gave guide lines

delete the content under the hypersonic folder and it worked

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now