CLOB ClassCastException

[Gul Khan]

Hi
I have a DAO inserting a operating on a CLOB column. The method works fine when run standalone but when I use it inside weblogic 8.1 it throws ClassCastException.

 
sql="select  XML_MSG from MSG_IN where MSG_ID=? for update";
            pstmt=conn.prepareStatement(sql);
            pstmt.setString(1,msg.getMsgId());
            rs=pstmt.executeQuery();
 
            if(rs.next()){
                Clob xmlClob=rs.getClob(1);
                [B]Writer clobWriter = ((oracle.sql.CLOB)xmlClob).getCharacterOutputStream();[/B] // [I]This line throwing Class Cast Exception[/I]
                
                clobWriter.write(msg.getXmlMsgString());
                clobWriter.flush();
                clobWriter.close();
            }

Appreciate any pointers. Thanks

[Adeel Ansari]

no you cannot type cast a parent into child, while parent is having the reference of itself.

though, dont know if there is some parent and child relation or not.

[Gul Khan]

thats the way to insert the CLOB value and it does work when run standalone. It was only creating problems while run in weblogic.

The problem is that
Clob xmlClob= rs.getClob(1) ;

is supposed to return java.sql.Clob but its returning

weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB

It worked fine when I casted it to weblogic CLOB, but i would prefer using oracle.sql.Clob. I dont know how to make weblogic return me the plain java.sql.Clob from the resultset. Any Help?