Re: [JBoss-user] Two datasources, almost working...
Hi Jarkko, thanks for the help. Unfortunately this didn't work. Even when I separated out the mysql file what seemed to happen was both ears used one database. I tested each application on its own (removing the other ear) and they both worked fine. I think what was happening was they were using whichever datasource was loaded first. I fixed the problem by adding a jboss-app.xml file and adding the following lines: jboss-app loader-repositoryappname:loader=dell/loader-repository /jboss-app jboss-app loader-repositoryappname:loader=microsoft/loader-repository /jboss-app I think this gives each ear a separate class loader, but I'm not sure. It finally worked for me under this configuration. thanks for the help, Brian From: Jarkko Lietolahti [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Two datasources, almost working... Date: Thu, 04 Dec 2003 05:39:54 +0200 Hello, Try separating the datasource definitions into two different ds.xml-files (dell-mysql-ds and microsoft-mysql-ds.xml). This also gives you the ability to deploy/undeploy only needed datasources.. t. Jarkko Brian Styles wrote: Hi all, In my effort to deploy two versions of my ear on the same jboss3.2.2 under different virtual hosts, I'm left with one little problem. Try as I might, my two applications are using the one datasource. For examples sake, lets say the two versions of the applications are for two different companies: dell and microsoft I'm using mysql and have created two datasources in my mysql-ds.xml file datasources local-tx-datasource jndi-namedellDS/jndi-name connection-urljdbc:mysql://localhost:3306/dell/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever/password /local-tx-datasource local-tx-datasource jndi-namemicrosoftDS/jndi-name connection-urljdbc:mysql://localhost:3306/microsoft/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever2/password /local-tx-datasource /datasources and the references in my ejb jars do correspond correctly to these jndi names. And when I check the jmx-console, under jboss.jca I get name=dellDS,service=LocalTxCM name=dellDS,service=ManagedConnectionFactory name=dellDS,service=ManagedConnectionPool name=microsoftDS,service=LocalTxCM name=microsoftDS,service=ManagedConnectionFactory name=microsoftDS,service=ManagedConnectionPool but under jboss.management.local I only see: J2EEServer=Local,JCAResource=microsoftDS,j2eeType=JCAConnectionFactory,name=microsoftDS Wrapper,j2eeType=JCAResource,name=microsoftDS J2EEServer=Local,j2eeType=JCAManagedConnectionFactory,name=microsoftDS but no corresponding entries for dellDS Both applications are successfully using micrsoftDS and I think that maybe this might be because of the lack of the stuff in jboss.management.local above. Please can anyone help me? thanks very much, Brian _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Two datasources, almost working...
Hi all, In my effort to deploy two versions of my ear on the same jboss3.2.2 under different virtual hosts, I'm left with one little problem. Try as I might, my two applications are using the one datasource. For examples sake, lets say the two versions of the applications are for two different companies: dell and microsoft I'm using mysql and have created two datasources in my mysql-ds.xml file datasources local-tx-datasource jndi-namedellDS/jndi-name connection-urljdbc:mysql://localhost:3306/dell/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever/password /local-tx-datasource local-tx-datasource jndi-namemicrosoftDS/jndi-name connection-urljdbc:mysql://localhost:3306/microsoft/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever2/password /local-tx-datasource /datasources and the references in my ejb jars do correspond correctly to these jndi names. And when I check the jmx-console, under jboss.jca I get name=dellDS,service=LocalTxCM name=dellDS,service=ManagedConnectionFactory name=dellDS,service=ManagedConnectionPool name=microsoftDS,service=LocalTxCM name=microsoftDS,service=ManagedConnectionFactory name=microsoftDS,service=ManagedConnectionPool but under jboss.management.local I only see: J2EEServer=Local,JCAResource=microsoftDS,j2eeType=JCAConnectionFactory,name=microsoftDS Wrapper,j2eeType=JCAResource,name=microsoftDS J2EEServer=Local,j2eeType=JCAManagedConnectionFactory,name=microsoftDS but no corresponding entries for dellDS Both applications are successfully using micrsoftDS and I think that maybe this might be because of the lack of the stuff in jboss.management.local above. Please can anyone help me? thanks very much, Brian _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Two datasources, almost working...
Hello, Try separating the datasource definitions into two different ds.xml-files (dell-mysql-ds and microsoft-mysql-ds.xml). This also gives you the ability to deploy/undeploy only needed datasources.. t. Jarkko Brian Styles wrote: Hi all, In my effort to deploy two versions of my ear on the same jboss3.2.2 under different virtual hosts, I'm left with one little problem. Try as I might, my two applications are using the one datasource. For examples sake, lets say the two versions of the applications are for two different companies: dell and microsoft I'm using mysql and have created two datasources in my mysql-ds.xml file datasources local-tx-datasource jndi-namedellDS/jndi-name connection-urljdbc:mysql://localhost:3306/dell/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever/password /local-tx-datasource local-tx-datasource jndi-namemicrosoftDS/jndi-name connection-urljdbc:mysql://localhost:3306/microsoft/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name passwordwhatever2/password /local-tx-datasource /datasources and the references in my ejb jars do correspond correctly to these jndi names. And when I check the jmx-console, under jboss.jca I get name=dellDS,service=LocalTxCM name=dellDS,service=ManagedConnectionFactory name=dellDS,service=ManagedConnectionPool name=microsoftDS,service=LocalTxCM name=microsoftDS,service=ManagedConnectionFactory name=microsoftDS,service=ManagedConnectionPool but under jboss.management.local I only see: J2EEServer=Local,JCAResource=microsoftDS,j2eeType=JCAConnectionFactory,name=microsoftDS Wrapper,j2eeType=JCAResource,name=microsoftDS J2EEServer=Local,j2eeType=JCAManagedConnectionFactory,name=microsoftDS but no corresponding entries for dellDS Both applications are successfully using micrsoftDS and I think that maybe this might be because of the lack of the stuff in jboss.management.local above. Please can anyone help me? thanks very much, Brian _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user