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(DataSourceJDBC.ja
va:583)
at
org.dbforms.event.datalist.dao.DataSourceFactory.doUpdate(DataSourceFact
ory.java:267)
at
org.dbforms.event.datalist.UpdateEvent.processEvent(UpdateEvent.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.internalDoFilter(Applica
tionFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
at
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFi
lter.java:226)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
Base.java:475)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
va:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.netbeans.modules.web.monitor.catalina.MonitorValve.invoke(MonitorVal
ve.java:148)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
7)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.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
