Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b] 3.2

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Hi,

We have a program that using Hibernate 3.2 and it takes some data from and Oracle database and updates another Oracle database

The source database used to be 10g and everything worked fine.
Now the source database is going 11G and Unicode and the program now behaves in a strange way. It pulls over some data twice and can not write it because of the constraints, if I disable keys on receiving database, I get some of the records twice.

I have tried to add on the end of url UTF-8 properties:

configuration.setProperty("hibernate.connection.url", "jdbc:oracle:thin:@servername:1521/dbname?useUnicode=true;characterEncoding=UTF-8");

I have to use slash after port as it is a proxy

and I get an Io exception: NL exception was generated

Can somebody pelase tell me

1) What is the correct way of specifying Encoding for oracle jdbc driver in either the url string, or by setting hibernate properties?
2) What else I might need to do in order to upgrade my program to use the unicode change?

Many thanks

Elena