wood burning stoves
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB Error" Watch "DB Error" New topic

DB Error

Bob Paul

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: 1141

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:


Good Luck,
Bob Paul

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: 1141

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,
gopi sri

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,
I agree. Here's the link: http://aspose.com/file-tools
subject: DB Error
It's not a secret anymore!