File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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)
I agree. Here's the link:
subject: Problem Special character handling
It's not a secret anymore!