Re: Geeting the SID of a connection

From: Nicolas HERVE <nherve@nagora.com> > >I'm doing a connections pool, and I need the SID of each connection to >ba associated with the connection. So I could say at any time that >connection with SID xxx is up or down, or doinf this or that. I can't >get this with the system tables as the only index for the connections is >the SID ... So I guess SELECT DBINFO('sessionid') FROM systables WHERE tabid = 1 is out of the question? This manual reading lark could become addictive. You have *no* *idea* how much fun stuff is in there... >Obnoxio The Clown wrote: > > > > From: Nicolas HERVE <nherve@nagora.com> > > > > > >We're running an Informix Dynamic Server on AIX. We access it through > > >JDBC calls. We need to retrieve the SID of each connection as we open > > >it. Is there any way to get this SID without accessing the system >tables > > >? What I want is to open a connection, then send a command on this > > >connection that will retrieve it's SID . > > > > What's wrong with accessing the system catalogs? > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >-- >____________________________________________________ >Nicolas HERVE - nherve@nagora.com >NAGORA TECHNOLOGIES (anciennement SYSDEO) >98 route de la Reine 92100 Boulogne >T'l : +33(1) 41 22 03 00 - http://www.nagora.com >____________________________________________________ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com