so the sql syntax for the update statement used by the locker is not supported.
So we need a specialisation of the database lock statement also.
Have a look at http://activemq.apache.org/jdbc-support.html where you
can see an example of overriding one of the sql statements.
But more generally we
http://activemq.2283324.n4.nabble.com/file/n3516486/activemq.log activemq.log
please find i upload log file after enabling debug logging for
org.apache.activemq.store.jdbc.DefaultDatabaseLocker
--
View this message in context:
http://activemq.2283324.n4.nabble.com/I-need-JDBC-Table-definations
enable debug logging for
org.apache.activemq.store.jdbc.DefaultDatabaseLocker to get a handle
on the root cause exception to see what is going on with the lock
implementation.
That may also need a specialisation.
On 11 May 2011 12:32, mahens wrote:
> created the statements manually on my database
created the statements manually on my database:
CREATE TABLE ACTIVEMQ_MSGS
(ID BIGINT NOT NULL,
CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250),
MSGID_SEQ BIGINT,
EXPIRATION BIGINT,
MSG BYTE,
PRIMARY KEY ( ID ) );
CREATE INDEX ACTIVEMQ_MSGS_MIDX ON ACTIVEMQ_MSGS (MSGID_PROD,MSGID_SEQ);
it looks like we need a specialization of the create statements for terajdbc.
On 10 May 2011 12:49, mahens wrote:
> Thanks Gary Tully,
>
> as you said it creates tables during startup so i removed tables from
> database.Now i tryed to start the broker but getting error like:
>
> INFO | Using Per
Thanks Gary Tully,
as you said it creates tables during startup so i removed tables from
database.Now i tryed to start the broker but getting error like:
INFO | Using Persistence Adapter:
JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@34c7e8a7)
INFO | Database adapter driver ov
created table manually with table defination as
CREATE TABLE ACTIVEMQ_MSGS
(ID BIGINT NOT NULL,
CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250),
MSGID_SEQ BIGINT,
EXPIRATION BIGINT,
MSG BYTE, PRIMARY KEY ( ID ) );
but still i am getting following error on startup:
Using Persistence Adapter:
they will be created automatically on startup, the sql statements can
be found in the source,
see the getCreateSchemaStatements metod at
http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java?view=markup
On 10 May 2011 11:29, mahe
