Oracle Connectivity

[Mike Neal]

Please excuse the lack of knowledge as these may be "newbie" type questions.
I know nothing about LiveWire, I'm just the DBA behind the scenes. I'm
trying to see if the developer is efficiently managing connectivity from his
LiveWire server to my Oracle databases.

1. Can LiveWire utilize native Oracle connectivity (via SQL*Net) or is an
ODBC required?

2. Can LiveWire "pool up" connections or is a new connection to Oracle
required with each user connection?

Thanks in advance.

[John Crowley]

check the server side java script documentation on
developer.netscape.com and developer.iplanet.com ...

but I'm fairly certain that SSJS uses native Oracle connectivity
and almost definite provides pooling.

[Jim Martin]

Mike,

SSJS uses SQL*Net. I can guarantee this because I have been in the same boat
as you, having to figure out how this all works in areas I have no
experience in. I found out that in order to connect natively to Oracle, you
have to have an Oracle home variable, and all the other joyful Oracle bits.
SQL*Net is also a major area of concern for using the international
character set. So yeah, there is native Oracle support. I would assume you
could go through ODBC, but native makes more sense to me.

Connection Pools are totally do-able, and usually are instantiated in a
startup file. The thing to note is that they will cause havoc with your
system if you forget about them and do not shut them down and re-open them
when an Oracle Backup is done. Just a word of warning there.

Mike Neal <mn...@ecorporation.com> wrote in message
news:8njjgt$7b...@secnews.netscape.com...