ITPUB论坛 » Sybase管理与开发 » 请教下数据库连接的问题,谢谢
新一届的微软MVP评选已经开始,欢迎各位推荐!
2008-5-23 16:35 sybaseoracle
请教下数据库连接的问题,谢谢

程序日志:
服务器用的WEBLOGIC
2008-05-23 16:24:50] : DebugLevel = 2 ErrorInfo = JZ0C0: 连接已关闭。
[2008-05-23 16:24:50] : DebugLevel = 2
java.sql.SQLException: JZ0C0: 连接已关闭。
        at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java(Compiled Code))
        at com.sybase.jdbc2.jdbc.SybConnection.checkConnection(SybConnection.java(Compiled Code))
        at com.sybase.jdbc2.jdbc.SybConnection.createStatement(SybConnection.java(Compiled Code))
        at weblogic.jdbc.pool.Connection.createStatement(Connection.java(Compiled Code))
        at com.xwtec.common.todo.TododivisionsDAO.selectByPrimaryKey(TododivisionsDAO.java(Compiled Code))

SYBASE 日志:
01:00000:00010:2008/05/23 09:29:22.55 server  There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
01:00000:00010:2008/05/23 09:29:59.64 server  Error: 1601, Severity: 17, State: 3
01:00000:00010:2008/05/23 09:29:59.64 server  There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
02:00000:00008:2008/05/23 09:30:00.21 server  Process id 87 killed by Hostname , Host process id .
02:00000:00008:2008/05/23 09:30:00.21 server  Process '87' has been terminated because it exceeded the maximum login time allowed. This process used a temporary administrative connection which is allowed a maximum login period of '15' minutes.

请问下这个系统平时300多号人在线 我SYBASE 'user connections'中已经调整为250了 为什么还会有这个错误,谢谢

[[i] 本帖最后由 sybaseoracle 于 2008-5-23 16:42 编辑 [/i]]

2008-5-29 09:42 jarjar
300多人在线,250个连接够吗?
还有,从Application Server到数据库的连接是什么方式?连接池?

2008-5-29 11:01 sybaseoracle
[url]http://www.itpub.net/thread-993678-1-2.html[/url]

解决了,呵呵

[[i] 本帖最后由 sybaseoracle 于 2008-5-29 11:05 编辑 [/i]]

2008-6-10 10:07 sn97163
LZ的最后一贴值得学习!:-)

页: [1]


Powered by ITPUB论坛