0 Replies Latest reply on Oct 1, 2003 1:24 PM by priceke1

    Resource Manager not found

    priceke1 Newbie

      Hello.

      I am new to JBOSS, and not sure what my problem is here. I am using MS SQL Server 2000. JBOSS 3.2.2 .

      I was able to get my Connection Pooling working. Not sure if for everything though. I have a test servlet which is able to connect through a test servlet using this:

      javax.naming.Context ctx = new javax.naming.InitialContext();
      javax.sql.DataSource ds = (DataSource) ctx.lookup("java:/jdbc/TXTestPool");

      my mssql-ds.xml is as follows:


      <local-tx-datasource>
      <jndi-name>jdbc/TXTestPool</jndi-name>
      <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rambo</connection-url>
      <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
      <user-name>userName</user-name>
      pass
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
      </local-tx-datasource>



      Then I modified the standardjaws.xml file. Which I'm not quite sure is yet. But modified it to use my datasource(not sure if this is correct for the tag):


      java:/jdbc/TXTestPool
      <type-mapping>MS SQLSERVER2000</type-mapping>
      false


      I then changed the standardjbosscmp-jdbc.xml file and gave it the appropiate vaues, at least think so (not sure if that is correct for the tag).

      <jbosscmp-jdbc>

      java:/jdbc/TXTestPool
      <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
      <create-table>true</create-table>


      So I am able to make a connection to my DB through this in my test servlet and was able to get data back. But, when I try to deploy my EJB's, I get this error/warn message:
      14:34:12,572 INFO [EjbModule] Starting
      14:34:12,572 INFO [EntityContainer] Starting
      14:34:12,587 WARN [EntityContainer] No resource manager found for jdbc/TXTestPool
      14:34:12,587 INFO [EntityInstancePool] Starting
      14:34:12,587 INFO [EntityInstancePool] Started
      14:34:12,603 INFO [EntityContainer] Started

      I am not sure what this is or how to go about fixing it. I wasn't sure if it is an issue with the correct JNDI name in my ejb-jar.xml or something else.

      one of my ejb-jar files is:

      <ejb-jar>
      <enterprise-beans>


      <ejb-name>DtEnPresentation</ejb-name>
      com.Test.DtEnPresentationHome
      com.Test.DtEnPresentation
      <ejb-class>com.Test.DtEnPresentationEJB</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>
      <resource-ref>
      <res-ref-name>java:/jdbc/TXTestPool</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>

      </enterprise-beans>
      <assembly-descriptor>
      <container-transaction>

      <ejb-name>DtEnPresentation</ejb-name>
      <method-name>*</method-name>

      <trans-attribute>Required</trans-attribute>
      </container-transaction>
      </assembly-descriptor>
      </ejb-jar>



      and another is as follows:

      <ejb-jar>
      <enterprise-beans>


      <ejb-name>FnRbEntityLoader</ejb-name>
      com.Test.FnRbEntityLoaderHome
      com.Test.FnRbEntityLoader
      <ejb-class>com.Test.FnRbEntityLoaderEJB</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>

      </enterprise-beans>
      <assembly-descriptor>
      <container-transaction>

      <ejb-name>FnRbEntityLoader</ejb-name>
      <method-name>*</method-name>

      <trans-attribute>Supports</trans-attribute>
      </container-transaction>
      </assembly-descriptor>
      </ejb-jar>

      I also made modification to the login-config.xml

      <application-policy name="MSSqlServerDbRealm">

      <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required">
      <module-option name="userName" />
      <module-option name="userName">estoreuser</module-option>
      <module-option name="password">estore</module-option>
      <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=TXTestPool</module-option>
      </login-module>

      </application-policy>

      Not sure about that one or not and if that is necessary or it's purpose yet.

      So what I am asking is probably a couple questions. One, what is the resource manager issue, and the other is are there other things that I need to configure in order to get the EJB's to be active?

      Do I need to create a jboss.xml file for each EJB?

      Any help is greatly appreciated. thanks for your time and help. If additional information would help, please let me know.

      Thanks.

      Kevin.