Store large XML strings using Entity Framework

Store large XML strings using Entity Framework

Postby Bas1972 » Fri 29 Aug 2008 13:02

I am trying to store a large XML-string in a Oracle database field of type XMLType, using the Entity Framework. When I try to store small XML-strings in this field, everything works fine. When I try to store a large XML-string however, I get the following error message:

CoreLab.Oracle.OracleException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered


It looks like only part of the XML is passed into the XMLType field, which causes the exceptions. Does anybody know if there is a limitation to the size of a string you can store using CoreLab.Oracle? If so, is there a way to change this?

Thanks in advance,
Bas
Bas1972
 
Posts: 3
Joined: Fri 29 Aug 2008 12:37

Postby Shalex » Mon 01 Sep 2008 08:09

Can you please tell us the size of your XML-string when this exception arises? We will try to reproduce the error.
Shalex
Devart Team
 
Posts: 7304
Joined: Thu 14 Aug 2008 12:44

Postby Bas1972 » Mon 01 Sep 2008 10:02

The size of the XML-string I am trying to save is 439908 of length.

I have done some other small tests to find out at which size errors occur. It looks like I can't insert XML-strings with a length bigger than 4000. When I try to insert a string slightly bigger than 4000, I get a different error message:
"ORA-01461: can bind a LONG value only for insert into a LONG column"

When the size of the XML-string is bigger than 8000 I get the error I initially posted.
Bas1972
 
Posts: 3
Joined: Fri 29 Aug 2008 12:37

Postby Shalex » Tue 02 Sep 2008 10:39

We are investigating this problem. You will be notified as soon as possible.
Shalex
Devart Team
 
Posts: 7304
Joined: Thu 14 Aug 2008 12:44

Postby Bas1972 » Tue 16 Sep 2008 09:28

Shalex, can you give me an update of the status of the investigation of this problem? Thanks in advance!
Bas
Bas1972
 
Posts: 3
Joined: Fri 29 Aug 2008 12:37

Postby Shalex » Tue 23 Sep 2008 14:45

The problem is fixed. Look forward to the next build that will be available in several days.
Shalex
Devart Team
 
Posts: 7304
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 29 Sep 2008 13:38

The new build of OraDirect .NET version 4.75.43 is available!
Please visit http://www.devart.com/forums/viewtopic.php?t=12982
Shalex
Devart Team
 
Posts: 7304
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle