| Deepak_Robi 2005-07-28, 8:23 pm |
|
HI Can you please tell me what is the solution for this. I am also
getting the same Error
anthony wrote:
> *I am trying to conncect to a SQL Server 2000 DB via a Websphere
> JDBC
> Provider. SQL Server 2000 and Websphere are on different machines.
> I
> performed the following steps:
>
> 1. Installed the SQL Server 2000 Driver for JDBC on the server where
> Websphere is located.
> 2. Installed the Stored Procedures for JTA on the machine where SQL
> Server 2000 is installed.
> 3. Created a JDBC Provider using the SQL Server 2000 Driver for
> JDBC:
> com.microsoft.jdbcx.sqlserver.SQLServerDataSource
> 4.Tried connecting to the DB via the DataSource Name.
> 5. Received the following error on the first try:
>
> CONM7007I: Mapping the following SQLException, with ErrorCode 0 and
> SQLState 08S01, to a StaleConnectionExcep
tion:
> java.sql.SQLException:
> [Microsoft][SQLServer 2000 Driver for JDBC]There is no process to
> read
> data written to a pipe.
> at com.microsoft.jdbc.base.BaseExceptions. createException(Unkn
own
> Source)
> at com.microsoft.jdbc.base.BaseExceptions. getException(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseExceptions. getException(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest. submitRequest(Unknow
n
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver. SQLServerImplStateme
nt.execute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement. commonExecute(Unknow
n
> Source)
> at
> com.microsoft.jdbc.base.BaseStatement. executeQueryInternal
(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement. executeQuery(Unknown
> Source)
> at
> com.microsoft.jdbcx.base. BaseStatementWrapper
. executeQuery(Unknown
> Source)
> at
> com.ibm.ejs.cm.proxy.StatementProxy. executeQueryCommon(S
tatementProxy.java:306)
> at
> com.ibm.ejs.cm.proxy.StatementProxy. executeQuery(Stateme
ntProxy.java:271)
> at
> mckhboc.utils._sqlcommand_jsp_2. _jspService(_sqlcomm
and_jsp_2.java:267)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.runtime. JspServlet$JspServle
tWrapper.service(JspServlet.java:323)
> at
> org.apache.jasper.runtime.JspServlet. serviceJspFile(JspSe
rvlet.java:503)
> at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:636)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> com.ibm.servlet.engine.webapp. StrictServletInstanc
e. doService(ServletMan
ager.java:827)
> at
> com.ibm.servlet.engine.webapp. StrictLifecycleServl
et. _service(StrictLifec
ycleServlet.java:167)
> at
> com.ibm.servlet.engine.webapp.IdleServletState. service(StrictLifecy
cleServlet.java:297)
> at
> com.ibm.servlet.engine.webapp. StrictLifecycleServl
et. service(StrictLifecy
cleServlet.java:110)
> at
> com.ibm.servlet.engine.webapp.ServletInstance. service(ServletManag
er.java:472)
> at
> com.ibm.servlet.engine.webapp. ValidServletReferenc
eState. dispatch(ServletMana
ger.java:1012)
> at
> com.ibm.servlet.engine.webapp. ServletInstanceRefer
ence. dispatch(ServletMana
ger.java:913)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. handleWebAppDispatch
(WebAppRequestDispat
cher.java:721)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. dispatch(WebAppReque
stDispatcher.java:374)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. forward(WebAppReques
tDispatcher.java:118)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker. doForward(WebAppInvo
ker.java:134)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker. handleInvocationHook
(WebAppInvoker.java:239)
> at
> com.ibm.servlet.engine.invocation.CachedInvocation. handleInvocation(Cac
hedInvocation.java:67)
> at
> com.ibm.servlet.engine.invocation. CacheableInvocationC
ontext. invoke(CacheableInvo
cationContext.java:106)
> at
> com.ibm.servlet.engine.srp. ServletRequestProces
sor. dispatchByURI(Servle
tRequestProcessor.java:154)
> at
> com.ibm.servlet.engine.oselistener. OSEListenerDispatche
r.service(OSEListener.java:315)
> at
> com.ibm.servlet.engine.http11.HttpConnection. handleRequest(HttpCo
nnection.java:60)
> at
> com.ibm.ws.http.HttpConnection. readAndHandleRequest
(HttpConnection.java(Compiled
> Code))
> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
> Code))
> at com.ibm.ws.util.CachedThread.run(ThreadPool.java:138)
>
> 6. Tried connecting again and recveived this error:
>
> Servlet Error: Outstanding work on this connection which was not
> comitted or rolledback by the user has been rolledback.:
> com.ibm.ejs.cm.exception. WorkRolledbackExcept
ion: Outstanding work
> on
> this connection which was not comitted or rolledback by the user has
> been rolledback.
> at com.ibm.ejs.cm.pool.ConnectO.decRef(ConnectO.java:366)
> at
> com.ibm.ejs.cm.pool.ConnectionPool. freeConnection(Conne
ctionPool.java:166)
> at
> com.ibm.ejs.cm.proxy.ConnectionProxy. close(ConnectionProx
y.java:821)
> at
> mckhboc.utils._sqlcommand_jsp_2. _jspService(_sqlcomm
and_jsp_2.java:453)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.runtime. JspServlet$JspServle
tWrapper.service(JspServlet.java:323)
> at
> org.apache.jasper.runtime.JspServlet. serviceJspFile(JspSe
rvlet.java:503)
> at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:636)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> com.ibm.servlet.engine.webapp. StrictServletInstanc
e. doService(ServletMan
ager.java:827)
> at
> com.ibm.servlet.engine.webapp. StrictLifecycleServl
et. _service(StrictLifec
ycleServlet.java:167)
> at
> com.ibm.servlet.engine.webapp.IdleServletState. service(StrictLifecy
cleServlet.java:297)
> at
> com.ibm.servlet.engine.webapp. StrictLifecycleServl
et. service(StrictLifecy
cleServlet.java:110)
> at
> com.ibm.servlet.engine.webapp.ServletInstance. service(ServletManag
er.java:472)
> at
> com.ibm.servlet.engine.webapp. ValidServletReferenc
eState. dispatch(ServletMana
ger.java:1012)
> at
> com.ibm.servlet.engine.webapp. ServletInstanceRefer
ence. dispatch(ServletMana
ger.java:913)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. handleWebAppDispatch
(WebAppRequestDispat
cher.java:721)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. dispatch(WebAppReque
stDispatcher.java:374)
> at
> com.ibm.servlet.engine.webapp. WebAppRequestDispatc
her. forward(WebAppReques
tDispatcher.java:118)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker. doForward(WebAppInvo
ker.java:134)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker. handleInvocationHook
(WebAppInvoker.java:239)
> at
> com.ibm.servlet.engine.invocation.CachedInvocation. handleInvocation(Cac
hedInvocation.java:67)
> at
> com.ibm.servlet.engine.invocation. CacheableInvocationC
ontext. invoke(CacheableInvo
cationContext.java:106)
> at
> com.ibm.servlet.engine.srp. ServletRequestProces
sor. dispatchByURI(Servle
tRequestProcessor.java:154)
> at
> com.ibm.servlet.engine.oselistener. OSEListenerDispatche
r.service(OSEListener.java:315)
> at
> com.ibm.servlet.engine.http11.HttpConnection. handleRequest(HttpCo
nnection.java:60)
> at
> com.ibm.ws.http.HttpConnection. readAndHandleRequest
(HttpConnection.java(Compiled
> Code))
> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
> Code))
> at com.ibm.ws.util.CachedThread.run(ThreadPool.java:138)
>
> Any thoughts to why I am getting the above two exceptions?
>
> Thanks for your help
> Anthony
>
>
>
> --
> anthony
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message240982.html *
--
Deepak_Robi
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message722858.html
|