From: "Elliot Russo" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> Subject: RE: [CFCDev] OT: Using JDBC instead of <cfquery> in CFC's Date: Wed, 12 May 2004 10:30:47 +1000
Tested Daniel's MSSQL suggestions with Oracle 9, and had some good success -
thanks Daniel, was something I was interested in also!
Example 2 - did not work as is (didn't try any variations - I'll check the docs)
insert into footable( bar1,bar2) values('#bar1[1]#', '#bar2[1]'), ('#bar1[1]#', '#bar2[1]'), ('#bar1[1]#', '#bar2[1]'), .....
Example 1 - did work with variation - ** NOTE the 'FROM DUAL' clause required
400 records inserted against slow dev server in 1.5 secs!!!!
This syntax is a really good find. However, in running some tests where I tried to do 1,000 entries, I got a 500 null error and my logs said it was a java.lang.StackOverflowError. So I guess there's a ceiling as to the number of records you can use for this construct. However, my tests were going against the bundled MM drivers. Perhaps going against the Oracle-distributed drivers would yields better results?
Anyway, since this isn't CFC-related, I'll end this. Thanks for the tip though.
Regards, Dave.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
