java.sql.SQLException: Stream has already been closed

[Fernando Dominguez]

Hello,
I'm using ORACLE when I execute this method I get a java.sql.SQLException: Stream has already been closed.
Could anyone take a quick look at the following code, please?

public DetalleEncargo getDetalleEncargo(long argEncargo) throws Exception{
	
	String sql = "SELECT ID, NUM,  PLANOS, DESC, NOMBRE_CLI, TELEFONO_CLI, "
		+ " FEC_ENCARGO, EST, NOMBRE_COM FROM ENCARGO WHERE ID = ? ";
			
	
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	try{
		Connection conn = connect();
		pstmt = conn.prepareStatement(sql.toString());
		pstmt.setLong(1, argEncargo);
    		rs = pstmt.executeQuery();
		DetalleEncargo encargo = null;
    		while (rs.next()){
    			encargo = new GESDetalleEncargo();
    			encargo.setIdEncargo(rs.getLong("ID"));
    			encargo.setFechaEncargo(rs.getDate("FEC_ENCARGO"));
    			encargo.setNum(rs.getLong("NUM"));
    			encargo.setPlanos(rs.getLong("PLANOS"));
    			encargo.setDescripcion(rs.getString("DESC"));
    			encargo.setNombreCliente(rs.getString("NOMBRE_CLI"));
    			encargo.setTelefonoCliente(rs.getString("TELEFONO_CLI"));
    			encargo.setNombreCom(rs.getString("NOMBRE_COM"));
    			encargo.setEst(rs.getLong("EST"));

		}
		return encargo;

	}catch(Exception e){

	      log.error("");
	      log.errorSep2();
	      log.error("Error: obteniedo detalle encargo.");
	      log.error("Error: "+e.toString().trim());
	      log.error("SQL: ["+sql+"]");
	      log.errorSep2();
	      log.error("");
			throw new Exception("Error:  getDetalleEncargo",e);

	}finally{
		if (rs !=  null) rs.close();
		if (pstmt != null )pstmt.close();
	}
}	

Thanks.

[Davie Lin]

can you provide the stack trace? does it tell you which line the exception happened?

[Fernando Dominguez]

Of course,

#|2009-11-27T10:46:39.069+0100|WARNING|sun-appserver-pe9.0|javax.enterprise.system.stream.err|_ThreadID=11;_ThreadName=httpWorkerThread-18202-0;_RequestID=95d913d6-3d89-45bf-b28d-1120f2de526f;|java.sql.SQLException: El flujo ya se ha cerrado
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
	at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:151)
	at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:193)
	at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:422)
	at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:397)
	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
	at core.orm.Orm.getDetalleEncargo(Orm.java:102)
	at taller.busquedas.busqueda.execute(Unknown Source)
	at base.main.BaseServlet.doGetPost(BaseServlet.java:200)
	at base.main.BaseServlet.doGet(BaseServlet.java:189)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
	at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
	at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
	at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
	at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)

[Davie Lin]

at core.orm.Orm.getDetalleEncargo(Orm.java:102)

can you re post the line of code at 102 from Orm.java

[Leonardo Carreira]

Hi..

For ensure, check your SQL directly in database.. (in this case the SQL is correct)..

 
String sql = "SELECT ID, NUM,  PLANOS, DESC, NOMBRE_CLI, TELEFONO_CLI, "
		+ " FEC_ENCARGO, EST, NOMBRE_COM FROM ENCARGO WHERE ID = ? ";

You could change your code for while to if, because the result is only one record, isn't it?..

   
    		if (rs.next()){
    			encargo = new GESDetalleEncargo();
    			encargo.setIdEncargo(rs.getLong("ID"));
    			.......

		}
		return encargo;    

try to remove this code, because i think it's useless

    
throw new Exception("Error:  getDetalleEncargo",e);

in that code there's try.. catch.. block, its mean the exception would be caught if happened.., so why we've to throw the exception again (in the catch block)?..

may i know the sequence's method call in your application?..

please correct me if i'm wrong..

Thanks..