Web Server forum
Back To The Forum Home!Search!Private Messaging System
Visit your User Control Panel!Register your FREE username now!Visit Our Calendar!View the Member List!Faqs!Search our Forums!

This is Interesting: Free IT Magazines Now Free shipping to California  
Web Server Talk Web Server Talk > Free Databases support forum > Microsoft SQL server > SQL JDBC Driver > Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

anthony is offline     Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
anthony


View Ip Address Report This Message To A Moderator Edit/Delete Message


Click Here to See the Profile for anthony Click here to Send anthony a Private Message Find more posts by anthony Add anthony to your buddy list		 
05-27-04 08:28 PM

I am trying to conncect to a SQL Server 2000 DB via a Websphere JDBC Provide
r.  SQL Server 2000 and Websphere are on different machines.  I performed th
e following steps:

1. Installed the SQL Server 2000 Driver for JDBC on the server where Websphe
re is located.
2. Installed the Stored Procedures for JTA on the machine where SQL Server 2
000 is installed.
3. Created a JDBC Provider using the SQL Server 2000 Driver for JDBC: com.mi
crosoft.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 StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver fo
r JDBC]There is no process to read data written to a pipe.
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown 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(Unknown Sou
rce)
	at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Sou
rce)
	at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Sour
ce)
	at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Sourc
e)
	at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
	at com.microsoft.jdbcx.base.BaseStatementWrapper.executeQuery(Unknown Sourc
e)
	at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.ja
va:306)
	at com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271
)
	at mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServle
t.java:323)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletMan
ager.java:827)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:167)
	at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:297)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:110)
	at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:472)
	at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1012)
	at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:913)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:721)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:374)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:118)
	at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:13
4)
	at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:239)
	at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:67)
	at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cach
eableInvocationContext.java:106)
	at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:154)
	at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:315)
	at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.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.WorkR
olledbackException: Outstanding work on this connection which was not comitt
ed 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(ConnectionPool.java:16
6)
	at com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:821)
	at mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServle
t.java:323)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletMan
ager.java:827)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:167)
	at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:297)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:110)
	at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:472)
	at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1012)
	at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:913)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:721)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:374)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:118)
	at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:13
4)
	at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:239)
	at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:67)
	at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cach
eableInvocationContext.java:106)
	at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:154)
	at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:315)
	at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.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




[ Post a follow-up to this message ]



anthony is offline     Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
anthony


View Ip Address Report This Message To A Moderator Edit/Delete Message


Click Here to See the Profile for anthony Click here to Send anthony a Private Message Find more posts by anthony Add anthony to your buddy list		 
05-28-04 08:44 PM

Please ignore this message. There was a WebShpere setting I didn't know I ha
d to set. 

Thanks.



quote:
Originally posted by anthony 
I am trying to conncect to a SQL Server 2000 DB via a Websphere JDBC Provide
r.  SQL Server 2000 and Websphere are on different machines.  I performed th
e following steps:

1. Installed the SQL Server 2000 Driver for JDBC on the server where Websphe
re is located.
2. Installed the Stored Procedures for JTA on the machine where SQL Server 2
000 is installed.
3. Created a JDBC Provider using the SQL Server 2000 Driver for JDBC: com.mi
crosoft.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 StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver fo
r JDBC]There is no process to read data written to a pipe.
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown 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(Unknown Sou
rce)
	at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Sou
rce)
	at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Sour
ce)
	at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Sourc
e)
	at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
	at com.microsoft.jdbcx.base.BaseStatementWrapper.executeQuery(Unknown Sourc
e)
	at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.ja
va:306)
	at com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271
)
	at mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServle
t.java:323)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletMan
ager.java:827)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:167)
	at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:297)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:110)
	at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:472)
	at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1012)
	at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:913)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:721)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:374)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:118)
	at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:13
4)
	at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:239)
	at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:67)
	at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cach
eableInvocationContext.java:106)
	at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:154)
	at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:315)
	at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.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.WorkR
olledbackException: Outstanding work on this connection which was not comitt
ed 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(ConnectionPool.java:16
6)
	at com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:821)
	at mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServle
t.java:323)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletMan
ager.java:827)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:167)
	at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:297)
	at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:110)
	at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:472)
	at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1012)
	at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:913)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:721)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:374)
	at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:118)
	at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:13
4)
	at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:239)
	at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:67)
	at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cach
eableInvocationContext.java:106)
	at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:154)
	at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:315)
	at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.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




[ Post a follow-up to this message ]



    Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
SqlJunkies User


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
06-26-04 03:28 PM

Can you share that solution with me?

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.




[ Post a follow-up to this message ]



    Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
trapp


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-01-04 10:55 PM


Hey I have a similar problem trying to close a database connection in
WebSphere and the solution to this problem would be a huge help!  If
either of you have figured this out please let me know....thanks!


SqlJunkies User wrote:
> *Can you share that solution with me?
>
> ---
> Posted using Wimdows.net NntpNews Component -
>
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
> engine supports Post Alerts, Ratings, and Searching. *



--
trapp
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message722858.html




[ Post a follow-up to this message ]



    Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
WebFellow


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
05-11-05 07:49 AM


Hi,

can you share your solution with me, i'm getting the same problem.

Thanx.

