1 Reply Latest reply on Jan 25, 2006 2:40 PM by yukunzhao

    Deploying xPetStore with a driver other than Hypersonic

    yukunzhao Newbie

      I am trying to deploy and run xPetstore with JBOSS using a driver called DMSQL. I was able to run this successfully using Hypersonic database and driver. When I try DMSQL, the datasource xml file of petstore is:


      <local-tx-datasource>
      <jndi-name>xpetstoreds</jndi-name>
      <connection-url>jdbc:unisys:dmsql:Unisys.DMSII:resource=xpetstoreds;</connection-url>
      <driver-class>com.unisys.jdbc.dmsql.Driver</driver-class>
      <user-name>java</user-name>
      java
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <track-statements>true</track-statements>
      <idle-timeout-minutes>0</idle-timeout-minutes>
      <application-managed-security></application-managed-security>
      jboss:service=PetStoreDS
      </local-tx-datasource>


      1701
      false
      xpetstoreDS
      true
      true




      I don't expect there would be something like org.jboss.jdbc.DMSQL. Then how should I edit the mbean code part? I got a ?javax.ejb.EJBException: Could not instantiate bean? exception if I remove this mbean part or just use the hypersonic definition.

      Please help me in this! Thank you!

        • 1. Re: Deploying xPetStore with a driver other than Hypersonic
          yukunzhao Newbie

          Sorry about the bad format of the xml file. Repost:

          <datasources>
          
           <local-tx-datasource>
          
           <jndi-name>xpetstoreds</jndi-name>
          
           <connection-url>jdbc:unisys:dmsql:Unisys.DMSII:resource=xpetstoreds;</connection-url>
          
           <driver-class>com.unisys.jdbc.dmsql.Driver</driver-class>
          
           <user-name>java</user-name>
          
           <password>java</password>
          
           <min-pool-size>5</min-pool-size>
          
           <max-pool-size>20</max-pool-size>
          
           <track-statements>true</track-statements>
          
           <idle-timeout-minutes>0</idle-timeout-minutes>
          
           <application-managed-security></application-managed-security>
          
           <depends>jboss:service=PetStoreDS</depends>
          
           </local-tx-datasource>
          
          
          
           <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=PetStoreDS">
          
           <attribute name="Port">1701</attribute>
          
           <attribute name="Silent">false</attribute>
          
           <attribute name="Database">xpetstoreDS</attribute>
          
           <attribute name="Trace">true</attribute>
          
           <attribute name="No_system_exit">true</attribute>
          
           </mbean>
          
          
          
          </datasources>