BLOB y jsp....

[jf_jara]

Bueno, viendo que el error no tiene aun exito entre el publico voy a dejar el mensaje de error completo que me da, a ver si asi es mas facil que alguien sepa de que puede ser el error :)


07/07/24 11:37:32 java.sql.SQLException: El tamaño de los datos es mayor que el tamaño máximo para este tipo: 172056
07/07/24 11:37:32 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:189)
07/07/24 11:37:32 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:231)
07/07/24 11:37:32 at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java :99)
07/07/24 11:37:32 at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindIte m(DBDataSetImpl.java:1772)
07/07/24 11:37:32 at oracle.jdbc.driver.OraclePreparedStatement.setItem (OraclePreparedStatement.java:991)
07/07/24 11:37:32 at oracle.jdbc.driver.OraclePreparedStatement.setByte s(OraclePreparedStatement.java:1966)
07/07/24 11:37:32 at org.apache.commons.dbcp.DelegatingPreparedStatemen t.setBytes(DelegatingPreparedStatement.java:134)
07/07/24 11:37:32 at actions.GestionEccmaAction.execute(GestionEccmaAct ion.java:278)
07/07/24 11:37:32 at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:484)
07/07/24 11:37:32 at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
07/07/24 11:37:32 at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
07/07/24 11:37:32 at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:525)
07/07/24 11:37:32 at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
07/07/24 11:37:32 at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
07/07/24 11:37:32 at com.evermind.server.http.ResourceFilterChain.doFil ter(ResourceFilterChain.java:65)
07/07/24 11:37:32 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unkn own Source)
07/07/24 11:37:32 at com.evermind.server.http.ServletRequestDispatcher. invoke(ServletRequestDispatcher.java:604)
07/07/24 11:37:32 at com.evermind.server.http.ServletRequestDispatcher. forwardInternal(ServletRequestDispatcher.java:317)
07/07/24 11:37:32 at com.evermind.server.http.HttpRequestHandler.proces sRequest(HttpRequestHandler.java:790)
07/07/24 11:37:32 at com.evermind.server.http.HttpRequestHandler.run(Ht tpRequestHandler.java:270)
07/07/24 11:37:32 at com.evermind.server.http.HttpRequestHandler.run(Ht tpRequestHandler.java:112)
07/07/24 11:37:32 at com.evermind.util.ReleasableResourcePooledExecutor $MyWorker.run(ReleasableResourcePooledExecutor.jav a:192)
07/07/24 11:37:32 at java.lang.Thread.run(Thread.java:534)


el codigo que uso para insertar es el siguiente:

sql = "INSERT INTO TABLA (dato1, campo_blob) VALUES ( 'valor1',? )";

try {
stm = conexion.prepareStatement(sql);
byte[] arrayByte = new byte[(int)is.available()]; //la variable is es de tipo InputStream
try {
arrayByte = InputStreamToByte(is); //esta funcion pasa de InputStream a Byte
stm.setBytes(1,arrayByte);
stm.executeUpdate();
} ...
...
...


Saludos y muchas gracias! :)