Hibernate Community • View topic - ALTER SESSION SET NLS

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

ALTER SESSION SET NLS_LANGUAGE = French

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ccharaoui

Post subject: ALTER SESSION SET NLS_LANGUAGE = French

Posted: Mon Dec 12, 2005 11:46 am

Newbie

Joined: Mon Dec 12, 2005 11:32 am
Posts: 1

1.0
hibernate.xml:

I am using hibernate with Oracle 9.1. I would like to alter the session language wich could be done in oracle using the following Query: ALTER SESSION SET NLS_LANGUAGE = French. Could you help me to execute this statement every time a session is created?

Thank you

J'utilise hibernate avec Oracle 9.1. J'aimerais bien changer la langue pendant la session. Ceci se fait en utilisant ALTER SESSION SET NLS_LANGUAGE = French. Avez-vous une idée comment exeuter cette commande à chaque fois une session est crée?

Merci

Top

tenebro

Post subject: Re: ALTER SESSION SET NLS_LANGUAGE = French

Posted: Sat Oct 28, 2006 1:20 am

Newbie

Joined: Fri Oct 27, 2006 8:04 pm
Posts: 1

Try this (http://www.hibernate.org/118.html#A26), works for me:

Code:

Session session = HibernateSessionFactory.getInstance().getCurrentSession();
    try {
        tx = session.beginTransaction();
        PreparedStatement ps = session.connection().prepareStatement("alter session set nls_languague=French");
        ps.execute();
            
        classList = session.createQuery("from ... where ...").setCacheable(true).list();
        ...
    } catch (HibernateException he) {
        he.printStackTrace();
    } catch (java.sql.SQLException sqle) {
        sqle.printStackTrace();
    }

- Josue

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum