I can't speak to MSSQL or Oracle, but I use MySQL for images and other media.
On upload into MySQL with ODBC, there is a max_allowed_packet variable that will limit the size of data coming into the db. This defaults to 1 MB; larger files sizes cause an error. Maybe there is a similar variable in OCI. The witango config variable ITEMBUFFERSIZE has a 64k default on elements returned from db. Maybe your images are larger. >Hey All! > >In an issue I hate revisiting, I've got a problem uploading images (jpg) >from a form into an Oracle database. This time I've done a bit more >experimentation on the code but I still don't have a solution to get it >work. > >Basically, what I'm trying to do is take a file submitted with <input >type="file"....> via <form encytype="multipart/form-data" ...> and store it >in a BLOB field in Oracle 8.2 using OCI. I'm using Windows 2000, Apache 2.0, >Witango 5.0. > >The code I'm working on had previously been run on a Sun box, with >Witango2000 and prior and Apache (not sure of version). During an upgrade of >either Apache or WiTango the code stopped working. There are images in the >database from when the routine worked, and I can download them and display >them using <img src="Image.taf?id=123" ...> without a problem. > >Here's where it gets weird. I was concerned that it was an Apache upgrade >that broke the routine. So I tried moving the information over to a MySQL >database figuring I'd get the same problem. But it worked fine! So now I >began thinking that this problem was maybe related to the database >connection method. So I tried using the Oracle ODBC and the Microsoft Oracle >ODBC. The MS Oracle ODBC didn't work at all. However, the Oracle ODBC did, >kind of. The problem is it looks like its corrupting the data about a >quarterway through the images (Firebird displays the image out of focus, IE >gives red x). > >I've got itembuffersize set to 5mb, and the files I'm sampling are like >40kb. > >Based on the process of elimination, I'm left with two culprits that could >be causing the problems, Oracle or WiTango. > >Is anybody doing something similar (with Oracle, Apache 2.0, Windows, and >WiTango 5.0) and have it working perfectly, even if its not necessarily >jpegs, but some other binary data? Or any insight? I really need to make >this code work... (we're migrating to storing the images in the filesystem, >but we can't do that yet because of factors outside our power). > >Thanks! > >Jonah Simpson > > >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
