Re: [cx-oracle-users] Setting listening port for DatabaseChangeNotification feature...

[Weber, G. <Geo...@PA...>]

Sounds good!  I have been browsing through and it looks like it might be simple enough to do, but I was wondering if you wanted to set it up as part of the Subscribe object or part of the Connection object?  The Subscribe object would be the "quick-and-easy" approach, but it looks like a lot of these parameters are implemented at the connection level in the JDBC (and .NET) driver(s).  Well, you need the "enviroment handle" at any rate, and that appears to be at a lower level than the Subscription object. If I'm incorrect in this, then like I said earlier, I probably know just enough to be dangerous to myself and others here :), and I'm still browsing through documentation...

Regards,
    Geoff

________________________________________
From: Anthony Tuininga [ant...@gm...]
Sent: Monday, June 14, 2010 11:48 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Setting listening port for       DatabaseChangeNotification feature...

Hi, I am on holidays right now but when I get back I can make sure
that the relevant code is in place for the next release. Its likely
just a simple OCI call that will only take about 5-10 minutes to
do.... :-)

Anthony

On Mon, Jun 14, 2010 at 7:15 AM, Weber, Geoffrey
<Geo...@pa...> wrote:
> I've done some more digging and found the OCI call that will do the same thing: http://www.comp.dit.ie/btierney/oracle11gdoc/appdev.111/b28395/oci09adv.htm#CJGDFFFJ
>
> Depending on my time, I may try to take a quick look at the driver code to see if this is there or I can insert it somehow.  I'm really hesitant to take that last step, however, as I probably just know enough to get into trouble instead of accomplish what I set out to do there :D...
>
>
>
> ________________________________________
> From: Weber, Geoffrey [Geo...@PA...]
> Sent: Monday, June 14, 2010 8:18 AM
> To: cx-...@li...
> Subject: [cx-oracle-users] Setting listening port for   DatabaseChangeNotification feature...
>
> I've discovered with Anthony's help that a bug in Oracle causes Python3.1 to not understand DCN callbacks in 10g or 11gR1.  So now I'm using 11gR2 and things test out locally just fine.  However, my environment is strictly controlled and firewall connections are managed on a one-off basis.
>
> ...so basically now I need to be able to specify the listening port of the DCN client (Python side of the connection).  Unless this is specified as an option, Oracle chooses a port at random.  Obviously in my environment, this will not work for me.  I am unable to find such a parameter in either the Connection object or register function call (or anything else in the docs), and I didn't find anything in the driver source code using 'grep' either.  As an example, JDBC has a parameter found in this table: http://www.comp.dit.ie/btierney/oracle11gdoc/java.111/b31224/dbmgmnt.htm#CHDBDJHC called "NTF_LOCAL_TCP_PORT".
>
> Is it possible to set parameters on connections as in the JDBC driver?
>
> Thanks!
>    Geoff Weber
>    geo...@pa...
>
>
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit.  See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users