https://issues.apache.org/bugzilla/show_bug.cgi?id=50387
Summary: Insert CLOB or BLOB with Oracle connection crashes
software
Product: Tomcat 6
Version: 6.0.29
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: Servlet & JSP API
AssignedTo: dev@tomcat.apache.org
ReportedBy: beau.hutche...@thomsonreuters.com
Overview:
Stored Procedure using CLOB or BLOB with oracle driver & spring framework
crashes software upon insert.
Actual Results:
The application crashes with a 500 internal server error
Expected Results:
CLOB or BLOB data should be inserted into database and application should not
crash.
Occurs Also on Builds: 5.0.30 and 5.0.31
Doesn't Occur on Builds: 6.0.20 and 6.0.26
The error log is below. I thought that this error was gone with Tomcat 6.x, yet
it has reappeard in 6.0.29. I have concluded that the error has to do with the
DBCP library that Tomcat uses. Therefore, i replaced the 6.0.29 tomcat-dbcp.jar
(243 KB) with the 6.0.26 tomcat-dbcp.jar (227 KB) and the error does not occur.
I would like to make development aware that this error has come back and i hope
that this error does not make it to Tomcat 7. Thank you. Johnny Coder
at oracle.sql.BLOB.createTemporary(BLOB.java:587)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.prepareLob(OracleLobHandler.java:393)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:340)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setBlobAsBinaryStream(OracleLobHandler.java:243)
at
my.application.attachment.dao.JdbcAttachmentDao$1.setValues(JdbcAttachmentDao.java:58)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:796)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at
my.application.attachment.dao.JdbcAttachmentDao.uploadAttachment(JdbcAttachmentDao.java:44)
at
my.application.attachment.biz.AttachmentManager.uploadAttachment(AttachmentManager.java:32)
at
my.application.attachment.util.ImportAttachment.importFile(ImportAttachment.java:35)
at
my.application.attachment.util.UploadAttachmentServlet.handle(UploadAttachmentServlet.java:59)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org
