1 Reply Latest reply on Oct 29, 2003 1:45 PM by bolacha

    Add datasource in Jboss 3.2.2RC4 - HELP!!!!

    bolacha Newbie

      Hi all....

      How can I config JBoss to multiple datasource?

      when i deploy my bean:
      (i specify datasource on jbosscmp-jdbc.xml on my package .jar )

      Depends On Me: , ObjectName: jboss.j2ee:jndiName=Usuarios1Remote,service=EJB
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Invalid XML: file=file:/usr/local/jboss/server/default/conf/standardjbosscmp-jdbc.xml, ObjectName: jboss.j2ee:jndiName=Teste1Remote,service=EJB
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Invalid XML: file=file:/usr/local/jboss/server/default/conf/standardjbosscmp-jdbc.xml]


      look my standardjbosscmp-jdbc.xml:

      ...
      <jbosscmp-jdbc>


      java:/FirebirdDS
      <datasource-mapping>Firebird</datasource-mapping>

      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <read-only>false</read-only>
      <read-time-out>300000</read-time-out>
      <row-locking>false</row-locking>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
      on-load
      <page-size>1000</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>

      <unknown-pk>
      <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
      <unknown-pk-class>java.lang.String</unknown-pk-class>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(32)</sql-type>
      </unknown-pk>

      <entity-command name="default"/>



      <!-- here is a problem but what is? -->


      java:/Firebird2DS
      <datasource-mapping>Firebird</datasource-mapping>

      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <read-only>false</read-only>
      <read-time-out>300000</read-time-out>
      <row-locking>false</row-locking>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
      on-load
      <page-size>1000</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>
      <unknown-pk>
      <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
      <unknown-pk-class>java.lang.String</unknown-pk-class>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(32)</sql-type>
      </unknown-pk>

      <entity-command name="default"/>



      both bases are on Firebird ... but exists two files .gdb ....

      Please HELP ME!!!!

      and... in deploy directory have 2 -ds.xml ...

      Firebird-ds.xml and Firebird2-ds.xml
      and exist one firebirdsql.rar

      :/

      Tnx ...

        • 1. Re: Add datasource in Jboss 3.2.2RC4 - HELP!!!!
          bolacha Newbie

          Oks...

          Finally have i success ...

          only deploy firebird-ds.xml and firebird2-ds.xml ...

          and... deploy firebirdsql.rar ...

          i not change anything in standardjbosscmp-jdbc.xml ..

          in firebird2-ds.xml

          change:



          <jndi-name>Firebird2DS</jndi-name>

          and configurations of database ....

          So...

          if anybody have this problem, probaly this solve!!!!


          ps: sorry about my bad english!!! ;-)