6 Replies Latest reply: Jan 4, 2012 12:11 PM by Jose Alvarez de Lara RSS

Error on start JBoss AS 6.0 up

Jose Alvarez de Lara Novice

I have recently installed HSQLDB 2.2.6 and on JBoss 6.0.0.Final AS start up I see then following error,

 

08:25:44,000 WARN [DBUserEditorImpl] could not create user or role table

08:25:44,015 ERROR [STDERR] java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: nombre del objeto ya existe: MAIL_USERS in statement [CREATE TABLE MAIL_USERS (USER_NAME VARCHAR(40) PRIMARY KEY, PASSWORD VARCHAR(40) NOT NULL)]

 

08:25:44,015 ERROR [STDERR]  at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.executeStatement(DBUserEditorImpl.java:189)

 

08:25:44,015 ERROR [STDERR]  at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.start(DBUserEditorImpl.java:156)

 

08:25:44,015 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 

08:25:44,015 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

 

08:25:44,015 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

 

08:25:44,015 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:597)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)

 

08:25:44,015 ERROR [STDERR]  at $Proxy41.start(Unknown Source)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:53)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:41)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:301)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)

 

08:25:44,015 ERROR [STDERR]  at org.jboss.system.ServiceController.doChange(ServiceController.java:671)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.ServiceController.start(ServiceController.java:443)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:189)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:102)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:49)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1832)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1550)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1571)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1491)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.change(DeployersImpl.java:1983)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:1076)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:679)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.process(MainDeployerPlugin.java:106)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileControllerContext$DelegateDeployer.process(ProfileControllerContext.java:143)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileDeployAction.deploy(ProfileDeployAction.java:151)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileDeployAction.installActionInternal(ProfileDeployAction.java:94)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileActivationWrapper$BasicProfileActivation.start(ProfileActivationWrapper.java:190)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileActivationWrapper.start(ProfileActivationWrapper.java:87)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileActivationService.activateProfile(ProfileActivationService.java:215)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.dependency.ProfileActivationService.activate(ProfileActivationService.java:159)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.activate(AbstractProfileServiceBootstrap.java:112)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.resolver.BasicResolverFactory$ProfileResolverFacade.deploy(BasicResolverFactory.java:87)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.start(AbstractProfileServiceBootstrap.java:91)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:132)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417)

 

08:25:44,031 ERROR [STDERR]  at java.lang.Thread.run(Thread.java:662)

 

08:25:44,031 ERROR [STDERR] Caused by: java.sql.SQLSyntaxErrorException: nombre del objeto ya existe: MAIL_USERS in statement [CREATE TABLE MAIL_USERS (USER_NAME VARCHAR(40) PRIMARY KEY, PASSWORD VARCHAR(40) NOT NULL)]

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:215)

 

08:25:44,031 ERROR [STDERR]  at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299)

 

08:25:44,031 ERROR [STDERR]  at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.executeStatement(DBUserEditorImpl.java:187)

 

08:25:44,031 ERROR [STDERR]  ... 81 more

 

