Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Error

 
Bob Paul
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic