aspose file tools*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Problem Special character handling" Watch "Problem Special character handling" New topic
Author

Problem Special character handling

Balamurali Thiruppathy
Greenhorn

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,
Balamurali
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: http://aspose.com/file-tools
 
subject: Problem Special character handling