如果你使用的是Jboss3
那么在C:\JBoss-3.0.0\docs\examples\jca\mssql-service.xml
把里面的相应设置改正确,
然后拷贝到目录C:\JBoss-3.0.0\server\default\deploy\
那么在C:\JBoss-3.0.0\docs\examples\jca\mssql-service.xml
把里面的相应设置改正确,
然后拷贝到目录C:\JBoss-3.0.0\server\default\deploy\
我的连接池代码如下(使用jboss+tomcat)
<mbean code="org.jboss.jdbc.HypersonicDatabase" name="DefaultDomain:service=Hypersonic">
<attribute name="Port">1476</attribute>
<attribute name="Silent">true</attribute>
<attribute name="Database">default</attribute>
<attribute name="Trace">false</attribute>
</mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute name="PoolName">DefaultDS</attribute>
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:hsqldb:hsql://localhost:1476</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
<!-- $ Sun JDBC-ODBC桥驱动程序连接池声明-->
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="URL">jdbc:odbc:jboss_odbc</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="Password"></attribute>
</mbean>
<!-- $ i-net OPTA 2000 JDBC驱动程序连接池声明(采用INET数据源)-->
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="DataSourceClass">com.inet.tds.XDataSource</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="Properties">host=yangm; database=wits</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="Password"></attribute>
</mbean>
<!-- $ i-net OPTA 2000 JDBC驱动程序连接池声明(采用JBoss数据源)-->
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:inetdae7:yangm</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="Password"></attribute>
</mbean>