Hi; I configured JbBoss to use MySql and created two databases therein: "jbossdb" "go"
I'd really like to have JBoss use "jbossdb" for its jms_message, jms_roles, jms_subscriptions, jms_transactions and jms_users tables. And I'd like JBoss to use "go" for my bean persistance tables: games, members, plays, names. Here is what I tried, but my bean tables still end up in jbossdb. Can anyone point me to my problem? mysql-ds.xml<datasources> | <local-tx-datasource> | <jndi-name>DefaultDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | ... | </local-tx-datasource> | <local-tx-datasource> | <jndi-name>GoDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/go</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | ... | </local-tx-datasource> | </datasources>ejb-jar.xml<ejb-jar> | ... | <enterprise-beans> | <!-- MemberBean --> | <entity> | ... | <ejb-name>MemberEJB</ejb-name> | <resource-ref> | <description/> | <res-ref-name>GoDS</res-ref-name> | <res-type>javax.sql.DataSource</res-type> | ... | </resource-ref> | </entity> | </enterprise-beans> | </ejb-jar>jboss.xml | <jboss> | <enterprise-beans> | <!-- MemberBean --> | <entity> | <ejb-name>MemberEJB</ejb-name> | <local-jndi-name>ejb/MemberLocalHome</local-jndi-name> | <resource-ref> | <res-ref-name>GoDS</res-ref-name> | <jndi-name>java:/GoDS</jndi-name> | </resource-ref> | </entity> | ... | </enterprise-beans> | </jboss>standardjbosscmp-jdbc.xml | <jbosscmp-jdbc> | <defaults> | <datasource>java:/DefaultDS</datasource> | <datasource-mapping>mySQL</datasource-mapping> | ... | </defaults> | <type-mappings> | <type-mapping> | <name>mySQL</name> | ... | </type-mapping> | </type-mappings> | ... | </jbosscmp-jdbc>Thanx, glb View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3870108#3870108 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3870108 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
