-
1. Re: multiple database work together?
michael.cm Jun 25, 2002 3:14 AM (in response to qiminghe)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 -
2. Re: multiple database work together?
qiminghe Jun 25, 2002 12:29 PM (in response to 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? -
3. Re: multiple database work together?
michael.cm Jun 26, 2002 3:31 AM (in response to qiminghe)can u post error message.
-
4. Re: multiple database work together?
michael.cm Jun 26, 2002 3:36 AM (in response to qiminghe)<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.