2sdk1.4.2_07 + jboss-3.2.6 上发布web 应用,但jboss开在那里几天后,访问web 应用时,jsp页面就打不开了,jboss控制台上信息是:数据源连不上。必须重启jboss才行。几天后又是如此。
应该是连接池问题,连接池配置如下:
<datasources>
<local-tx-datasource>
<jndi-name>MSSQL/abc</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=book</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>book</password>
<!-- 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>
</datasources> 配置有问题吗?为什么经常连不上数据源?
应该是连接池问题,连接池配置如下:
<datasources>
<local-tx-datasource>
<jndi-name>MSSQL/abc</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=book</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>book</password>
<!-- 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>
</datasources> 配置有问题吗?为什么经常连不上数据源?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货