I have solved the issue over here, you can find the solution over here <http://activemq.2283324.n4.nabble.com/jira-Created-AMQ-3075-Auto-create-database-fails-with-PostgreSQL-Error-in-SQL-drop-primary-key-td3079208.html#a3226324> . The reason the messages are not storing in the database is that one of the header property of message *Persistence* is by default set to the value *Non Persistent*. You just have to set it to *Persistent* and the messages will be stored in the queue as well as in your configured database.
Thanks Tim for your help, that was helpful. -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html