6 Replies Latest reply on Jan 4, 2012 12:11 PM by pepelara

    Error on start JBoss AS 6.0 up

    pepelara

      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
          wdfink

          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
            pepelara

            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
              wdfink

              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
                pepelara

                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
                  wdfink

                  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
                    pepelara

                    '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