1 Reply Latest reply on Jul 14, 2003 11:12 AM by sbahal

    Not bounding DB2

    madooreddy Newbie

      Hi all !!
      I have added datasource jboss.jcml (jboss 2.4.4) file like this


      COM.ibm.db2.jdbc.app.DB2Driver



      SmsDBDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:db2:smsdb
      1200000
      smsdb
      10
      smsdb
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      When i restart Jboss it showing datasource (SmsDBDS) sucessfully added in log files.

      But while accessing from jsp page giving expection like datasource(SmsDBDS) not bound ..

      Do i need to change any thing ? I have seen in standardjaws.xml like below--->?


      java:/DefaultDS
      <type-mapping>Hypersonic SQL</type-mapping>

      In this Do i need to change DefaultDS to SmsDBDS or some thing else i need to do

      pls .. HELP ME TO SOLVE THIS

      Thanks
      Reddy

        • 1. Re: Not bounding DB2
          sbahal Newbie

          This service file works:
          <?xml version="1.0" encoding="UTF-8"?>

          <!-- ==================================================================== -->
          <!-- ConnectionManager setup for default IBM DB2 -->
          <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
          <!-- ==================================================================== -->






          <!-- Include a login module configuration named DB2DbRealm.
          Update your login-conf.xml, here is an example for a
          ConfiguredIdentityLoginModule:

          <application-policy name = "DB2DbRealm">

          <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
          <module-option name = "principal">yourprincipal</module-option>
          <module-option name = "id">yourusername</module-option>
          <module-option name = "pwd">yourpassword</module-option>
          <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DB2DS</module-option>
          </login-module>

          </application-policy>

          NOTE: the application-policy name attribute must match SecurityDomainJndiName, and the
          module-option name = "managedConnectionFactoryName"
          must match the object name of the ConnectionManager you are configuring here.
          -->
          <!--uncomment out this line if you are using the DB2DbRealm above
          DB2DbRealm
          -->

          <depends optional-attribute-name="ManagedConnectionFactoryName">
          <!--embedded mbean-->


          DB2DS


          <!-- removed /EPYQALIB -->
          <config-property name="ConnectionURL" type="java.lang.String">jdbc:AS400://ACSDEVBR</config-property>
          <config-property name="DriverClass" type="java.lang.String">com.ibm.as400.access.AS400JDBCDriver</config-property>
          <!--set these only if you want only default logins, not through JAAS -->
          <config-property name="UserName" type="java.lang.String">inetsql</config-property>
          <config-property name="Password" type="java.lang.String">interdev</config-property>



          <!--Below here are advanced properties -->
          <!--hack-->
          <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


          <depends optional-attribute-name="ManagedConnectionPool">

          <!--embedded mbean-->

          0
          50
          5000
          15
          <!--
          criteria indicates if Subject (from security domain) or app supplied
          parameters (such as from getConnection(user, pw)) are used to distinguish
          connections in the pool. Choices are
          ByContainerAndApplication (use both),
          ByContainer (use Subject),
          ByApplication (use app supplied params only),
          ByNothing (all connections are equivalent, usually if adapter supports
          reauthentication)-->
          ByContainer


          <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

          <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

          java:/TransactionManager
          <!--make the rar deploy! hack till better deployment-->
          jboss.jca:service=RARDeployer