Hi Folks
I have the same error.
Where do I get the complete SQLServer2008 table creation script?
Or some way around it?
Best Regards
--
View this message in context:
http://activemq.2283324.n4.nabble.com/Problem-creating-tables-for-SQL-Server-2008-tp3535839p4721034.html
Sent from the ActiveMQ
yes, that is all that is needed.
The drop is there for the upgrade path where the tables already exist.
On 23 May 2011 13:05, janne postilista wrote:
> If there's no separate DDL except for the java code, it is difficult
> to create the tables manually, first I would need to decipher plenty
> of
If there's no separate DDL except for the java code, it is difficult
to create the tables manually, first I would need to decipher plenty
of stuff like:
83 "CREATE TABLE " + getFullMessageTableName() + "(" +
"ID " + sequenceDataType + " NOT NULL"
84 +
There is a createTablesOnStartup attribute on the
jdbcPersistenceAdapter that you can set to false to disable creation.
The DDL is in the the source:
http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java?view=markup
But the problem
Anyone? Does the table generation always have to be done by ActiveMQ
when it starts, or can it be done manually?
On Thu, May 19, 2011 at 5:20 PM, janne postilista
wrote:
> It seems activeMQ creates the tables (ACTIVEMQ_ACKS, LOCK, etc) when
> it starts up. Can you create the tables manually? Wher
It seems activeMQ creates the tables (ACTIVEMQ_ACKS, LOCK, etc) when
it starts up. Can you create the tables manually? Where is the DDL for
that?
I have a local SQL Server 2008 that I want to configure ActiveMQ to
use. My activemq.xml configuration is: