I updated the bluedragon.xml files as shown below but I still get truncated binaries. I know my binaries are not larger than 100MB.
<hoststring>jdbc:mysql://devserver:3306/testdb? blobSendChunkSize=100000000&max_allowed_packet=100000000</ hoststring> On Apr 1, 11:35 am, Matthew Woodward <[email protected]> wrote: > Craig61877 wrote: > > I have an application in Coldfusion that I'd like to port to OpenBD. > > One issue is my binary objects are being truncated on their way back > > from the database. > > This happens in Coldfusion unless you click the checkbox in the > > datasource screen that says 'Enable Blob support', but there is not > > such checkbox in OpenBD. > > Just so it's clear, this is really a database driver setting as opposed > to anything to do with OpenBD specifically. > > This relates to an issue that was pointed out by a couple of other folks > with the administrator datasource forms, namely that the forms don't > contain a "connection string" option, which would allow you to specify > database connection options that are automatically appended to the end > of the host string. > > The good news is that this is fixed in the latest administrator code > that's in SVN. So you can grab the latest admin code from SVN and add > blobSendChunkSize to that field, or you could add this datasource to the > bluedragon.xml file manually and add that option to the end of your host > string. Editing the XML manually is probably quicker if you're looking > for a fast/easy fix. > > Let me know if you need help with this--this is easy to resolve using > one of these options. > > And a general comment--databases each have their own very long list of > options that you can pass to them when you make connections, but if > there are very common ones that people use, I can add them to the > datasource forms to make everyone's lives a bit easier. Let me know > which ones people would use most. > > -- > Matt Woodward > [email protected]http://www.mattwoodward.com/blog > > Please do not send me proprietary file formats such as Word, PowerPoint, etc. > as attachments.http://www.gnu.org/philosophy/no-word-attachments.html > > smime.p7s > 4KViewDownload --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
