LOBs Gotcha in ColdFusion
A few weeks ago I wrote a post about how to Save/Download files to/from Oracle using ColdFusion. The example I used in the post was about saving Excel files as a BLOB in an Oracle table.
Today, I ran across an issue with file sizes greater than 244 KB. I was testing with a 7 MB Excel file. The file was correctly saved in Oracle and I could see that the BLOB size was indeed 7MB (using dbms_lob.getlength). However, when I tried to download it, it would not download more than 244 KB.
After some research, it turns out that, in the ColdFusion administrator (CFMX V7), if you go to Data Sources under Data & Services and edit the data source you used to retrieve the BLOB, there is a setting under the Advanced Settings to Enable binary large object retrieval (BLOB). In my case, it was unchecked. So, make sure to check this checkbox if you want to return the entire contents of any BLOB column in the database for your data source. If not checked, ColdFusion MX retrieves the amount specified in the BLOB Buffer setting, which, in my case, was 250000 bytes or approximately 244 KB. That explains it!
To summarize, if your application uses BLOBs or CLOBs to store/retrieve data from the database and you do not know (or do not want to enforce) what the maximum size of your BLOB or CLOB data is, make sure to check the Enable binary large object retrieval (BLOB) or Enable long text retrieval (CLOB) settings for your datasource in the ColdFusion administrator.
Filed in ColdFusion, Oracle with 4 Comments | Tags: gotcha, lobSaving/Downloading files to/from Oracle using ColdFusion
Here is how to store and download Excel files to/from an Oracle database using ColdFusion.
Filed in ColdFusion, Oracle with 34 Comments | Tags: database, lobsee-quel wins, but what about the others?
My last post about how to pronounce a few “words” generated several comments, some of them were funny. “see-quel” was the clear winner in how to pronounce SQL.
To continue having fun and to settle once and for all how the following “words” are pronounced, I will let democracy take its course in the form of the following short polls:
<br/>
Cast your vote and let the most used pronunciation win!
Filed in Oracle, Technology with 6 Comments | Tags: lob, pl/sql, pronunciation, sqlChar or Car?
This post has no real value except to satisfy a curiosity I have had since I started developing Oracle applications. Through out my career as an Oracle developer, almost every time I meet or listen to someone I hear different pronunciation for a few common acronyms and datatypes. For example:
- SQL: I pronounce it “see-quel”, others just spell it “S-Q-L”
- CHAR (also VARCHAR): I pronounce it “char” as in charcoal, others pronounce it “car”
- CLOB: I pronounce it “see-lob”, others pronounce it “klob”
- BLOB: I pronounce it “bee-lob”, others pronounce it “blob”
- WSDL: I pronounce it… well, I just spell it: “W-S-D-L”, others pronounce it “wizdel”
- BPEL: I pronounce it “bee-pl”, others pronounce it…well, I have not heard anyone pronouncing it differently yet. In fact, the rhyme goes: “BPEL is good for the people”.
The question is: is there a “right” way to pronounce technical terms? Does it matter? For me, I just use whatever is easier on my tongue.
Here is a quick poll I just created on dPolls.com, a cool (uses AJAX) and free online poll service:
<br/>
