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

    Deploying xPetStore with a driver other than Hypersonic

    yukunzhao
    yukunzhao Jan 25, 2006 2:37 PM

      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!

      • 121759 Views
      • Tags:
        • 1. Re: Deploying xPetStore with a driver other than Hypersonic
          yukunzhao
          yukunzhao Jan 25, 2006 2:40 PM (in response to yukunzhao)

          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>


            • Actions