Discussion:
java.sql.SQLException: IO Error: encoded string too long: 126164 bytes
Duncan Groenewald
2006-06-09 19:10:50 UTC
Permalink
I get this error when trying to insert a long piece of text into a
longvarchar field. This seems to be a new problem because I already
have a record in the same table and was copying it to another record
when I got the error.

Any ideas and what is wrong or how I got the record inserted in the
first place. I was under the impression than longvarchar has a limit of
around 1 billion characters, did I misunderstand something ?

Thanks
Duncan


---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
Duncan Groenewald
2006-06-09 19:17:10 UTC
Permalink
Mmm.. I just used the following command and things worked fine:

insert into HTMLTemplates (Code, Description, HTML)
select '004', 'New Template', HTML
from HTMLTemplates
where Code = '001'

and it worked just fine.

Not sure if this helps but is the problem perhaps with the JDBC driver ?
Or could it be a java bug ?

Duncan
Post by Duncan Groenewald
I get this error when trying to insert a long piece of text into a
longvarchar field. This seems to be a new problem because I already
have a record in the same table and was copying it to another record
when I got the error.
Any ideas and what is wrong or how I got the record inserted in the
first place. I was under the impression than longvarchar has a limit
of around 1 billion characters, did I misunderstand something ?
Thanks
Duncan
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
Nicholas Daniels
2006-06-09 21:20:07 UTC
Permalink
I ran into a similar problem no so long ago. It seems to occur when the
SQL command, in total size, exceeds 64K.

Nick
Post by Duncan Groenewald
insert into HTMLTemplates (Code, Description, HTML)
select '004', 'New Template', HTML
from HTMLTemplates
where Code = '001'
and it worked just fine.
Not sure if this helps but is the problem perhaps with the JDBC driver ?
Or could it be a java bug ?
Duncan
Post by Duncan Groenewald
I get this error when trying to insert a long piece of text into a
longvarchar field. This seems to be a new problem because I already
have a record in the same table and was copying it to another record
when I got the error.
Any ideas and what is wrong or how I got the record inserted in the
first place. I was under the impression than longvarchar has a limit
of around 1 billion characters, did I misunderstand something ?
Thanks
Duncan
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
Tobias Downer
2006-06-09 22:58:14 UTC
Permalink
Duncan,

Could you post a complete stack trace of the original error, and any
error that may be in the 'debug.log' file in your log directory.

Thanks,
Toby.
Post by Duncan Groenewald
insert into HTMLTemplates (Code, Description, HTML)
select '004', 'New Template', HTML
from HTMLTemplates
where Code = '001'
and it worked just fine.
Not sure if this helps but is the problem perhaps with the JDBC driver ?
Or could it be a java bug ?
Duncan
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
Duncan Groenewald
2006-06-15 11:40:33 UTC
Permalink
How do I get a complete stack trace. I also checked the log file and
there does not seem to be any error written when I get the error message
on the client. Is there a trace or debug setting to log more information ?

Duncan
Post by Tobias Downer
Duncan,
Could you post a complete stack trace of the original error, and any
error that may be in the 'debug.log' file in your log directory.
Thanks,
Toby.
Post by Duncan Groenewald
insert into HTMLTemplates (Code, Description, HTML)
select '004', 'New Template', HTML
from HTMLTemplates
where Code = '001'
and it worked just fine.
Not sure if this helps but is the problem perhaps with the JDBC
driver ? Or could it be a java bug ?
Duncan
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Loading...