How to modify jbossmq-service.xml

[cliffwei]

hi, there

Do you know how to modify the jbossmq-service.xml in deploy/jms directory if I want to use data sources
other than DefaultDS? Suppose I have 3 data sources:
jdbc/opc/OPCDB; jdbc/petstore/PetStoreDB; jdbc/supplier/SupplierDB

I have another petstore-destination-service.xml
where should I put it? should I use it instead of jbossmq-destination-service.xml?

[adrian.brock]

Just modify it to use jdbc connection manager
of choice.
See http://localhost:8080/jmx-console

You will probably need to modify at
least the blob type if you aren't using hsqldb.

You can use it as well as or instead of the default
destinations. The default destinations are only
there for the jboss testsuite.

Regards,
Adrian

[cliffwei]

I have opened localhost:8080/jmx-console

Actually I have three data sources, but I found that
JCA Resource only equals to jdbc/opc/OPCDB

So I guess that's the problem in jbossmq-service.xml

Suppose I have 3 data sources:
Can I write this way:

<depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=jdbc/petstore/PetStoreDB;jdbc/opc/OPCDB;jdbc/supplier/SupplierDB


Also I have modified standardjaws.xml and standardcmpjdbc.xml

I wrote in this way:


java:/jdbc/opc/OPCDB;java:/jdbc/petstore/PetStoreDB;java:/jdbc/supplier/SupplierDB
<datasource-mapping>mySQL</datasource-mapping>

is it correct?

[cliffwei]

How to modify the blob type if I use the MYSQL 4.1 -alpha version which support subquery?

THANKS