Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

An I/O error occured while sending to the backend.

807588Apr 23 2009 — edited Apr 25 2009

I am using Oracle Application Server and PostgreSQL for my application.
When i am calling a procedure it gives me following error. But this happens sometimes not frequently.

I am not able to find out what exactly the problem is.

org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. 
Exception: java.io.IOException: Stream closed 
Stack Trace: 
java.io.IOException: Stream closed 
at java.io.BufferedInputStream.getBufIfOpen(BufferedInputStream.java:145) 
at java.io.BufferedInputStream.read(BufferedInputStream.java:239) 
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:241) 
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1122) 
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:321) 
at common.Functions.getBrokerValues(Functions.java:186) 
at common.BrokerInfoBean.getBrokerValues(BrokerInfoBean.java:212) 
at _common._Index._jspService(_Index.java:90) 
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) 
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416) 
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) 
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719) 
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) 
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870) 
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) 
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) 
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) 
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) 
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) 
at java.lang.Thread.run(Thread.java:595) 
End of Stack Trace

Thanks,

Centinul

Answer

You can try:

SELECT * FROM V$VERSION

SELECT version FROM V$INSTANCE

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;

Marked as Answer by 858277 · Sep 27 2020

25 people found this helpful

onkar.nath

I am not sure what exactly you mean by "what type of database am using " but you can try this:

select from v$version;*

This will give you detailed version number of the database components. You can also use

select from PRODUCT_COMPONENT_VERSION;*

to get various components of the DB with their version.

Onkar

11 people found this helpful

858277

Thanks

1 - 3

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2009

Added on Apr 23 2009

1 comment

932 views

Java Programming

An I/O error occured while sending to the backend.

Comments

Post Details