RE: java.sql.SQLException: Io exception: Broken pipe
Thanks, but
how do you turn off the pool connections ?? It seems to me that all the
default connectors in tomcat 3.2 server.xml comes with a pool component as
shown below. Thanks for your feedback.
!-- Connectors --
!-- Normal HTTP --
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.http.HttpConnectionHandler"/
Parameter name="port"
value="8001"/
/Connector
!--
Uncomment this for SSL support.
You _need_ to set up a server certificate if you want this
to work, and you need JSSE.
1. Add JSSE jars to CLASSPATH
2. Edit java.home/jre/lib/security/java.security
Add:
security.provider.2=com.sun.net.ssl.internal.ssl.Provider
3. Do: keytool -genkey -alias tomcat -keyalg RSA
RSA is essential to work with Netscape and IIS.
Use "changeit" as password. ( or add keypass attribute )
You don't need to sign the certificate.
You can set parameter keystore and keypass if you want
to change the default ( user.home/.keystore with changeit )
--
!--
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.http.HttpConnectionHandler"/
Parameter name="port"
value="8443"/
Parameter name="socketFactory"
value="org.apache.tomcat.net.SSLSocketFactory" /
/Connector
--
!-- Apache AJP12 support. This is also used to shut down tomcat.
--
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.connector.Ajp12ConnectionHandler"/
Parameter name="port" value="8007"/
/Connector
!-- Apache AJP13 support. --
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.connector.Ajp13ConnectionHandler"/
Parameter name="port" value="8009"/
/Connector
-Original Message-
From: Shahed Ali [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 5:04 PM
To: [EMAIL PROTECTED]
Subject: Re: java.sql.SQLException: Io exception: Broken pipe
Yes I have got this error on Solaris 8 TC 3.2.1 JDK 1.3.
I was using a connection pool and when I replaced it,
things were fine.
Regards
Shahed.
- Original Message -
From: "Yin Tse" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 26, 2001 5:24 PM
Subject: java.sql.SQLException: Io exception: Broken pipe
Has anyone ever come across the above problem ? I'm using apache/tomcat
combination in a solaris environment to serve html/servlets. When I start
it
up, everything works fine. If I let it sit and and come back a few hours
later, my login servlet stalls and give me the following message :
java.sql.SQLException: Io exception: Broken pipe
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:189)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:172)
at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3
39)
at DBPartnerManager.authenticate(DBPartnerManager.java:1298)
at LoginServlet.doGet(LoginServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.connector.Ajp13ConnectionHandler.processConnection
(Ajp13ConnectionHandler.java:160)
at
org.apache.tomcat.
RE: java.sql.SQLException: Io exception: Broken pipe
He's talking about a database connection pool. What looks like what is
happening is that you open a connection to the DB once at the beginning,
then save it for later. When you come back in several hours, the DB has
dropped the connection, so when you try to use it, you get that message. If
this is the case, than you need to recreate your connection or better
monitor your connection to see if it has been dropped.
Regards,
Paul
-Original Message-
From: Yin Tse [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 9:43 PM
To: '[EMAIL PROTECTED]'
Subject: RE: java.sql.SQLException: Io exception: Broken pipe
Thanks, but
how do you turn off the pool connections ?? It seems to me that all the
default connectors in tomcat 3.2 server.xml comes with a pool component as
shown below. Thanks for your feedback.
!-- Connectors --
!-- Normal HTTP --
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.http.HttpConnectionHandler"/
Parameter name="port"
value="8001"/
/Connector
!--
Uncomment this for SSL support.
You _need_ to set up a server certificate if you want this
to work, and you need JSSE.
1. Add JSSE jars to CLASSPATH
2. Edit java.home/jre/lib/security/java.security
Add:
security.provider.2=com.sun.net.ssl.internal.ssl.Provider
3. Do: keytool -genkey -alias tomcat -keyalg RSA
RSA is essential to work with Netscape and IIS.
Use "changeit" as password. ( or add keypass attribute )
You don't need to sign the certificate.
You can set parameter keystore and keypass if you want
to change the default ( user.home/.keystore with changeit )
--
!--
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.http.HttpConnectionHandler"/
Parameter name="port"
value="8443"/
Parameter name="socketFactory"
value="org.apache.tomcat.net.SSLSocketFactory" /
/Connector
--
!-- Apache AJP12 support. This is also used to shut down tomcat.
--
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.connector.Ajp12ConnectionHandler"/
Parameter name="port" value="8007"/
/Connector
!-- Apache AJP13 support. --
Connector className="org.apache.tomcat.service.PoolTcpConnector"
Parameter name="handler"
value="org.apache.tomcat.service.connector.Ajp13ConnectionHandler"/
Parameter name="port" value="8009"/
/Connector
-Original Message-
From: Shahed Ali [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 5:04 PM
To: [EMAIL PROTECTED]
Subject: Re: java.sql.SQLException: Io exception: Broken pipe
Yes I have got this error on Solaris 8 TC 3.2.1 JDK 1.3.
I was using a connection pool and when I replaced it,
things were fine.
Regards
Shahed.
- Original Message -
From: "Yin Tse" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 26, 2001 5:24 PM
Subject: java.sql.SQLException: Io exception: Broken pipe
Has anyone ever come across the above problem ? I'm using apache/tomcat
combination in a solaris environment to serve html/servlets. When I start
it
up, everything works fine. If I let it sit and and come back a few hours
later, my login servlet stalls and give me the following message :
java.sql.SQLException: Io exception: Broken pipe
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:189)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:172)
at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3
39)
at DBPartnerManager.authenticate(DBPartnerManager.java:1298)
at LoginServlet.doGet(LoginServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.ser
RE: java.sql.SQLException: Io exception: Broken pipe
Yes, I was talking about database connection pooling. I am now using the pool manager from javaexchange. Pretty Good !!! (www.javaexchange.com) Regards Shahed. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
