Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NVARCHAR2 handling in EJB2.x

Sushma Sharma
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

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.

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic