Which version do you use? I do some bug fixing in DISKBLOBS at the weekend - only in the CVS yet.
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Peter Burri > Gesendet: Montag, 29. September 2003 15:06 > An: [EMAIL PROTECTED] > Betreff: [dbforms] DISKBLOB - Upload Error > > > Hi all, > I have a problem on uploading a DISKBLOB on a > Windows2k/Tomcat4.1.x Plattform. > > Following Error encounters if I want to upload a File (e.g. > d:\Sys\Work\answerfile.xml) into a DIKSBLOB-Field > The Field in Database has been changed but the File has not > been uploaded to the position configured in the > dbforms-config.xml file. What's wrong ? > > > >>>>>>>>>>>>>>> > 221198 [HttpProcessor[8081][4]] INFO > org.dbforms.event.datalist.UpdateEvent - ::getKeyValues - > key: 0:1:1 221198 [HttpProcessor[8081][4]] INFO > org.dbforms.config.Table - UPDATE SCM.VTSCMREPORT SET > RPT_TYPE_OID= ?, MUTUSR= ?, RPT_NAME= ?, TPLFNAME= ? WHERE > RPT_OID = ? 221198 [HttpProcessor[8081][4]] DEBUG > org.dbforms.event.datalist.dao.DataSourceJDBC - Retrieved > curField:RPT_TYPE_OID type:1 221198 [HttpProcessor[8081][4]] > INFO org.dbforms.event.datalist.dao.DataSourceJDBC - > field=RPT_TYPE_OID col=1 value=50 type=1 221198 > [HttpProcessor[8081][4]] DEBUG org.dbforms.util.SqlUtil - > fillPreparedStatement( ps, 1, 50, 1)... 221198 > [HttpProcessor[8081][4]] DEBUG > org.dbforms.event.datalist.dao.DataSourceJDBC - Retrieved > curField:MUTUSR type:2 221198 [HttpProcessor[8081][4]] INFO > org.dbforms.event.datalist.dao.DataSourceJDBC - field=MUTUSR > col=2 value=PBU type=2 221198 [HttpProcessor[8081][4]] DEBUG > org.dbforms.util.SqlUtil - fillPreparedStatement( ps, 2, > PBU, 2)... 221198 [HttpProcessor[8081][4]] DEBUG > org.dbforms.event.datalist.dao.DataSourceJDBC - Retrieved > curField:RPT_NAME type:2 221208 [HttpProcessor[8081][4]] INFO > org.dbforms.event.datalist.dao.DataSourceJDBC - > field=RPT_NAME col=3 value=Answerfile Erstellen type=2 221208 > [HttpProcessor[8081][4]] DEBUG org.dbforms.util.SqlUtil - > fillPreparedStatement( ps, 3, Answerfile Erstellen, 2)... > 221208 [HttpProcessor[8081][4]] DEBUG > org.dbforms.event.datalist.dao.DataSourceJDBC - Retrieved > curField:TPLFNAME type:8 221208 [HttpProcessor[8081][4]] INFO > org.dbforms.event.datalist.dao.DataSourceJDBC - > field=TPLFNAME col=4 value=10648703694708.xml type=8 221208 > [HttpProcessor[8081][4]] DEBUG org.dbforms.util.SqlUtil - > fillPreparedStatement( ps, 4, 10648703694708.xml, 8)... > 221208 [HttpProcessor[8081][4]] DEBUG > org.dbforms.util.SqlUtil - fillPreparedStatement( ps, 5, 1, > 1)... 221279 [HttpProcessor[8081][4]] ERROR > org.dbforms.servlets.Controller - ::process - SQLException: > java.sql.SQLException > at > org.dbforms.event.datalist.dao.DataSource.saveBlobFilesToDisk( > DataSource > .java:470) > at > org.dbforms.event.datalist.dao.DataSourceJDBC.doUpdate(DataSou > rceJDBC.ja > va:583) > at > org.dbforms.event.datalist.dao.DataSourceFactory.doUpdate(Data > SourceFact > ory.java:267) > at > org.dbforms.event.datalist.UpdateEvent.processEvent(UpdateEven > t.java:182 > ) > at > org.dbforms.servlets.Controller.process(Controller.java:217) > at org.dbforms.servlets.Controller.doPost(Controller.java:131) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Applica > tionFilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilt > erChain.java:193) > at > org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter > (MonitorFi > lter.java:226) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Applica > tionFilterChain.java:213) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilt > erChain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValv > e.java:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:566) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:4 > 72) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValv > e.java:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:566) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut > henticator > Base.java:475) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.ja > va:246) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.netbeans.modules.web.monitor.catalina.MonitorValve.invoke( > MonitorVal > ve.java:148) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:4 > 72) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:234 > 7) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java > :180) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:566) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherVa > lve.java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java > :170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:468 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:564) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:4 > 72) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve. > java:174) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.ja > va:566) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:4 > 72) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.j > ava:1027) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.java: > 1125) > at java.lang.Thread.run(Thread.java:534) > 221279 [HttpProcessor[8081][4]] DEBUG > org.dbforms.util.SqlUtil - About to close connection - > DB2Connection { > connectionHandle = 1 > SPConnected = false > source = SCMAN > user = pbu > conArgs = > closed = false > describeCached = false > describeParam = true > isReadOnly = false > autoClose = false > LONGDATA compat = false > } > <<<<<<<<<<<<<<<<<<< > > The jsp looks like this: > >>>>> > <db:dbform multipart="true" > autoUpdate="false" > followUp="<%= request.getServletPath() %>" > maxRows="*" > tableName="SCM.VTSCMREPORT"> > <db:header> > ... > </db:header> > <db:body allowNew="false"> > .. > <td> > <a href="<db:blobURL fieldName="TPLFNAME" />" target="_blank" > >[view]</a><br> > <db:file fieldName="TPLFNAME" /> > </td> > </tr> > </db:body> > <<<<<<<<<<<<<< > And the table definition looks like this > >>>>>>>>>>>>>>>>>>>>>>>>>> > <table name="SCM.VTSCMREPORT"> > <field name="RPT_OID" fieldType="integer" size="10" isKey="true"/> > <field name="RPT_NAME" fieldType="varchar" size="50"/> > <field name="RPT_TYPE_OID" fieldType="integer" size="10"/> > <field name="TPLFNAME" fieldType="diskblob" > directory="/Proj/SCM/Appl/scmwui/src/scmrpt/scmdvtpl" > encoding="true" /> > <field name="MUTUSR" fieldType="varchar" size="32"/> > <<<<<<<<<<<<<<<<<<<< > > Thanks for Help > Regards > Peter > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
