Question
500 NULL error on DB Insert (SQL Server)
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?
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?
AdChoices