Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Received-SPF: pass (athena.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
MIME-Version: 1.0
Date: Wed, 4 Dec 2013 16:31:53 -0800
Message-ID: 
 <CAMMqR+Owi1_edj0oY3gH6FBB2tuDz0Pq=aAmz55U=6gM03NENg@mail.gmail.com>
Subject: How to prevent activeMQ in geronimo 3.0.1 from creating the database
 tables during startup?
From: Jack Cai <cai_jack@us.chanjet.com>
To: user@geronimo.apache.org, dev@geronimo.apache.org
Content-Type: multipart/alternative; boundary=001a11c3dce0009e1104ecbea8e5

--001a11c3dce0009e1104ecbea8e5
Content-Type: text/plain; charset=UTF-8

Hi,

  When we change the persistence to postgresql 9.2.4 in Geronimo 3.0.1 for
ActiveMQ, We keep running into this error: "[DefaultJDBCAdapter] Could not
create JDBC tables; they could already exist. Failure was: ALTER TABLE
ACTIVEMQ_ACKS DROP PRIMARY KEY Message: ERROR: syntax error at or near
"PRIMARY""

  We suspect activeMQ tries to create the tables during initialization. We
try to use turn it off, but the setting that used to work in 3.0.0 no
longer works in the new blueprint config activemq.xml.

       <amq:persistenceAdapter>
           <amq:jdbcPersistenceAdapter dataSource="#postgres-ds"
createTablesOnStartup="false">
           </amq:jdbcPersistenceAdapter>
        </amq:persistenceAdapter>

 Can anyone help? (Either fix the create table error, or disable table
creation) Thanks.

Regards

Jack

--001a11c3dce0009e1104ecbea8e5
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>=C2=A0 When we change the persisten=
ce to postgresql 9.2.4 in Geronimo 3.0.1 for ActiveMQ, We keep running into=
 this error: &quot;[DefaultJDBCAdapter] Could not create JDBC tables; they =
could already exist. Failure was: ALTER TABLE ACTIVEMQ_ACKS DROP PRIMARY KE=
Y Message: ERROR: syntax error at or near &quot;PRIMARY&quot;&quot;</div>
<div><br></div><div>=C2=A0 We suspect activeMQ tries to create the tables d=
uring initialization. We try to use turn it off, but the setting that used =
to work in 3.0.0 no longer works in the new blueprint config activemq.xml.=
=C2=A0</div>
<div><br></div><div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0&lt;amq:persistenceAdap=
ter&gt;</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0&lt;amq:jdbcPers=
istenceAdapter dataSource=3D&quot;#postgres-ds&quot;=C2=A0<span style=3D"ba=
ckground-color:transparent;color:rgb(0,0,0);font-family:&#39;Droid Sans&#39=
;;font-size:11px;white-space:pre-wrap">createTablesOnStartup=3D&quot;false&=
quot;</span>&gt;</div>
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0&lt;/amq:jdbcPersistenceAdapt=
er&gt;</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 &lt;/amq:persistenceAdapter&gt=
;</div></div><div><br></div><div>=C2=A0Can anyone help? (Either fix the cre=
ate table error, or disable table creation) Thanks.</div>
<div><br></div><div>Regards</div><div><br></div><div>Jack</div></div>

--001a11c3dce0009e1104ecbea8e5--