that sure does sound strange, you'd need a network sniffer to see what
it tries to do
maybe oracle technet will have more info.
Filip
Tim Lucia wrote:
I did change the metric on Windows when I first discovered this. It made no
difference. Why would I *need* to add static routes -- when my machine's
primary IP is 172.25.x.y and the database server is likewise 172.25.x.z? I
can't explain why *ONLY* the Oracle driver insists on trying the wrong path.
Pinging the db server by name does not cause a 5 second delay, nor does
telnet, ssh, wget, ...
Confused,
Tim
-----Original Message-----
From: Filip Hanik - Dev Lists [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 3:49 PM
To: Tomcat Users List
Subject: Re: Tomcat Clusters, private network for replication, and Oracle 8i
JDBC driver
interesting, you might wanna play around with the route table and add some
static routes for how you want your traffic to flow.
Filip
Tim Lucia wrote:
I have a 3-node cluster, running on Linux. All 3 boxes are identical.
Eth0 - A class B network address - The 'public' interface for web
traffic (public in that it goes back out through httpd to the
internet)
Eth1 - A class C network address - The 'private' interface for
replication.
I.e.
<Receiver
className="org.apache.catalina.cluster.tcp.ReplicationListener"
tcpListenAddress="192.168.x.y"
tcpListenPort="4009"
tcpSelectorTimeout="100"
tcpThreadCount="6"/>
Tomcat clustering all works fine. The problem comes when I request a
connection from the connection pool to an Oracle 8i data source, like
the
following:
<Resource
name="jdbc/dbname"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@hostname.company.com:1521:dbname"
username="user"
password="password"
validationQuery="SELECT COUNT(*) FROM DUAL"
initialSize="10"
defaultCatalog="dbname"
maxIdle="20"
maxWait="5000"
maxActive="50"/>
If I have the private network enabled for replication, then the Oracle
thin driver insists on trying to connect through this interface first.
This happens on a class A network (10.0.x.y) as well as a class C
network (192.168.10.y). It also happens if the OS happens to be W2K.
It will take
5 seconds and time out, and the connect through the class B address.
With 10 data sources (on Oracle) I get a connection pool startup time
of 50+ seconds (minimum).
If I turn off the class C (or class A) private network and replicate
on my class B network, this problem does not happen.
Can anybody explain to me why this is the case? Has anyone else seen
this?
Has anyone else got this working as expected?
Should I even bother trying to keep the replication traffic on a
private network? The boxes have 4 gig connections and so it seems
like I should be able to make use of the other 3.
Thanks,
Tim
P.s. Yes I know Oracle 8i pre-dates modern man and is no longer supported.
I'm on a long-range plan to move to MySQL.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