anthony wrote:
> *Please ignore this message. There was a WebShpere setting I didn't
> know
> I had to set.
>
> Thanks.
>
>
> anthony wrote: 
> JDBC 
> machines. 
> where 
> SQL 
> JDBC: 
> and 
> java.sql.SQLException: 
> com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown 
> com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown 
> com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown 
> com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java
:306) 
> com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271) 
> mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_jsp_2.java:267) 
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142) 
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.
java:323) 
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:503) 
> com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManag
er.java:827) 
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:167) 
> com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServ
let.java:297) 
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:110) 
> com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:
472) 
> com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletM
anager.java:1012) 
> com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMan
ager.java:913) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:721) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReque
stDispatcher.java:374) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppReques
tDispatcher.java:118) 
> com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
 
> com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoke
r.java:239) 
> com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cached
Invocation.java:67) 
> com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cachea
bleInvocationContext.java:106) 
> com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRe
questProcessor.java:154) 
> com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListen
er.java:315) 
> com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.
java:60) 
> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Co
mpiled 
> com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled 
> on 
> has 
> com.ibm.ejs.cm.pool.ConnectionPool.freeConnection(ConnectionPool.java:166)
 
> com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:821) 
> mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_jsp_2.java:453) 
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142) 
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.
java:323) 
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:503) 
> com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManag
er.java:827) 
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:167) 
> com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServ
let.java:297) 
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:110) 
> com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:
472) 
> com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletM
anager.java:1012) 
> com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMan
ager.java:913) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:721) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReque
stDispatcher.java:374) 
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppReques
tDispatcher.java:118) 
> com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
 
> com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoke
r.java:239) 
> com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cached
Invocation.java:67) 
> com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cachea
bleInvocationContext.java:106) 
> com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRe
questProcessor.java:154) 
> com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListen
er.java:315) 
> com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.
java:60) 
> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Co
mpiled 
> com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled 
>
>
>
> --
> anthony
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message240982.html *



--
WebFellow
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message722858.html




[ Post a follow-up to this message ]



Rafael@Pru is offline     Re: Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce  
Rafael@Pru


View Ip Address Report This Message To A Moderator Edit/Delete Message


Click Here to See the Profile for Rafael@Pru Click here to Send Rafael@Pru a Private Message Find more posts by Rafael@Pru Add Rafael@Pru to your buddy list		 
06-10-05 06:45 PM

Anthony - What was the WebSphere setting that you changed?  We're having a s
imilar problem - Thanks - Rafael


quote:
Originally posted by trapp 
Hey I have a similar problem trying to close a database connection in
WebSphere and the solution to this problem would be a huge help!  If
either of you have figured this out please let me know....thanks!


SqlJunkies User wrote:
> *Can you share that solution with me?
>
> ---
> Posted using Wimdows.net NntpNews Component -
>
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
> engine supports Post Alerts, Ratings, and Searching. *



--
trapp
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message722858.html




[ Post a follow-up to this message ]



    Re: Using JDBC Connection Pooling via Websphere JDBC Provider using a DataSournce Name  
Deepak_Robi


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-29-05 01:48 AM


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 StaleConnectionException:
> 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(Unknown
> 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(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
> 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(StatementProxy.java
:306)
> at
> com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271)
> at
> mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServlet.
java:323)
> at
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletManag
er.java:827)
> at
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:167)
> at
> com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServ
let.java:297)
> at
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:110)
> at
> com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:
472)
> at
> com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletM
anager.java:1012)
> at
> com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMan
ager.java:913)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:721)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReque
stDispatcher.java:374)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppReques
tDispatcher.java:118)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoke
r.java:239)
> at
> com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cached
Invocation.java:67)
> at
> com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cachea
bleInvocationContext.java:106)
> at
> com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRe
questProcessor.java:154)
> at
> com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListen
er.java:315)
> at
> com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.
java:60)
> at
> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Co
mpiled
> 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.WorkRolledbackException: 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(ConnectionPool.java:166)
> at
> com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:821)
> at
> mckhboc.utils._sqlcommand_jsp_2._jspService(_sqlcommand_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$JspServletWrapper.service(JspServlet.
java:323)
> at
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.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.StrictServletInstance.doService(ServletManag
er.java:827)
> at
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:167)
> at
> com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServ
let.java:297)
> at
> com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:110)
> at
> com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:
472)
> at
> com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletM
anager.java:1012)
> at
> com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMan
ager.java:913)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:721)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReque
stDispatcher.java:374)
> at
> com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppReques
tDispatcher.java:118)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoke
r.java:239)
> at
> com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cached
Invocation.java:67)
> at
> com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cachea
bleInvocationContext.java:106)
> at
> com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRe
questProcessor.java:154)
> at
> com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListen
er.java:315)
> at
> com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.
java:60)
> at
> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Co
mpiled
> 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




[ Post a follow-up to this message ]



    Sponsored Links  




 



   All times are GMT. The time now is 06:54 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 
Apache Server MySQL for Windows Sendmail
Red Hat Networking SuSe Linux Debian Linux
FreeBSD administration Sun Solaris administration Unix Shell programming
WebSphere Portal Server Exchange 2000 administration PostgreSQL administration
Linux Security Computer Security Firewalls

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register