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