You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by kai <ka...@gmail.com> on 2010/06/08 19:02:21 UTC

Oracle XMLType Column.

Hi,

When I try to insert a XML object into a XMLType column in Oracle with
more than 4000 characters, I get the following exception.
ORA-01461: can bind a LONG value only for insert into a LONG column

Is there anyway we can work around that? My mapping works fine when
the XML can be serialized with less than 4000 characters.

I am using OpenJpa 1.2.2 and Oracle 10g with Spring + OpenJpaVendorAdapter.

Any help would be greatly appreciated. Thanks.

Kelvin

Re: Oracle XMLType Column.

Posted by Kelvin Law <ka...@gmail.com>.
Hi Milosz

I am using oracle's jdbc driver version10.2.0.4.0

JIRA has been created: https://issues.apache.org/jira/browse/OPENJPA-1691

Thanks.


On 10 Jun 2010, at 4:01 AM, Miłosz wrote:

> Hi Kelvin,
> 
> I was able to reproduce the exception and will try to provide a patch or workaround. In the meantime you could create a JIRA [1] ticket for this issue.
> 
> What version of JDBC driver are you using? Is it possible that you give it a try with the most recent one if it is not?
> 
> Greetings,
> Milosz
> 
> [1] https://issues.apache.org/jira/browse/OPENJPA
> 
> 
>> Hi,
>> 
>> When I try to insert a XML object into a XMLType column in Oracle with
>> more than 4000 characters, I get the following exception.
>> ORA-01461: can bind a LONG value only for insert into a LONG column
>> 
>> Is there anyway we can work around that? My mapping works fine when
>> the XML can be serialized with less than 4000 characters.
>> 
>> I am using OpenJpa 1.2.2 and Oracle 10g with Spring + OpenJpaVendorAdapter.
>> 
>> Any help would be greatly appreciated. Thanks.
>> 
>> Kelvin
>

Re: Oracle XMLType Column.

Posted by Miłosz <mt...@o2.pl>.
Hi Kelvin,

I was able to reproduce the exception and will try to provide a patch or workaround. In the meantime you could create a JIRA [1] ticket for this issue.

What version of JDBC driver are you using? Is it possible that you give it a try with the most recent one if it is not?

Greetings,
Milosz

[1] https://issues.apache.org/jira/browse/OPENJPA


> Hi,
> 
> When I try to insert a XML object into a XMLType column in Oracle with
> more than 4000 characters, I get the following exception.
> ORA-01461: can bind a LONG value only for insert into a LONG column
> 
> Is there anyway we can work around that? My mapping works fine when
> the XML can be serialized with less than 4000 characters.
> 
> I am using OpenJpa 1.2.2 and Oracle 10g with Spring + OpenJpaVendorAdapter.
> 
> Any help would be greatly appreciated. Thanks.
> 
> Kelvin