Thanks for bug reporting - i just fixed it! Thanks again, Henner Kollmann
> -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Manjuka Soysa > Gesendet: Donnerstag, 18. März 2004 12:56 > An: [EMAIL PROTECTED] > Betreff: BUG FIX - Re: [dbforms] Problem with diskBlob upload > > Hi, > Found the bug causing the problem: > > The JDBCDataHelper.java file, a break statement was missing > in a switch. > case FieldTypes.DISKBLOB: > ps.setObject(col, value, FieldTypes.CHAR); > add this>>>>>>>> break; > default : > ps.setObject(col, value, fieldType); > > This caused the default to be called after setObject for a diskblob. > cheers, > Manjuka > > --- Manjuka Soysa <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I have setup dbforms with mysql and tomcat.. and it was > great to see > > how easy it is to work with. > > Wondering if anyone else had this problem with diskBlob > fields. I have > > two fields front_image and back_image defined in a table like: > > > > ================================================= > > <field name="front_image" > > fieldType ="diskblob" > > directory="d:\templates" > > encoding="true"/> > > ================================================= > > > > And to create a new record, I have this in a dbforms:footer > (like in > > the examples): > > > > ================================================= > > <tr bgcolor="#fee9aa"> > > <td>Front Image</td> > > <td><db:file id="pic1" fieldName="front_image" > > accept="image/*" /></td> > > </tr> > > <tr bgcolor="#fee9aa"> > > <td>Back Image</td> > > <td><db:file id="pic2" fieldName="back_image" > > accept="image/*" /></td> > > </tr> > > <tr> > > <td><db:insertButton caption="button.submit" > > followUp="/templates.jsp" > > followUpOnError="/newtemplate.jsp"/></td> > > > > ================================================ > > > > But when I click the insert button, I get an Unknown Types > value error > > (stackTrace Below). Any help is greatly appreciated. Thanks! > > Manjuka > > ================================================ > > 561140 [http8080-Processor4] ERROR > > org.dbforms.servlets.FileServlet - ::readDis kBlob - file > > > [d:\projects\idcard\tomcat\webapps\neo/Police2_front.jpg] > > not found > > > > 713422 [http8080-Processor3] ERROR > > org.dbforms.servlets.FileServlet - ::readDis kBlob - file > > > [d:\projects\idcard\tomcat\webapps\neo/Police1_front.jpg] > > not found > > > > 744562 [http8080-Processor2] ERROR > > org.dbforms.servlets.FileServlet - ::readDis kBlob - file > > > [d:\projects\idcard\tomcat\webapps\neo/Police1_front.jpg] > > not found > > > > 1015875 [http8080-Processor2] ERROR > > org.dbforms.servlets.Controller - ::process > > - SQLException: > > java.sql.SQLException: Unknown Types value > > at > > > com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:863 > > ) > > at > > > com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:892 > > ) > > at > > > org.dbforms.config.JDBCDataHelper.fillPreparedStatement(JDBCDataHelpe > > > > Find local movie times and trailers on Yahoo! > > Movies. > > http://au.movies.yahoo.com > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux > > tutorial presented by Daniel Robbins, President and CEO of GenToo > > technologies. Learn everything from fundamentals to system > > > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > > _______________________________________________ > > DbForms Mailing List > > > > http://www.wap-force.net/dbforms > > Find local movie times and trailers on Yahoo! Movies. > http://au.movies.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials Free > Linux tutorial presented by Daniel Robbins, President and CEO > of GenToo technologies. Learn everything from fundamentals to > system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
