Am facing typical problem in casting prepared statement to oracleprepared statement. Inorder to provide multilingual support in one of our project, we followed the database type conversion for unicode support (changing varchar2 to nvarchar2). I guess setFormOfUse() in oracle prepared statement have to be used for any inserts in column of type NVARCHAR2. My application is running in weblogic6.1 and uses oracle thin driver. In code, when prepared statement is casted to oraclepreparedstatement classcastexception is thrown. Looks like weblogic8.1 supports this conversion. Any idea how to eliinate this issue in weblogic6.1.
The weblogic version difference is a misnomer. You are getting a class cast exception because it isn't an Oracle prepared statement.
Why would that be?
1) Perhaps the use of different driver?
2) Check what other environment aka classpath differences there are between the one that works and the one that doesn't.
Joined: Oct 08, 2005
Looks like no issue in classpath. Probably choice of driver could be different for oracle extension classes. I put mmy question this way, how do i use oracle extension classes in weblogic6.1 to insert unicode characters. Your suggestion is very much valuable and appreciated.