I've not seen that issue, no. As for whether it would occur in CF8, well, I don't know. I don't have any clob data to be able to tell. Here's one thought: in the "advanced settings" for a DSN (in the CF Admin) there is an option to enable/disable blob/clob support. What happens if you toggle that?
As for how things would work on 8, that's a good idea for you to be able to know. It's certainly possible that Adobe built something into their CFQUERY code to address Derby issues. That's totally a guess. I'm just suggesting that you may want to install CF8 (the free developer edition) on a machine (just using the built-in web server, so as not to interfere with your current setup) and try things there if they don't work for you in 7. Another thing to keep in mind is that the version of Derby embedded in CF is a little old (10.2) and the version you got (downloaded from Apache) is likely newer, like 10.4. If you were to find that your test worked in CF 8 but failed for you via 7, it could even be that what broke for you was based on something that worked in 10.2 and broke in the later 10.4 you downloaded. That's just a guess. One would hope not, of course. But it's like any software and can have bugs. There's of course a bug tracker, discussion list, and much more for it, being an open source project. Hope that's helpful. /charlie -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrew Myers Sent: Thursday, April 23, 2009 10:45 PM To: [email protected] Subject: [cfaussie] Re: Apache Derby & CF7 By the way casting it in my "select" to a "long varchar" seems to be a workaround, although I'm a little frightened it's going to chomp the end off some of my data... On Fri, 24 Apr 2009 12:02:27 +1000, Andrew Myers <[email protected]> wrote: > Hi Charlie, > > I've run into one problem with this. > > Whenever I do a select on a table with a clob field I get this exception: > > "You cannot invoke other java.sql.Clob/java.sql.Blob methods after > calling the free() method or after the Blob/Clob's transaction has been > committed or rolled back" > > The relevant part of the trace is: > > > java.sql.SQLException: You cannot invoke other > java.sql.Clob/java.sql.Blob methods after calling the free() method or > after the Blob/Clob's transaction has been committed or rolled back. > at coldfusion.sql.QueryTable.resolveObject(QueryTable.java:444) > at coldfusion.sql.QueryTable.populate(QueryTable.java:352) > at coldfusion.sql.QueryTable.populate(QueryTable.java:216) > at coldfusion.sql.Executive.getRowSet(Executive.java:314) > at coldfusion.sql.Executive.executeQuery(Executive.java:778) > at coldfusion.sql.Executive.executeQuery(Executive.java:685) > at coldfusion.sql.Executive.executeQuery(Executive.java:646) > at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) > at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) > > > I did a quick Google and came up with this: > > http://mail-archives.apache.org/mod_mbox/db-derby-dev/200809.mbox/%3C2054811 491.1220416544336.javamail.j...@brutus%3e > > Obviously I can't change anything in the coldfusion.sql.QueryTable class > though :-) > > Do you know if this issue occurs in CF8? > > Thanks, > Andrew. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
