500 NULL error on DB Insert (SQL Server)

[jgmoore]

I am getting a "500 NULL" error when inserting a large textfile into a "Text"
column in SQL Server. I am running MX 7.0.1 on Windows 2000 Server with SQL
2000 SP4. I'm using the default JDBC drivers that shipped with MX 7 (and could
have been updated with the 7.0.1 updater). After isolating sections of my
code, I have created a easily reproducible problem. The error is the nasty
"500 NULL" error. The page only returns the text "500 NULL" (title is JRun
Servlet Error) with no CF debug or error messages. The exception.log contains
a corresponding entry for each occurance of this with the message
"java.lang.OutOfMemoryError".

My test code reads in a 14MB text file and stores it in a variable. It then
performs a cfquery insert statement and tries to insert this variable's
contents into a SQL server database table. The column is configured as "Text".
I have configured the datasource in the CF Admin to enable long text
retrieval. That's all my code does - 6 lines - read file from the file system
and try to insert into the database. It fails with the "500 NULL" error every
time.

CF is installed in the standalone configuration (that hides the underlying
JRun).

Does anyone have any thoughts on resolving this?

[The ScareCrow]

<a target=_blank class=ftalternatingbarlinklarge
href="http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:3903
6">Here</a> is a link I found that may help.

I would also suggest that it would be more effiecent to create a stored
procedure to read the file and insert into the column.
Ken

[jgmoore]

<blockquote>quote:<br><hr><i>Originally posted by: <b><b>The
ScareCrow</b></b></i>
<a target=_blank class=ftalternatingbarlinklarge
href="http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:3903
6">Here</a> is a link I found that may help.

I would also suggest that it would be more effiecent to create a stored
procedure to read the file and insert into the column.
Ken<hr></blockquote>

Following the instructions in that message, I disabled HTTP status codes in
the CF administrator, but I am still getting the "500 null" error. I stopped
and started ColdFusion - same results - I still get a 500 null error. Thanks
for the help - any other suggestions? I will have to find out if I have access
to create strored procedures, but I would prefer to do this in ColdFusion. I
didn't have this problem under MX6.1.

Thanks.

[The ScareCrow]

Did you increase the requesttimeout ?

Other than the sp solution I'm afraid I can't help

Ken