JBoss 3.0.4 的 CMP 连接 SQL Server 的问题

Question

差不出数据的症状是什么？cmp的data source有么有配置？有exception么？

Answer 1

没有任何的Exception和报错信息
mssql-service.xml 文件如下：
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=HRM">
<depends optional-attribute-name="ManagedConnectionFactoryName">
<mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=HRM">
<attribute name="JndiName">HRM</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL" type="java.lang.String">
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=hrm
</config-property>
<config-property name="DriverClass" type="java.lang.String">
com.microsoft.jdbc.sqlserver.SQLServerDriver
</config-property>
<config-property name="UserName" type="java.lang.String">hrm</config-property>
<config-property name="Password" type="java.lang.String">hrm</config-property>
</properties>
</attribute>
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=HRM">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="BlockingTimeoutMillis">500</attribute>
<attribute name="IdleTimeoutMinutes">1</attribute>
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends optional-attribute-name="CachedConnectionManager">
jboss.jca:service=CachedConnectionManager
</depends>
<depends optional-attribute-name="JaasSecurityManagerService">
jboss.security:service=JaasSecurityManager
</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>