08:25:44,031 ERROR [STDERR] Caused by: org.hsqldb.HsqlException: nombre del objeto ya existe: MAIL_USERS

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.error.Error.error(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.error.Error.error(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.StatementSchema.getResult(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.StatementSchema.execute(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.Session.executeCompiledStatement(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  at org.hsqldb.Session.execute(Unknown Source)

 

08:25:44,031 ERROR [STDERR]  ... 86 more

 

I have left the DefaultDS in hsqldb-ds.xml file as it is.

 

Which is the problem?

 

Thanks in advance,

Jose

  • 1. Re: Error on start JBoss AS 6.0 up
    Wolf-Dieter Fink Master

    Why do you use HSQLDB and reinstall it? Is it the same version as the original?

     

    - the localDb file or the SQL syntax is different if the version is different

    - the localDb file access rights are wrong

    - do you remove the common/lib/hsqldb ?

     

    What if you use the original hsqldb.jar (common/lib)

  • 2. Re: Error on start JBoss AS 6.0 up
    Jose Alvarez de Lara Novice

    No, I have just installed the last version of HSQLDB.

    I do not know what version comes with JBoss AS.

     

    But leaving the origibal installation of JBoss AS, when I have gone to ...\server\default\data\hypersonic

    everything is related with the new version of HSQLDB 2.2.6

     

    Here is the localDB.script

     

    SET DATABASE UNIQUE NAME HSQLDB3483834E27

    SET DATABASE GC 0

    SET DATABASE DEFAULT RESULT MEMORY ROWS 0

    SET DATABASE EVENT LOG LEVEL 0

    SET DATABASE SQL NAMES FALSE

    SET DATABASE SQL REFERENCES FALSE

    SET DATABASE SQL SIZE FALSE

    SET DATABASE SQL TYPES FALSE

    SET DATABASE SQL TDC DELETE TRUE

    SET DATABASE SQL TDC UPDATE TRUE

    SET DATABASE SQL TRANSLATE TTI TYPES TRUE

    SET DATABASE SQL CONCAT NULLS TRUE

    SET DATABASE SQL UNIQUE NULLS TRUE

    SET DATABASE SQL CONVERT TRUNCATE TRUE

    SET DATABASE SQL AVG SCALE 0

    SET DATABASE SQL DOUBLE NAN TRUE

    SET DATABASE SQL LONGVAR IS LOB FALSE

    SET DATABASE TRANSACTION CONTROL LOCKS

    SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED

    SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE

    SET DATABASE TEXT TABLE DEFAULTS ''

    SET FILES WRITE DELAY 10

    SET FILES BACKUP INCREMENT TRUE

    SET FILES CACHE SIZE 10000

    SET FILES CACHE ROWS 50000

    SET FILES SCALE 1

    SET FILES LOB SCALE 32

    SET FILES DEFRAG 0

    SET FILES NIO TRUE

    SET FILES NIO SIZE 256

    SET FILES LOG TRUE

    SET FILES LOG SIZE 200

    CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'

    CREATE SCHEMA PUBLIC AUTHORIZATION DBA

    SET SCHEMA PUBLIC

    CREATE MEMORY TABLE PUBLIC.HILOSEQUENCES(SEQUENCENAME VARCHAR(50) NOT NULL,HIGHVALUES INTEGER NOT NULL,CONSTRAINT HILO_PK PRIMARY KEY(SEQUENCENAME))

    CREATE MEMORY TABLE PUBLIC.TIMERS(TIMERID VARCHAR(80) NOT NULL,TARGETID VARCHAR(250) NOT NULL,INITIALDATE TIMESTAMP NOT NULL,TIMERINTERVAL BIGINT,INSTANCEPK VARBINARY(32768),INFO VARBINARY(32768),CONSTRAINT TIMERS_PK PRIMARY KEY(TIMERID,TARGETID))

    CREATE MEMORY TABLE PUBLIC.TIMEOUTMETHOD_METHODPARAMS(TIMEOUTMETHOD_ID BIGINT NOT NULL,METHODPARAMS VARCHAR(255))

    CREATE MEMORY TABLE PUBLIC.CALENDAR_TIMER(AUTOTIMER BOOLEAN NOT NULL,SCHEDULEEXPRDAYOFMONTH VARCHAR(255),SCHEDULEEXPRDAYOFWEEK VARCHAR(255),SCHEDULEEXPRENDDATE TIMESTAMP,SCHEDULEEXPRHOUR VARCHAR(255),SCHEDULEEXPRMINUTE VARCHAR(255),SCHEDULEEXPRMONTH VARCHAR(255),SCHEDULEEXPRSECOND VARCHAR(255),SCHEDULEEXPRSTARTDATE TIMESTAMP,SCHEDULEEXPRTIMEZONE VARCHAR(255),SCHEDULEEXPRYEAR VARCHAR(255),ID VARCHAR(255) NOT NULL PRIMARY KEY,TIMEOUTMETHOD_ID BIGINT)

    CREATE MEMORY TABLE PUBLIC.TIMEOUT_METHOD(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,DECLARINGCLASS VARCHAR(255) NOT NULL,METHODNAME VARCHAR(255) NOT NULL)

    ALTER TABLE PUBLIC.TIMEOUT_METHOD ALTER COLUMN ID RESTART WITH 1

    CREATE MEMORY TABLE PUBLIC.TIMER(ID VARCHAR(255) NOT NULL PRIMARY KEY,INFO VARBINARY(255),INITIALDATE TIMESTAMP,NEXTDATE TIMESTAMP,PREVIOUSRUN TIMESTAMP,REPEATINTERVAL BIGINT NOT NULL,TIMEDOBJECTID VARCHAR(255) NOT NULL,TIMERSTATE INTEGER)

    CREATE MEMORY TABLE PUBLIC.MAIL_USERS(USER_NAME VARCHAR(40) NOT NULL PRIMARY KEY,PASSWORD VARCHAR(40) NOT NULL)

    CREATE MEMORY TABLE PUBLIC.MAIL_ROLES(USER_NAME VARCHAR(40) NOT NULL,ROLE_NAME VARCHAR(40) NOT NULL)

    ALTER TABLE PUBLIC.TIMEOUTMETHOD_METHODPARAMS ADD CONSTRAINT FKF294C964B7DE2D8A FOREIGN KEY(TIMEOUTMETHOD_ID) REFERENCES PUBLIC.TIMEOUT_METHOD(ID)

    ALTER TABLE PUBLIC.CALENDAR_TIMER ADD CONSTRAINT FK2B697F04E6E6EF93 FOREIGN KEY(ID) REFERENCES PUBLIC.TIMER(ID)

    ALTER TABLE PUBLIC.CALENDAR_TIMER ADD CONSTRAINT FK2B697F04B7DE2D8A FOREIGN KEY(TIMEOUTMETHOD_ID) REFERENCES PUBLIC.TIMEOUT_METHOD(ID)

    ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1

    SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC

    GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC

    GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC

    GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC

    GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC

    GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC

    GRANT DBA TO SA

    SET SCHEMA PUBLIC

    INSERT INTO HILOSEQUENCES VALUES('general',0)

     

    I did not remove the hsqldb.jar from common/lib. I am using the original one.

    JBoss AS and HSQLDB are in diferents folders.

     

    I do not understand what is happening.

     

    Thanks,

    Jose

  • 3. Re: Error on start JBoss AS 6.0 up
    Wolf-Dieter Fink Master

    I'm a bit confused

    Do you mean you install a HSQLDB additionaly to JBoss (which already works before this installation).

    After the HSQLDB installation JBoss did not start with the errors above?

     

    In this case I suppose that the installation change your environment and if you start JBoss your HSQL and JBoss installations are mixed up.

    If I'm right, please check your environment (BTW which OS)

  • 4. Re: Error on start JBoss AS 6.0 up
    Jose Alvarez de Lara Novice

    Yes, it is exactly what you suppose. But I was confused with your first reply and:

     

    - I have left the HSQLDB istallation.

    - And I have reinstalled JBoss AS

     

    On the first start of the AS there was any error message, but on the second one the error appeared again.

     

    My OS is Win XP SP3. Now here is my localDB,

     

    localDB.log

     

    /*C7*/SET SCHEMA PUBLIC

    CONNECT USER SA

    /*C8*/SET SCHEMA PUBLIC

    CONNECT USER SA

    /*C9*/SET SCHEMA PUBLIC

    CONNECT USER SA

    /*C10*/SET SCHEMA PUBLIC

    CONNECT USER SA

    /*C11*/SET SCHEMA PUBLIC

    CONNECT USER SA

    /*C12*/SET SCHEMA PUBLIC

    CONNECT USER SA

     

    localDB.properties

     

    #HSQL Database Engine 1.8.0.8

    #Tue Jan 03 13:17:03 CET 2012

    hsqldb.script_format=0

    runtime.gc_interval=0

    sql.enforce_strict_size=false

    hsqldb.cache_size_scale=8

    readonly=false

    hsqldb.nio_data_file=true

    hsqldb.cache_scale=14

    version=1.8.0

    hsqldb.default_table_type=memory

    hsqldb.cache_file_scale=1

    hsqldb.log_size=200

    modified=yes

    hsqldb.cache_version=1.7.0

    hsqldb.original_version=1.8.0

    hsqldb.compatible_version=1.8.0

     

    localDB.script

     

    CREATE SCHEMA PUBLIC AUTHORIZATION DBA

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

    CREATE MEMORY TABLE TIMERS(TIMERID VARCHAR(80) NOT NULL,TARGETID VARCHAR(250) NOT NULL,INITIALDATE TIMESTAMP NOT NULL,TIMERINTERVAL BIGINT,INSTANCEPK VARBINARY,INFO VARBINARY,CONSTRAINT TIMERS_PK PRIMARY KEY(TIMERID,TARGETID))

    CREATE MEMORY TABLE TIMEOUTMETHOD_METHODPARAMS(TIMEOUTMETHOD_ID BIGINT NOT NULL,METHODPARAMS VARCHAR(255))

    CREATE MEMORY TABLE CALENDAR_TIMER(AUTOTIMER BOOLEAN NOT NULL,SCHEDULEEXPRDAYOFMONTH VARCHAR(255),SCHEDULEEXPRDAYOFWEEK VARCHAR(255),SCHEDULEEXPRENDDATE TIMESTAMP,SCHEDULEEXPRHOUR VARCHAR(255),SCHEDULEEXPRMINUTE VARCHAR(255),SCHEDULEEXPRMONTH VARCHAR(255),SCHEDULEEXPRSECOND VARCHAR(255),SCHEDULEEXPRSTARTDATE TIMESTAMP,SCHEDULEEXPRTIMEZONE VARCHAR(255),SCHEDULEEXPRYEAR VARCHAR(255),ID VARCHAR(255) NOT NULL PRIMARY KEY,TIMEOUTMETHOD_ID BIGINT)

    CREATE MEMORY TABLE TIMEOUT_METHOD(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,DECLARINGCLASS VARCHAR(255) NOT NULL,METHODNAME VARCHAR(255) NOT NULL)

    CREATE MEMORY TABLE TIMER(ID VARCHAR(255) NOT NULL PRIMARY KEY,INFO VARBINARY(255),INITIALDATE TIMESTAMP,NEXTDATE TIMESTAMP,PREVIOUSRUN TIMESTAMP,REPEATINTERVAL BIGINT NOT NULL,TIMEDOBJECTID VARCHAR(255) NOT NULL,TIMERSTATE INTEGER)

    CREATE MEMORY TABLE MAIL_USERS(USER_NAME VARCHAR(40) NOT NULL PRIMARY KEY,PASSWORD VARCHAR(40) NOT NULL)

    CREATE MEMORY TABLE MAIL_ROLES(USER_NAME VARCHAR(40) NOT NULL,ROLE_NAME VARCHAR(40) NOT NULL)

    ALTER TABLE TIMEOUTMETHOD_METHODPARAMS ADD CONSTRAINT FKF294C964B7DE2D8A FOREIGN KEY(TIMEOUTMETHOD_ID) REFERENCES TIMEOUT_METHOD(ID)

    ALTER TABLE CALENDAR_TIMER ADD CONSTRAINT FK2B697F04E6E6EF93 FOREIGN KEY(ID) REFERENCES TIMER(ID)

    ALTER TABLE CALENDAR_TIMER ADD CONSTRAINT FK2B697F04B7DE2D8A FOREIGN KEY(TIMEOUTMETHOD_ID) REFERENCES TIMEOUT_METHOD(ID)

    ALTER TABLE TIMEOUT_METHOD ALTER COLUMN ID RESTART WITH 1

    CREATE USER SA PASSWORD ""

    GRANT DBA TO SA

    SET WRITE_DELAY 10

    SET SCHEMA PUBLIC

    INSERT INTO HILOSEQUENCES VALUES('general',0)

     

    and the error message,

     

    13:17:08,625 WARN  [DBUserEditorImpl] could not create user or role table

    13:17:08,625 ERROR [STDERR] java.lang.RuntimeException: java.sql.SQLException: Table already exists: MAIL_USERS in statement [CREATE TABLE MAIL_USERS]

     

    Excuse me, what do you mean when yo say - "please check your environment (BTW which OS)".

    I do not understand the achronym BTW

     

    Regards,

    Jose

  • 5. Re: Error on start JBoss AS 6.0 up
    Wolf-Dieter Fink Master

    You should check the Java classpath and JVM properties for JBoss, see boot.log file. Also your windows environment variables related to HSQLDB and Java.

    Maybe here some jar's or the path of the db are mixed-up.

     

    Also you should make clear which files you post, the hsqldb installation or <JBoss>/server/.../data/...

     

    'BTW'  - by the way  google is your friend

  • 6. Re: Error on start JBoss AS 6.0 up
    Jose Alvarez de Lara Novice

    'BTW'  - by the way  google is your friend. Ok my friend!!.

     

    Well I have been reading the boot.log file and except the error message everything is ok.

    About the Windows environment variables are ok as well.

     

    As you recommend I have clear all the files in .../data/hipersonic.

     

    In case of JBoss AS should have any problem I should post a new thread again, in the meanwhile

    we are going to leave it at this point.

     

    Thanks a lot Wolf,

    Jose