 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Connection Pool | Connection Pool 2003-08-14 - By Rajesh P
Back
Hello Everyone,
I know that this is the wrong forum to ask this question, but I need this help
very deliberately.
I am using Websphere Application Server 4.0 with a Oracle Connection Pool. The
WAS returns a OracleConnectionProxy when requested for a connection from the
ConnectionPool. This connectionfactory needs to be converted to a
OracleConnection class for using the Varrays and structs of Oracle. Everything
works for the very first time that the connection is got. I can access Varrays
without any problems. But if I close the connection and request for one more
connection, I get the error
"java.sql.SQLException  : Logical handle no longer valid".
Can anyone let me know what can be the solution for this, please.
Thanks in advance,
Rajesh
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=204374714-01012003><FONT size=2>Hello
Everyone,</FONT></SPAN></DIV>
<DIV><SPAN class=204374714-01012003><FONT size=2>I know that this is the wrong
forum to ask this question, but I need this help very deliberately.
</FONT></SPAN></DIV>
<DIV><SPAN class=204374714-01012003><FONT size=2>I am using Websphere
Application Server 4.0 with a Oracle Connection Pool. The WAS returns a
OracleConnectionProxy when requested for a connection from the ConnectionPool.
This connectionfactory needs to be converted to a OracleConnection class for
using the Varrays and structs of Oracle. Everything works for the very first
time that the connection is got. I can access Varrays without any problems. But
if I close the connection and request for one more connection, I get the
error</FONT></SPAN></DIV>
<DIV><SPAN class=204374714-01012003>
<P><FONT size=2>"java.sql.SQLException : Logical handle no longer
valid".</FONT></P><SPAN class=204374714-01012003>
<P><FONT size=2>Can anyone let <SPAN class=204374714-01012003>me
</SPAN>know what can be the solution for this<SPAN class=204374714-01012003>,
please.</SPAN></FONT></P></SPAN></SPAN></DIV>
<P><FONT size=2><SPAN class=204374714-01012003>Thanks in advance</SPAN>,
</FONT><BR><FONT size=2>Rajesh</FONT> <BR></P></BODY></HTML>
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|
|
