Hi David.

Thank you very much for your help.
But I still have a little problem - do you mean method
getUnderlyingConnection on tyrex.resource.jdbc.xa.TyrexConnection instance
? But it has a private access.


More details :

On JBoss 2.4 I used something like this :

//Restoring connection from pool
dataSource = (DataSource)ServiceLocator.getServiceLocator
().getJndiService(jndiDataSourceName);
connection = dataSource.getConnection();

//Setting  NLS ...
setConnectionParams(result);

where :

dataSource is instance of javax.sql.DataSource
connection is instance of java.sql.Connection

and setConnectionParams performs setting NLS_LANGUAGE, NLS_TERRITORY and
NLS_SORT, NLS_DATE_FORMAT on the restored connection.


In previous JBoss version it worked OK, but now it doesn't.


Thank you.

Marek





                                                                                       
                                             
                    David Jencks                                                       
                                             
                    <davidjencks@directvinternet        To:     
[EMAIL PROTECTED]                                    
                    .com>                               cc:     (bcc: Marek 
Sedliak/BYS/SOFTIP)                                     
                    Sent by:                            Subject:     Re: [JBoss-user] 
Initializing JDBC Connection II               
                    [EMAIL PROTECTED]                                       
                                             
                    eforge.net                                                         
                                             
                                                                                       
                                             
                                                                                       
                                             
                    05.10.2002 13:45                                                   
                                             
                    Please respond to jboss-user                                       
                                             
                                                                                       
                                             
                                                                                       
                                             




If you are doing this on a connection by connection basis, you would need
to get the underlying connection

OracleConnection oc = (OracleConnection)c.getUnderlyingConnection();

If this isn't what you want provide more details.

david jencks

On 2002.10.05 06:53:41 -0400 [EMAIL PROTECTED] wrote:
> Hi all,
>
> please, I would like to ask you about initializing JDBC connection  -  I
> mean, I need to set up a few connection params that are application
> specific, e.g. for ORACLE  - NLS_LANGUAGE, NLS_TERRITORY and NLS_SORT,
> NLS_DATE_FORMAT. I have found in the archive it's a problem now. In JBoss
> 2.4 it worked after getting the connection from the pool. In JBoss 3.0 it
> doesn't.
> Please, is there any correct way how to set up these params ?
>
> Thanks a lot.
>
> Marek
>
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user






-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to