[JBoss-dev] How can I use two datasource?

[Diana E. <est...@ya...>]

Hi, I need to configurate two datasource, actually I have a default datasource correct but when I try to use other datasource with other name, this's incorrect.
What can I do to use two datasource?
I have jboss 3.0.7, SQL Server
thanks for all.
My XML file:

<jbosscmp-jdbc>
   
   <defaults>
      <datasource>java:/DefaultDS</datasource>
      <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
      
      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <tuned-updates>true</tuned-updates>
      <read-only>false</read-only>
      <time-out>0</time-out>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <row-locking>false</row-locking>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
      <strategy>on-load</strategy>
      <page-size>1000</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>
   </defaults>
   <opc>
      <datasource>java:/DefaultDS2</datasource>
      <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
      
      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <tuned-updates>true</tuned-updates>
      <read-only>false</read-only>
      <time-out>0</time-out>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <row-locking>false</row-locking>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
      <strategy>on-load</strategy>
      <page-size>1000</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>
   </opc>
   <type-mappings>
     <type-mapping>
      <name>McKoi</name>
      <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
      <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
      <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
      <alias-header-prefix>t</alias-header-prefix>
      <alias-header-suffix>_</alias-header-suffix>
      <alias-max-length>32</alias-max-length>
      <subquery-supported>true</subquery-supported>
      <true-mapping>TRUE</true-mapping>
      <false-mapping>FALSE</false-mapping>
      <mapping>
         <java-type>java.lang.Boolean</java-type>
         <jdbc-type>BIT</jdbc-type>
         <sql-type>BOOLEAN</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Byte</java-type>
         <jdbc-type>TINYINT</jdbc-type>
         <sql-type>SMALLINT</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Short</java-type>
         <jdbc-type>SMALLINT</jdbc-type>
         <sql-type>SMALLINT</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Integer</java-type>
         <jdbc-type>INTEGER</jdbc-type>
         <sql-type>INTEGER</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Long</java-type>
         <jdbc-type>BIGINT</jdbc-type>
         <sql-type>BIGINT</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Float</java-type>
         <jdbc-type>REAL</jdbc-type>
         <sql-type>FLOAT</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Double</java-type>
         <jdbc-type>DOUBLE</jdbc-type>
         <sql-type>DOUBLE</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Character</java-type>
         <jdbc-type>CHAR</jdbc-type>
         <sql-type>CHAR</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.String</java-type>
         <jdbc-type>VARCHAR</jdbc-type>
         <sql-type>VARCHAR(64)</sql-type>
      </mapping>
      <mapping>
         <java-type>java.sql.Date</java-type>
         <jdbc-type>DATE</jdbc-type>
         <sql-type>DATE</sql-type>
      </mapping>
      <mapping>
         <java-type>java.sql.Time</java-type>
         <jdbc-type>TIME</jdbc-type>
         <sql-type>TIME</sql-type>
      </mapping>
      <mapping>
         <java-type>java.sql.Timestamp</java-type>
         <jdbc-type>TIMESTAMP</jdbc-type>
         <sql-type>TIMESTAMP</sql-type>
      </mapping>
      <mapping>
         <java-type>java.lang.Object</java-type>
         <jdbc-type>JAVA_OBJECT</jdbc-type>
         <sql-type>JAVA_OBJECT</sql-type>
      </mapping>
   </type-mapping>
   
      <type-mapping>
         <name>InterBase</name>
         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
         <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
         <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
         <alias-header-prefix>t</alias-header-prefix>
         <alias-header-suffix>_</alias-header-suffix>
         <alias-max-length>32</alias-max-length>
         <subquery-supported>true</subquery-supported>
         <true-mapping>1</true-mapping>
         <false-mapping>0</false-mapping>
         <mapping>
            <java-type>java.lang.Boolean</java-type>
            <jdbc-type>BIT</jdbc-type>
etc...


---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!