In the process of moving a newer version of the Oracle driver
(from 9.2.05 to 9.2.06) through out environments, we had the
following error:
Apache Tomcat/4.1.30
SQL Error.
count = 0, total = 498
count = 0, total = 498
The server is set-up to use multiple services with a root
context configured in each. Also, there is a manager app
configured for each service that uses a JDBC realm for
authentication. This driver worked on our local machines, in
DEV and the QA environments. It also worked on the "old" tomcat
4.1.12 that was in the PREP environment, but did not work on the
"new" tomcat 4.1.30 that was in the prep environment.
As background, when we moved the 9.2.0.5 driver out, we had
problem in the DEV environment with the driver change preventing
Tomcat from starting up. The 9.2.05 driver worked in the QA
environment. A few days later, I had time to trouble shoot the
problem in the DEV, but it worked when I restarted the server.
We are really worried, that this problem will happen when we
move to the production environment where we have multiple
servers. Any ideas? Is there a way to get more error messages
or anything else that may be useful.?
=====
Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
<Server port="8005" shutdown="SHUTDOWN" debug="0">
<!-- A "Service" is a collection of one or more "Connectors" that share
a single "Container" (and therefore the web applications visible
within that Container). Normally, that Container is an "Engine",
but this is not required.
Note: A "Service" is not itself a "Container", so you may not
define subcomponents such as "Valves" or "Loggers" at this level.
-->
<!-- Define the Tomcat Stand-Alone Service -->
<Service name="Tomcat-postservlet">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="9000" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="10000"
acceptCount="10" debug="0" connectionTimeout="60000">
</Connector>
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="10000" minProcessors="5" maxProcessors="75"
enableLookups="true"
acceptCount="100" debug="0" scheme="https" secure="true"
useURIValidationHack="false" disableUploadTimeout="true">
<Factory className="org.apache.coyote.tomcat4.CoyoteServerSocketFactory"
clientAuth="false" protocol="TLS"/>
</Connector>
<Engine name="Standalone" defaultHost="postservlet" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="postservlet" debug="0" appBase="webapps/postservlet"
unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="postservlet_access_log." suffix=".txt"
pattern="common"/>
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="postservlet_log." suffix=".txt"
timestamp="true"/>
<Context docBase="." priveleged="false" path="">
</Context>
<Context docBase="../../server/webapps/manager" path="/manager"
privileged="true">
<Realm className="org.apache.catalina.realm.JDBCRealm"
digest="MD5"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="not for your eyes"
connectionName="not for your eyes" connectionPassword="not for your eyes"
userTable="svrlnk.tomcat_user_realm_vw"
userNameCol="ss_user_id" userCredCol="ss_password"
userRoleTable="svrlnk.tomcat_user_realm_vw"
roleNameCol="tomcat_role" >
</Realm>
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow="not for your eyes"/>
</Context>
</Host>
</Engine>
</Service>
<Service name="Tomcat-justicexchange">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="9001" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="10001"
acceptCount="10" debug="0" connectionTimeout="60000"/>
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="10001" minProcessors="5" maxProcessors="75"
enableLookups="true"
acceptCount="100" debug="0" scheme="https" secure="true"
useURIValidationHack="false" disableUploadTimeout="true">
<Factory className="org.apache.coyote.tomcat4.CoyoteServerSocketFactory"
clientAuth="false" protocol="TLS"/>
</Connector>
<Engine name="JusticeXchange" defaultHost="justicexchange" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<!-- Because this Realm is here, an instance will be shared globally -->
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="justicexchange" debug="0" appBase="webapps/justicexchange"
unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="justicexchange_access_log." suffix=".txt"
pattern="common"/>
<!-- Logger shared by all Contexts related to this virtual host. By
default (when using FileLogger), log files are created in the "logs"
directory relative to $CATALINA_HOME. If you wish, you can specify
a different directory with the "directory" attribute. Specify either a
relative (to $CATALINA_HOME) or absolute path to the desired
directory.-->
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="justicexchange_log." suffix=".txt"
timestamp="true"/>
<Context docBase="." priveleged="false" path="">
</Context>
<Context docBase="../../server/webapps/manager" path="/manager"
privileged="true">
<Realm className="org.apache.catalina.realm.JDBCRealm"
digest="MD5"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="not for your eyes"
connectionName="not for your eyes" connectionPassword="not for your eyes"
userTable="svrlnk.tomcat_user_realm_vw"
userNameCol="ss_user_id" userCredCol="ss_password"
userRoleTable="svrlnk.tomcat_user_realm_vw"
roleNameCol="tomcat_role" >
</Realm>
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow="not for your eyes"/>
</Context>
</Host>
</Engine>
</Service>
<Service name="Tomcat-call2court">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="9002" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="10002"
acceptCount="10" debug="0" connectionTimeout="60000"/>
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="10002" minProcessors="5" maxProcessors="75"
enableLookups="true"
acceptCount="100" debug="0" scheme="https" secure="true"
useURIValidationHack="false" disableUploadTimeout="true">
<Factory className="org.apache.coyote.tomcat4.CoyoteServerSocketFactory"
clientAuth="false" protocol="TLS"/>
</Connector>
<Engine name="Call2Court" defaultHost="call2court" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<!-- Because this Realm is here, an instance will be shared globally -->
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="call2court" debug="0" appBase="webapps/call2court"
unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="call2court_access_log." suffix=".txt"
pattern="common"/>
<!-- Logger shared by all Contexts related to this virtual host. By
default (when using FileLogger), log files are created in the "logs"
directory relative to $CATALINA_HOME. If you wish, you can specify
a different directory with the "directory" attribute. Specify either a
relative (to $CATALINA_HOME) or absolute path to the desired
directory.-->
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="call2court_log." suffix=".txt"
timestamp="true"/>
<Context docBase="." priveleged="false" path="">
</Context>
<Context docBase="../../server/webapps/manager" path="/manager"
privileged="true">
<Realm className="org.apache.catalina.realm.JDBCRealm"
digest="MD5"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="not for your eyes"
connectionName="not for your eyes" connectionPassword="not for your eyes"
userTable="svrlnk.tomcat_user_realm_vw"
userNameCol="ss_user_id" userCredCol="ss_password"
userRoleTable="svrlnk.tomcat_user_realm_vw"
roleNameCol="tomcat_role" >
</Realm>
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow="not for your eyes"/>
</Context>
</Host>
</Engine>
</Service>
<Service name="Tomcat-jcpdc2c">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="9003" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="10003"
acceptCount="10" debug="0" connectionTimeout="60000" />
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="10003" minProcessors="5" maxProcessors="75"
enableLookups="true"
acceptCount="100" debug="0" scheme="https" secure="true"
useURIValidationHack="false" disableUploadTimeout="true">
<Factory className="org.apache.coyote.tomcat4.CoyoteServerSocketFactory"
clientAuth="false" protocol="TLS"/>
</Connector>
<Engine name="jcpdc2c" defaultHost="jcpdc2c" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<!-- Because this Realm is here, an instance will be shared globally -->
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="jcpdc2c" debug="0" appBase="webapps/jcpdc2c"
unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="jcpdc2c_access_log." suffix=".txt"
pattern="common"/>
<!-- Logger shared by all Contexts related to this virtual host. By
default (when using FileLogger), log files are created in the "logs"
directory relative to $CATALINA_HOME. If you wish, you can specify
a different directory with the "directory" attribute. Specify either a
relative (to $CATALINA_HOME) or absolute path to the desired
directory.-->
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="jcpdc2c_log." suffix=".txt"
timestamp="true"/>
<Context docBase="." priveleged="false" path="">
</Context>
<Context docBase="../../server/webapps/manager" path="/manager"
privileged="true">
<Realm className="org.apache.catalina.realm.JDBCRealm"
digest="MD5"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jnot for your eyes"
connectionName="not for your eyes" connectionPassword="not for your eyes"
userTable="svrlnk.tomcat_user_realm_vw"
userNameCol="ss_user_id" userCredCol="ss_password"
userRoleTable="svrlnk.tomcat_user_realm_vw"
roleNameCol="tomcat_role" >
</Realm>
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow="not for your eyes"/>
</Context>
</Host>
</Engine>
</Service>
<!--
Lots more of these deleted to reduce attachment size
-->
</Server>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
