wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Problem Special character handling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Problem Special character handling" Watch "Problem Special character handling" New topic

Problem Special character handling

Balamurali Thiruppathy

Joined: Jan 10, 2006
Posts: 1
Hi Friends,
We are using the hibernate to store the date in the Oracle DB.
While trying to insert the special character like Copy right symbol(�) in the Clob data type we come across the (java.sql.SQLException: No more data to read from socket) Exception. Pls tell me some solution for it.

Thanks in advance,
Reid M. Pinchback
Ranch Hand

Joined: Jan 25, 2002
Posts: 775
I can think of two possible problems.

Oracle databases can be configured to either deal with 8-bit characters or 16-bit characters. If you are trying to insert a 16-bit character into an 8-bit database you could run into problems. Check with your DBA to see how your database is configured.

Another possibility is that it has nothing to do with the character per se. Did you hit this problem while inserting a long string into the clob? If you use JDBC types other than CLOB you'll hit a wall (I think around 32K) when reading or writing data.

Reid - SCJP2 (April 2002)
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Problem Special character handling
Similar Threads
URL Encoding at client side
jQuery.ajax() issue with chrome and IE 8
avoid special character in jsp
Want urgent Help
Special characer in Database + problem in trimming it with trim()