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/%3c2054811491.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. > > > On Fri, 24 Apr 2009 09:40:21 +1000, charlie arehart > <[email protected]> wrote: > >> >> Great to hear. Thanks. >> >> /charlie >> >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On >> Behalf >> Of Andrew Myers >> Sent: Thursday, April 23, 2009 6:51 PM >> To: [email protected] >> Subject: [cfaussie] Re: Apache Derby & CF7 >> >> >> Hi Charlie, >> >> Thank you kindly for this. I was actually in the process of working >> this >> out for myself because I was sure it could be done because I'd seen >> Derby >> embedded in web applications running under Tomcat before and was certain >> it would also run with CF. I had actually got as far as getting the >> connection to succesfully verify, but appreciate you posting the blog >> entry and other links. The 1-minute Derby Query Manager in particular >> is >> going to be a massive help. :-) >> >> All the best, >> Andrew. >> >> >> >> >> > > > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
