제가 odbc 와 oledb 를 연결하여서 프로그램을 사용하고
있는데요
예전엔 안그랬는데 새로 sybase를 깔고 나서부터 이런 오류가 자주
납니다.
서비스에서 사이베이스 서버를 시작을 하면 연결이 잘 되는데
조금만 있으면 jdbc 연결오류가 나면서 socket이 닫혔다고 오류가
납니다.
그래서 서비스를 중지했다 다시 시작하면 이런오류가 안납니다
예전에는 한번 서비스를 시작해 놓으면 연결끊김없이 잘
되었었는데
멀 하려고만 하면 연결이 끊겼다고 오류가 나네요...
연결 끊기지 않고 계속 쓰려면 따로 멀 지정해 줘야 하나요?
연결 끊길때마다 서비스를 다시 시작하고 있습니다...
방법 부탁드리구요
빠른답변 부탁드려요,,, 지방에 일 나왔는데 계속이러면
안되거든요
부탁드립니다
오류 메시지 입니다
java.sql.SQLException: JZ006: IOException 발견:
com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: 연결이
이미 닫혔습니다.
at
com.sybase.jdbc2.jdbc.ErrorMessage.createIOEKilledConnEx(ErrorMessage.java:773)
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:814)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3441)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2005)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1746)
at
com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1738)
at
com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:814)
at
com.sybase.aseplugin.sql.ASConnection.executeCommand(ASConnection.java:427)
at
com.sybase.aseplugin.so.ASEBaseItemSO.useDB(ASEBaseItemSO.java:126)
at
com.sybase.aseplugin.so.DatabaseSO.useDB(DatabaseSO.java:1222)
at
com.sybase.aseplugin.bo.ResultSetDetailsPanel.setResultSet(ResultSetDetailsPanel.java:372)
at
com.sybase.aseplugin.bo.ResultSetDetailsPanel.setResultSet(ResultSetDetailsPanel.java:366)
at
com.sybase.aseplugin.bo.ResultSetDetailsPanel.onOpen(ResultSetDetailsPanel.java:168)
at
com.sybase.central.viewer.ContentPane.setContainer(ContentPane.java)
at
com.sybase.central.viewer.ViewerManager.setSelectedTreeItem(ViewerManager.java)
at
com.sybase.central.viewer.ScopePane.selectTreeItem(ScopePane.java)
at
com.sybase.central.viewer.ScopePane.valueChanged(ScopePane.java)
at javax.swing.JTree.fireValueChanged(Unknown Source)
at
javax.swing.JTree$TreeSelectionRedirector.valueChanged(Unknown
Source)
at
javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown
Source)
at
javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown
Source)
at
javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown
Source)
at
javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown
Source)
at javax.swing.JTree.setSelectionPath(Unknown Source)
at
javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown
Source)
at
javax.swing.plaf.basic.BasicTreeUI$MouseHandler.mousePressed(Unknown
Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown
Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown
Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown
Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown
Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
|