Rats. Nope, we haven't messed with secure communications (we don't
have any private info passage, etc). Maybe some of the guys on the
list could speak to encrypting the traffic...
On Apr 2, 2008, at 10:57 AM, John McGowan wrote:
Dale,
do you have any idea on how to take advantage of secure
communications using the Oracle provided JDBC driver.
I found examples on what properties to set if you're writing java
code to use the JDBC driver, but couldn't find specific information
on how to set a property using the JDBC configuration stanza in
jdbc.ini, or by embedding it in the JDBC URL some how.
Based on your experience i'll probably not waste too much time with
the ODBC setup, but I do still need to encrypt this traffic.
/John
On Wed, Apr 2, 2008 at 9:22 AM, Dale Graham <[EMAIL PROTECTED]>
wrote:
We had terrible experiences using ODBC on Oracle. OCI was better,
but still not swell. JDBC (despite your valid concerns) has still
been a whole lot more reliable for us... It's an Oracle thing
(connection issues)
On Apr 2, 2008, at 10:10 AM, John McGowan wrote:
Is anybody out there using this combination...
Witango 5.5 on Linux
unixODBC
(some ODBC driver for Oracle)
Oracle
Most of our stuff uses mySQL, but for one site, we're connecting to
the clients system for a few queries. That system is Oracle based.
Currently we're using JDBC drivers provided by oracle. But I want
to switch to ODBC. Witango's JDBC code is not as robust as it's
ODBC code, for example, if a db connection is severed, by the
server for some reason, witango's ODBC pool will realize that, and
drop the connection and create a new one if needed. On the JDBC
side, it will continue to try to use that connection, causing
errors. This goes on untill you do a Witango restart.
Anyway, since I do very little with Oracle, not that familiar with
the tools provided by oracle, or 3rd party tools that i might
need. I get the impression wading through oracle's site, that they
don't have an ODBC driver for Linux, (windows only) and I've found
two vendors for ODBC Oracle Linux drivers from easysoft.com and
datadirect.com
I'm trying to get the eval version of the datadirect driver working
right now, and I'm getting a vague connection error, so I figured
it wouldn't hurt to ask if anybody out there has a combination
similar to this working.
The bigger thing going on is that I want to encrypt the DB
connection, because currently we're going through a VPN, but I'd
like to drop the VPN from the equation and go with a simpler SSL or
SSH tunnel type setup. I just figured switching to ODBC at the
same time would be a good thing to do at the same time (due to the
problems i mentioned above)
/John
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--------------
Dale Graham,PhD
Technical Manager, NIDB
Custom Applications Branch, DECA, NIH
[EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--
/John
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--------------
Dale Graham, PhD
Technical Manager, NIDB
NIH Intramural DataBase
Annual Reports, NIH Bibliography, Scientific Directory
[EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf