Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
Hi, On 28/07/05, Bobby Lawrence [EMAIL PROTECTED] wrote: I don't think OJB has any connection-specific configuration, but you can try this code on your insert: ClassDescriptor classDescriptor = broker.getClassDescriptor(YourClass.class); PreparedStatement statementInsert =

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
Hi Tom! On 28/07/05, Thomas Dudziak [EMAIL PROTECTED] wrote: Bobby is right, Oracle does not seem to be able to handle NCHAR directly in the JDBC driver; you are required to use the Oracle-specific extension. This might be a useful enhancement in the Oracle platform ... Guillaume, could you

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Thomas Dudziak
On 7/29/05, Guillaume Laforge [EMAIL PROTECTED] wrote: Hi Tom! Well, yes and no. Should I create an issue or not? Since the problem can be considered a database configuration issue? Simply setting the NLS_CHARACTERSET to UTF8 makes the JDBC driver and the Oracle instance to talk together

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
On 29/07/05, Thomas Dudziak [EMAIL PROTECTED] wrote: Ok, in that case I think it is better if I simply create a FAQ entry. Right, a FAQ entry is probably more appropriate. Thanks everybody for your help. -- Guillaume Laforge http://glaforge.free.fr/weblog/?catid=2

Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Guillaume Laforge
Hello, On my current project, I'm using Oracle9i and OJB. The version of OJB is rather old: that's 1.0.0, but I may and will certainly upgrade to 1.0.3 if that's needed. I'm storing sentences in 40 different languages (English, French, Japanese, Chinese, etc...). All the columns of my tables

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Guillaume Laforge
I forgot to mention that I'm using Oracle9i's thin driver and its ojdbc14.jar. With a version 9.2.0.4 of Oracle9i. On 28/07/05, Guillaume Laforge [EMAIL PROTECTED] wrote: Hello, On my current project, I'm using Oracle9i and OJB. The version of OJB is rather old: that's 1.0.0, but I may and

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Bobby Lawrence
Guillaume - I don't think OJB has any connection-specific configuration, but you can try this code on your insert: ClassDescriptor classDescriptor = broker.getClassDescriptor(YourClass.class); PreparedStatement statementInsert =

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Thomas Dudziak
Bobby is right, Oracle does not seem to be able to handle NCHAR directly in the JDBC driver; you are required to use the Oracle-specific extension. This might be a useful enhancement in the Oracle platform ... Guillaume, could you raise a JIRA issue for this ? Tom