multiple database work together?

[qiminghe]

I have two jar deployed. One uses MySQL the other uses Firebird. I can make them work seperately (by changing
standardjbosscmp-jdbc.xml, standardjaws.xml and copy
& modifying -service.xml from example/jca)
How to do I make them work together?

Thx

Qiming

[michael.cm]

you can modify standardjaws.xml
just as :

java:/DefaultDS
<type-mapping>Hypersonic SQL</type-mapping>
java:/OracleDS
<type-mapping>Oracle8</type-mapping>
...


then you can ope two database woring together,include (Hypersonic SQL,Oracle8).
you copy oracle-service.xml to folder:
modify JBoss3.0\server\default\deploy\oracle-service.xml
and \JBoss3.0\server\default\conf\login-config.xml

[qiminghe]

change standardjaws.xml does not seem to work for me.
here is the head of my standardjaws.xml

java:/MySqlDS
<type-mapping>mySQL</type-mapping>
java:/FirebirdDS
<type-mapping>InterBase</type-mapping>
.....
I am assuming mysql-sevice.xml and firebird-service.xml
are fine since they can work if seperated.

Question: do I have to change standardjbosscmp-jdbc.xml
It seems to me container always to pick datasource
from and it does not allow to have multiple
. Anyway to overide it and specify who
access what?

[michael.cm]

can u post error message.

[michael.cm]

<jbosscmp-jdbc>
<enterprise-beans>

<ejb-name>Visitor</ejb-name>
<table-name>Visitor</table-name> java:/OracleDS
....


...
</jbosscmp-jdbc>
modify datasource:
java:/OracleDS

current ejb will work with oracle.