Professional Web Applications Themes

500 NULL error on DB Insert (SQL Server) - Coldfusion Database Access

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

  1. #1

    Default 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?

    jgmoore Guest

  2. #2

    Default Re: 500 NULL error on DB Insert (SQL Server)

    <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

    The ScareCrow Guest

  3. #3

    Default Re: 500 NULL error on DB Insert (SQL Server)

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



    jgmoore Guest

  4. #4

    Default Re: 500 NULL error on DB Insert (SQL Server)

    Did you increase the requesttimeout ?

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

    Ken
    The ScareCrow Guest

Similar Threads

  1. JavaScript error in Insert Record server behavior
    By FredMurphy in forum Dreamweaver AppDev
    Replies: 2
    Last Post: July 22nd, 12:09 PM
  2. odbc insert null error
    By bflophil in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: February 18th, 10:09 PM
  3. INSERT Null value problem
    By Targa in forum ASP Database
    Replies: 8
    Last Post: May 15th, 03:50 AM
  4. ASP SQL Insert NULL Date Value
    By Chad S in forum ASP
    Replies: 5
    Last Post: February 19th, 07:33 PM
  5. Insert date to SQL server creates error
    By Ross Francis in forum ASP Database
    Replies: 1
    Last Post: September 2nd, 12:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139