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.