Web server problem...

[anandkl]

Hi Friends,
My developers are facing the below problem when ever they execute their servlet.They are guessing it would be database problem, can you please help me on to resove this issue.

Platform: solaris 5.6
DB:8.1.6
APPLICATION SERVER: WEB LOGIC 6.0 SP 2

PS:You can the message "java.sql.SQLException: Io exception: Broken pipe"

"Failed to get a database connection."

2003-04-29 13:33:50,825 DBservice ERROR [ExecuteThread: '26' for queue: 'default'] () - Failed to get a database connection.
2003-04-29 13:33:59,438 vhub.db.DBservice ERROR [ExecuteThread: '81' for queue: 'default'] () - Error setting autocommit on a database connection: java.sql.SQLException: Io exception: Broken pipe
2003-04-29 13:33:59,438 vhub.db.DBservice ERROR [ExecuteThread: '81' for queue: 'default'] () - Error Code from DB : 17002
2003-04-29 13:33:59,438 Unknown class name ERROR [ExecuteThread: '81' for queue: 'default'] () - java.sql.SQLException: Io exception: Broken pipe
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.OracleConnection.setAutoCommit(OracleConnection.java:435)
at weblogic.jdbcbase.pool.Connection.setAutoCommit(Connection.java:102)
at vhub.db.DBservice.getConnection(DBservice.java:305)
at vhub.db.DBservice.getConnection(DBservice.java:381)
at vhub.db.DBPSaccess.initialize(DBPSaccess.java:252)
at vhub.db.DBPSaccess.prepareLong(DBPSaccess.java:1144)
at vhub.services.stores.Storefront.getCompanyStoreFrontId(Storefront.java:1886)
at vhub.services.stores.Storefront.getCompanyStoreFrontId(Storefront.java:1690)
at jsp_servlet._ads.__ads_create._jspService(__ads_create.java:3656)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1319)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1716)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
2003-04-29 13:33:59,440 DBservice ERROR [ExecuteThread: '81' for queue: 'default'] () - Failed to get a database connection.


I am sorry if we not allowed to post web logic issues.


regards
anandkl

[ggnanaraj]

Download the latest 9.2.0.* Jdbc thin driver from Technet(OTN). Jdbc driver's are backward compatible.

Check these out on metalink...

http://metalink.oracle.com/metalink/..._id=331131.996

http://metalink.oracle.com/metalink/...p_id=43973.999

http://metalink.oracle.com/metalink/..._id=164594.996

HTH.

[shandj]

Check your JDBC Driver. Its not an Oracle Error.