JSQLConnect2_20.jar,本机从没问题,我放到生产机上,出现以下license连接错误。
报错如下:
工程1:com.jnetdirect.jsql.x: Failed Logon:com.jnetdirect.jsql.x: This license allows a maximum of 100 connections and 100 are already connected url:jdbc:JSQLConnect://127.0.0.1/database=AAA
工程2:org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed Logon:com.jnetdirect.jsql.x: This license allows a maximum of 100 connections and 100 are already connected url:jdbc:JSQLConnect://127.0.0.1/database=BBB)
我的配置:
<Resource name= "jdbc/xxx " auth= "Container " type= "javax.sql.DataSource "
maxActive= "100 " maxIdle= "30 " maxWait= "10000 "
username= "sa " password= "XXX " driverClassName= "com.microsoft.jdbc.sqlserver.SQLServerDriver "
url= "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=AAA "/>
如何解决?
[解决办法]
只看得明白, "允许100个连接,已经有100个连接存在了 "