users@glassfish.java.net

Re: Glassfish clustered LOCAL jms setup

From: Satish Kumar <kumar.satish_at_oracle.com>
Date: Wed, 17 Aug 2011 17:56:37 +0530

Hi Galvin,

The create-jms-cluster command will not create and configure a database.
It will only allow you to configure MQ to use an existing database.

Thanks,
Satish

On 08/16/2011 09:45 PM, forums_at_java.net wrote:
> Hi all,
>
> I am a little confussed as too the use of: configure-jms-cluster, I am
> using:
>
> configure-jms-cluster --port 30048 --clustertype=enhanced --dbvendor
> mysql
> --dbuser openmq --dburl jdbc:mysql://pbdb1:3306/mq_con APP
>
> I had hoped that it would create the message queue tables if the database
> doesnt exist, however I get an error from it of: Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
> database
> 'mq_con'
>
> Admittedly I had given it the wrong database name, but still I kinda
> naviely
> expected it to create it if it needed too.
>
> Is there another command that I can run to have it create the database?
>
> Thanks
>
> Gavin
>
>
>
>
>
>
> --
>
> [Message sent by forum member 'gavintranter']
>
> View Post: http://forums.java.net/node/834142
>
>