Using DbForms v2.3, we are trying to upload (copy) a file using diskblob.
In the dbForms-config, we have defined the field as follows:
<table name="FICHE_GLOBL" blobHandling="classic">
...
<field name="NOM_FICH_ILLST" fieldType="diskblob" size="30" directory="D:\applfich\data\dt\images" />
…
</table>
When trying to upload a file using <db:file>, the following error occurs:
------------------------------------------------------------------
could not store file 'C:\CONFIG.SYS' to dir 'D:\applfich\data\dt\images'
-------------------------------------------------------------------------
787392 [http8080-Processor3] DEBUG org.dbforms.config.JDBCDataHelper - fillPreparedStatement( ps, 11, HQ, 1)...
787402 [http8080-Processor3] ERROR org.dbforms.event.datalist.dao.DataSourceJDBC - java.io.FileNotFoundException: D:\applfich\data\dt\images\C:\CONFIG.SYS (Syntaxe du nom de fichier, de répertoire ou de volume incorrecte)
787402 [http8080-Processor3] ERROR org.dbforms.servlets.Controller - ::process - SQLException:
java.sql.SQLException: could not store file 'C:\CONFIG.SYS' to dir 'D:\applfich\data\dt\images'
at org.dbforms.event.datalist.dao.DataSource.saveBlobFilesToDisk(DataSource.java:576)
at org.dbforms.event.datalist.dao.DataSourceJDBC.doInsert(DataSourceJDBC.java:450)
at org.dbforms.event.datalist.dao.DataSourceFactory.doInsert(DataSourceFactory.java:263)
at org.dbforms.event.datalist.InsertEvent.processEvent(InsertEvent.java:126)
Note that if we set the encoding attribute to true. The file is saved properly! However, our requirements are to have the file retain its name.
Thanks for your help