This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB Error" Watch "DB Error" New topic
Author

DB Error

Bob Paul
Greenhorn

Joined: Nov 09, 2008
Posts: 4
Hello everybody,

I am using Apache Tomcat 5.5.20 and Oracle 9i as the database. very frequently the application goes down due to this following error.
ERROR AbstractSQLJAction = SQLException in execute(Object, DAOFindProperties)Io exception: Broken pipe
java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:389)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:944)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:857)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:226)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:328)
at com.shell.septar.pims.business.dao.sqlj.SQLJDAOSecurityItem$2.cmdExecute(Unknown Source)
at com.shell.septar.pims.business.dao.sqlj.AbstractSQLJAction.execute(Unknown Source)
at com.shell.septar.pims.business.dao.sqlj.AbstractSQLJActionSelect.select(Unknown Source)
at com.shell.septar.pims.business.dao.sqlj.SQLJDAOSecurityItem.findByFunctionGroupName(Unknown Source)
at com.shell.septar.pims.business.logic.admin.BLSecurityItem.findByFunctionGroupName(Unknown Source)
at com.shell.septar.pims.web.SessionSecurity.<init>(Unknown Source)
at com.shell.septar.pims.web.SecurityHandler.getAllWorkspaces(Unknown Source)
at com.shell.septar.pims.web.SecurityHandler.getLoggedInWorkSpace(Unknown Source)
at org.apache.jsp.home_jsp._jspService(home_jsp.java:215)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)



However after performing a restart of the Tomcat server , the application becomes up and running for about a day and then the same error causes a shutdown.

Request your help in this issue
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Bob,
What java version are you using and what JDBC driver are you using?
Pardon me if I am stating the obvious, but if you are using an Oracle JDBC driver then it should be one that is compatible with both your java version and your Oracle database version.

See Oracle's JDBC FAQ for compatibility details.
The FAQ can be found on Oracle's technology Web site:

http://www.oracle.com/technology

Good Luck,
Avi.
Bob Paul
Greenhorn

Joined: Nov 09, 2008
Posts: 4
Thanks a lot for the suggestion. But can you let me know what is the exact reason behind this problem. How can it be rectified??
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Bob,
You asked:

can you let me know what is the exact reason behind this problem

No, I can't.
I'm only guessing that it may be due to incompatibilities between the various software components you are using.

Good Luck,
Avi.
gopi sri
Greenhorn

Joined: Nov 11, 2008
Posts: 6
Hai Bob Paul,

i hope you not added Ojdbc jar file in your java class path..
Even if you add ojdbc jar file please check whether it is the latest one becz for oracle 9i you should add ojdbc14 jar file in you drive. Once you added in your drive.set the classpath of ojdbc14 jar file in your java.

with regards,
Gopi
gopinath65@gmail.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB Error
 
Similar Threads
Stale Connection
Tomcat 5.5 and simple JDBC program issue
jboss Oracle dataSource Connection Refused -HPUX Error: 12: Not enough space
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
broken pipe exception(Please help!!!)