TomeCode

Open source projects from Tomas Frastia alias Tome

JBoss 5.1 GA – Error installing to Start: name=jboss:service=KeyGeneratorFactory

Sometimes I get an interesting error ‘Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo….‘ when installing JBoss Cluster, error log:

    2010-06-13 10:26:22,144 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo state=Create mode=Manual requiredState=Installed
    java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
    at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)
    at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:317)
    at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:278)

Have long studied where the problem is and I finally came out that the missing table HILOSEQUENCES for UUID Key Generator Factory Service. How it fix? Try execute the SQL CREATE TABLE statement:

CREATE TABLE HILOSEQUENCES
(
SEQUENCENAME VARCHAR(50) NOT NULL,
HIGHVALUES   INTEGER NOT NULL,
CONSTRAINT hilo_pk PRIMARY KEY (SEQUENCENAME)
)

this SQL statement you find in jboss_server/server/all/deploy/uuid-key-generator.sar/META-INF/jboss-service.xml in xml element ‘attribute’ with name ‘CreateTableDdl’.

, , , , , ,