Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17



Posted on 2010-08-26
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
LVL 40

Expert Comment

by:Gurvinder Pal Singh
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

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 ?

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 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
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.

661 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