activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fazle Khan <fazlesk...@gmail.com>
Subject Problems configuring ActiveMQ5.1.0 embedded broker to not create tables on startup
Date Thu, 12 Feb 2009 19:22:57 GMT

I'm been trying without luck to configure our application's ActiveMQ5.1.0
embedded broker to not create it's tables at start up.

    <amq:broker useJmx="false" persistent="true" id="broker"
brokerName="broker" deleteAllMessagesOnStartup="true">
        <amq:persistenceAdapter>
            <amq:journaledJDBC dataDirectory="activemq-data/data"
dataSource="#dataSource" useDatabaseLock="false"
createTablesOnStartup="false">
                <amq:adapter>
                    <bean
class="org.apache.activemq.store.jdbc.adapter.SybaseJDBCAdapter"/>
                </amq:adapter>
            </amq:journaledJDBC>
        </amq:persistenceAdapter>
        <amq:transportConnectors>
            <amq:transportConnector name="nio"
uri="nio://localhost:61616?trace=true"/>
        </amq:transportConnectors>
    </amq:broker>

Above is the broker configuration file I've tried to use and when the server
starts it still generates warning that the tables already exists even though
the createTablesOnStartup attribute is set to false

2009-02-12 19:16:00,087 WARN  [main] (DefaultJDBCAdapter.java:100) - Could
not create JDBC tables; they could already exist. Failure was: CREATE TABLE
ACTIVEMQ_LOCK( ID DECIMAL NOT NULL, TIME DECIMAL, BROKER_NAME VARCHAR(250),
PRIMARY KEY (ID) ) Message: [DataDirect][Sybase JDBC Driver][Sybase]There is
already an object named 'ACTIVEMQ_LOCK' in the database.
 SQLState: 42S01 Vendor code: 2714
2009-02-12 19:16:00,103 WARN  [main] (DefaultJDBCAdapter.java:100) - Could
not create JDBC tables; they could already exist. Failure was: INSERT INTO
ACTIVEMQ_LOCK(ID) VALUES (1) Message: [DataDirect][Sybase JDBC
Driver][Sybase]Attempt to insert duplicate key row in object 'ACTIVEMQ_LOCK'
with unique index 'ACTIVEMQ_L_18636746562'
 SQLState: 23000 Vendor code: 2601
2009-02-12 19:16:00,165 WARN  [main] (DefaultJDBCAdapter.java:100) - Could
not create JDBC tables; they could already exist. Failure was: CREATE TABLE
ACTIVEMQ_LOCK( ID DECIMAL NOT NULL, TIME DECIMAL, BROKER_NAME VARCHAR(250),
PRIMARY KEY (ID) ) Message: [DataDirect][Sybase JDBC Driver][Sybase]There is
already an object named 'ACTIVEMQ_LOCK' in the database.
 SQLState: 42S01 Vendor code: 2714
2009-02-12 19:16:00,165 WARN  [main] (DefaultJDBCAdapter.java:100) - Could
not create JDBC tables; they could already exist. Failure was: INSERT INTO
ACTIVEMQ_LOCK(ID) VALUES (1) Message: [DataDirect][Sybase JDBC
Driver][Sybase]Attempt to insert duplicate key row in object 'ACTIVEMQ_LOCK'
with unique index 'ACTIVEMQ_L_18636746562'
 SQLState: 23000 Vendor code: 2601

Any suggestions?
-- 
View this message in context: http://www.nabble.com/Problems-configuring-ActiveMQ5.1.0-embedded-broker-to-not-create-tables-on-startup-tp21983054p21983054.html
Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.


Mime
View raw message