Well, I figured out how to get the JDBC client to require a secure
connection, it looks like this in jdbc.ini
<DataSource ID="wttwowaS">
<DSN>wttwowaS</DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@10.10.2.15:1526:wwci</URL>
<Properties>
<Property ID="oracle.net.encryption_client">
<Name>oracle.net.encryption_client</Name>
<Value>REQUIRED</Value>
</Property>
<Property ID="oracle.net.encryption_types_client">
<Name>oracle.net.encryption_types_client</Name>
<Value>(3DES168)</Value>
</Property>
</Properties>
</DataSource>
I was able to get the driver to try to connect... the Server is not setup to
handle this type of connection, so hopefully it's just a little
reconfiguring on their end.
Now, on to that other issue that's been bothering me with the JDBC
connections in general.
Do you think that perhaps there is another Property that I could pass in
like the ones above that would make the JDBC driver force a reconnect if
it's asked to try to connect with an expired / severed connection? Then I
wouldn't really have the current issue I have with JDBC where those stale
connections gum up the works until a Witango restart.
/John
On Wed, Apr 2, 2008 at 9:57 AM, John McGowan <[EMAIL PROTECTED]> 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
--
/John
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
