I'm trying to look for something in java but I'm not familiar with the
ins adn outs. I think the main problem is that I don't know the
username and password (for the eventual production environment). Would
I be able to somehow reuse the DSN used by ColdFusion to connect to
the database?
I'm trying to look for something in java but I'm not familiar with the ins adn
outs. I think the main problem is that I don't know the username and password
(for the eventual production environment). Would I be able to somehow reuse the
DSN used by ColdFusion to connect to the database?
Garth Young wrote:
The problem I have is that the Coldfusion query is not returning as the
result set is too big. I could simply run the query pulling out blocks of
rows from it but this would require re-executing the SQL 6-7 times at least.
Use a cursor:
I suppose I could increase the JVM max memory to 2GB but I'm
not really sure if this is a viable option.
No, it's certainly not an option on Windows generally, and probably not a
viable option for solving this problem on any platform - that's just too big
of a recordset. Do this within the
I suppose I could increase the JVM max memory to 2GB but I'm not
really sure if this is a viable option.
No, it's certainly not an option on Windows generally, and
probably not a viable option for solving this problem on any
platform - that's just too big of a recordset. Do this within
Hi,
There have been previous posts about writing large data files from
database queries and I have the same problem. The files I need to create
may be up to 200-300MB in size (csv). I haven't tried in off-peak time
but when I tried a large queries during normal hours it got a memory
error
,
There have been previous posts about writing large data files from
database queries and I have the same problem. The files I need to create
may be up to 200-300MB in size (csv). I haven't tried in off-peak time
but when I tried a large queries during normal hours it got a memory
error.
Does anyone
I have released a UDF over at cflib.org, that will convert a ColdFusion
query to CSV using JavaString Buffer which is considerably faster.
http://www.cflib.org/udf.cfm?ID=1197
Thanks and let me know if you have any problem.
Qasim
The problem I have is that the Coldfusion query is not
If your result set is bigger than the JVM size, then yes, there is no way
you're going to be able to do anything unless you break it into smaller
pieces or increase the JVM size.
On 7/25/07, Garth Young [EMAIL PROTECTED] wrote:
I have released a UDF over at cflib.org, that will convert a
really don't know what the options are here - maybe open a cursor?
Jaime Metcher
-Original Message-
From: Garth Young [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 25 July 2007 2:14 PM
To: CF-Talk
Subject: Re: Writing large data files
I have released a UDF over at cflib.org
10 matches
Mail list logo