3 Replies Latest reply on Oct 3, 2002 3:06 AM by Joel Vogt

    How to configure SAP datasource

    Randahl Fink Isaksen Novice

      Does anyone know the correct way to make JBoss connect to a sap database? I have tried appending the xml of sapdb-service.xml to the list of mbeans in jboss-service.xml, but this leads to the configuration problems shown below. Are there any other issues that needs to be taken care of?

      R.

      00:10:52,868 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
      ration 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:

      MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.jca:service=LocalTxCM,name=SapdbDS
      state: CREATED
      I Depend On: jboss.jca:service=LocalTxDS,name=SapdbDS
      jboss.jca:service=LocalTxPool,name=SapdbDS
      jboss.jca:service=CachedConnectionManager
      jboss.security:service=JaasSecurityManager
      jboss.jca:service=RARDeployer

      Depends On Me: , ObjectName: jboss.jca:service=LocalTxPool,name=SapdbDS
      state: CREATED
      I Depend On:
      Depends On Me: jboss.jca:service=LocalTxCM,name=SapdbDS
      ]

        • 1. Re: How to configure SAP datasource
          efly Newbie

          HI,
          I've just made my SAP to JBOSS3.0 connection reference to the issue jboss 3.0.2 and oracle 8.1.7 .http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ works quite well as you follow these steps:
          1.edit $JBOSS/server/default/conf/standardjaws.xml:
          java:/SapdbDS
          <type-mapping>SapDB</type-mapping>
          false
          2.edit $JBOSS/server/default/conf/standardjbosscmp-jdbc.xml
          java:/SapdbDS
          <datasource-mapping>SapDB</datasource-mapping>
          3.copy sapdbc.jar to $JBOSS/server/default/lib.
          4.copied sapdb-service.xml to $JBOSS/server/default/deploy and edited it.
          SapdbDS



          <config-property name="ConnectionURL" type="java.lang.String">jdbc:sapdb://127.0.0.1/TST</config-property>
          <config-property name="DriverClass" type="java.lang.String">com.sap.dbtech.jdbc.DriverSapDB</config-property>
          <!--set these only if you want only default logins, not through JAAS -->
          <config-property name="UserName" type="java.lang.String">test</config-property>
          <config-property name="Password" type="java.lang.String">test</config-property>



          5.edit jbosscmp-jdbc.xml that among your project deploy xml files.

          java:/SapdbDS
          <datasource-mapping>SapDB</datasource-mapping>
          <create-table>true</create-table>
          <remove-table>true</remove-table>
          <pk-constraint>true</pk-constraint>
          <preferred-relation-mapping>foreign-key</preferred-relation-mapping>


          now you will work well with SAPDB in JBoss3.0.

          • 2. Re: How to configure SAP datasource
            vin Newbie

            Could you please tell what version of SAP JDBC driver you are using?

            I am able to connect to SAPDB from JBoss3.0 and execute SQL statements from my EJBs. However, once I have delay of 15 minutes, the subsequent SQLs start failing.

            It did not appear stable to me.

            From your message it appears you are using JBoss 3.2?

            What is your version of SAP JDBC driver?

            Is the environment stable?

            • 3. Re: How to configure SAP datasource
              Joel Vogt Master

              one of our production sapdb databases just hit a gig of data (all inputs) and hasn't even needed to be restarted in about a years worth of up-time. (running on various jboss versions).
              This has been with a couple of different drivers too, but mostly 21a.
              If you get it set up, which can be a problem, then it is well worth your time