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
-~----------~----~----~----~------~----~------~--~---
