Thanks Dziugas.
-I added the interceptor data (silly me!). I'm using ver 2.3.
-Data gets uploaded correctly (image and file name)
-Still can't view the image I'm getting the error displayed below.
-I will debug to see if I can nail the problem.
One question? Why does the file name get stored with the full path? Once it
is stored in the server local path reference is really of no use I believe.
Thanks!
Julio
ERROR MESSAGE:
java.io.StreamCorruptedException: invalid stream header
at
java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:737)
at java.io.ObjectInputStream.(ObjectInputStream.java:253)
at
org.dbforms.servlets.FileServlet.readDbFieldBlob(FileServlet.java:241)
at org.dbforms.servlets.FileServlet.doGet(FileServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:534)
-----Original Message-----
From: Dziugas Baltrunas [mailto:[EMAIL PROTECTED]
Sent: Friday, July 16, 2004 2:27 AM
To: Julio Ortuzar O.
Cc: [EMAIL PROTECTED]
Subject: Re: [dbforms] Blob Errpr MySQL
Hi,
I guess the problem is the name of the file. If you are using a "new"
(contra to "classic") mode, you must define interceptors in the
dbforms-config.xml like this:
<interceptor className="org.dbforms.event.BlobInterceptor">
<param name="blob-column" value="file"/>
<param name="name-column" value="filename"/>
</interceptor>
It's because of the code in FileServlet.java, which throws IOException
if fileName is missing.
regards,
Dziugas Baltrunas
Julio Ortuzar O. wrote:
> Hello,
>
>
>
> I'm trying to use blob field in MySQL and I can upload the image to the
> database with no problem. But when I try to view the image I get the
> error shown at the bottomb.
>
>
>
> -The link to the image that gets generated seems to be correct:
>
> http://localhost:8080/erpfrux/servlet/file?tf=33_12&keyval=0:1:3
>
>
>
> -he config file looks something like this:
>
> <table name="tbl_growers"
>
> defaultVisibleFields="grower_id">
>
> ..
>
> <field name="grower_obs_pic" fieldType="blob"
> size="65535"/>
>
>
>
> -I know the image is stored correct, because when I look directly at the
> database I can see the image through the MySQL client.
>
>
>
> -Last but not least, if I use diskblob instead, everything works perfect.
>
>
>
> Rgds,
>
>
>
> Julio
>
>
>
>
>
> ERROR MESSAGE:
>
> java.io.StreamCorruptedException: invalid stream header
>
> at
> java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:737)
>
> at java.io.ObjectInputStream.(ObjectInputStream.java:253)
>
> at
> org.dbforms.servlets.FileServlet.readDbFieldBlob(FileServlet.java:241)
>
> at org.dbforms.servlets.FileServlet.doGet(FileServlet.java:160)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
>
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
>
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
>
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
>
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>
> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
>
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
>
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
>
> at java.lang.Thread.run(Thread.java:534)
>
>
>
>
>
>
>
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
