NVARCHAR2 handling in EJB2.x

[Sushma Sharma]

Hi Ranchers,

I am using CMP2.x EJB and environment is oracle9 and weblogic8.1 SP6. A new requirement has come up in my project that we should support multi lingual characters in a particular field of a table. We support multiple languages including Asian languages (Chinese, Japanese, Thai and Korean).
I know that I can use -Doracle.jdbc.defaultNChar=true option when I start the application. But there are two problems with the approach:

1. It will handle everything as NVARCHAR2, so there can be performance issues.
2. It is going to be very difficult to make the server admin to make the change in the script to add this option.


I know that with PreparedStatement, I can use the following code to handle the situation

  
OraclePreparedStatement pstmt = (OraclePreparedStatement)conn.prepareStatement(query) ;
pstmt.setFormOfUse(4, Const.NVARCHAR2);

Is there anything similar that I can do to the data before passing to the CMP entity bean or is there any option in EJB that I can enable to handle the situation?
I have searched on the internet, but could not find anything.
Will I have to write a BMP to handle the requirement or is there any other solution to the problem.
please help.

Sushma