Ok i am completely stuck with this one. I have the following bit of code that reads data from the an Oracle table (Note: This is running on Jdk 1.4.2)
The data in the MESSAGE_DATA column contains text but also control characters that separate data elements in the message (i.e (char)31, (char)29) and (char)28) .
What i am finding is that for some reason message.getString() is sometimes truncating the message. I can read the majority of messages but some of them are truncated. Am i supposed to be reading the data using a different method? If so how?
I have tried to use sqlplus to look at the data in the database and it is all there it is just truncated by the message.getString() method. I saw this when i tried to output the result i.e. System.out.println(message.getString()).
I ran an sql query using the length() function in Oracle and length("MESSAGE_DATA") returns 2032 whereas in
java message.getString(1).length() returns 2000. Im not sure why this is happening.
Thanks
ps. Also posted on
http://forums.oracle.com/forums/post!default.jspa?forumID=922