Upgrade from 4.1.29 to 5.0.16, logging is too verbose?

[Ryan Cornia]

I was running tomcat 4.1.29 with a log4j jar in the
$CATALINA_HOME/common/lib folder and a log4j.properties file in
$CATALINA_HOME/common/classes folder. This worked fine, and kept the log
messages at the level I wanted them.

When I installed 5.0.16, I put the log4j jar and properties file in the
same locations listed above, but now when tomcat starts, it spits out a
ton of INFO: messages into catalina.out, so I don't think it is actually
using the log4j configuration.

Any ideas on what might have changed? Is this how I should setup log4j
to be used within tomcat?

Thanks,
Ryan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Can the JNDI Connection Pool re-connect after failure?

[Ryan Cornia]

I don't have any timeout settings set. I'm also not using the driver
from Oracle. I'm using a third party driver from inetsoftware.de. If
it's not working in 24 hours, I'll let your know.

Ryan


>>> [EMAIL PROTECTED] 01/29/03 09:43AM >>>
Will it work for 24 hours is the question... ;) If it does, maybe I
should
change to a different Oracle JDBC Driver.  Do you have any timeout
limitations set on the connecting user?  We do, and I'm wondering if
that's
causing my problems.

Thanks,

Matt


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Can the JNDI Connection Pool re-connect after failure?

[Ryan Cornia]

This solution seems to work great for me. After adding this and
re-booting the database server, it re-connected and worked great
automatically

Thanks a ton Nix.

Ryan


>>> [EMAIL PROTECTED] 01/29/03 07:11AM >>>
I've tried adding the following and I still have the same problem as
Ryan.  

validationQuery
SELECT 1 FROM DUAL




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Can the JNDI Connection Pool re-connect after failure?

[Ryan Cornia]

It must be a MySQL driver parameter, because it did not work for my
oracle driver.

Ryan

>>> [EMAIL PROTECTED] 01/28/03 11:19AM >>>
With the MySQL driver, you can configure the driver to "AutoReconnect"
a
la...




  ...

  
AutoReconnect
true
  

  ...




I'm not sure whether the "parameter" functions as a Tomcat datasource
parameter or MySQL driver parameter.  I've never done it with an
Oracle
driver.

-Original Message-
From: Ryan Cornia [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 07:43
To: >
Subject: Can the JNDI Connection Pool re-connect after failure?


I have set a JNDI connection pool up in server.xml that works, however
if the database server goes down, it doesn't re-connect when it comes
back up.

Anyone using JNDI datasources that reconnect in case of a lost link to
the DB server?

Any examples? I'm using the I-net driver for Oracle.

Thanks,
Ryan






--
To unsubscribe, e-mail:  
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Can the JNDI Connection Pool re-connect after failure?

[Ryan Cornia]

I have set a JNDI connection pool up in server.xml that works, however
if the database server goes down, it doesn't re-connect when it comes
back up. 

Anyone using JNDI datasources that reconnect in case of a lost link to
the DB server?

Any examples? I'm using the I-net driver for Oracle.

Thanks,
Ryan




--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

A little of topic - Global e-mail sending facility inside oftomcat?

[Ryan Cornia]

This is a little of topic, but I'm sure someone on this list has
implemented something similar with tomcat.
-->
I have several applications running on Tomcat 4.1.12 that I need to add
the capability to send e-mail via a SMTP server. There are two problems
-

1.) Are there any products or open source projects available that will
que the mail in case the SMTP server is down and re-send it later,
including the possibility of a tomcat re-start before the SMTP server
comes back up? Basically I want a way to insure an automated e-mail is
sent when a person registers, and is not "lost" when the e-mail server
is down.

2.) Is there a way to configure this service as a global JNDI resource
available to all applications running inside of tomcat?

Thanks,
Ryan


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Hot Deploy an Application in Tomcat 4.1.12?

[Ryan Cornia]

Is there a way to "hot" deploy a new application into tomcat 4.1.12
without restarting? The catch is I need to setup a JNDI datasource in
the server.xml. Is there a way to do that, have tomcat recognize the new
context and create the new JNDI resource without having to do a restart.

OS is linux if that makes a difference.

Thanks,
Ryan


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Error-page logging? How do I store it?

[Ryan Cornia]

I have web applications with the error-page defined in web.xml. Now, I
am looking for a clean way to store the error when the user gets to the
error page. In the tomcat 4.1.12 server.xml file it has a logger setup
for the web application, and a verbosity level to log. My question
though, is how do I write to that logger from a jsp?
 
Is there a cleaner way of keeping track of errors?
 
Thanks,
Ryan
 

Re: JDBC Connnection Pool for Oracle

[Ryan Cornia]

Check out -
 
http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg56314.html
 
Specifically, you should be using oracle.jdbc.pool.OracleConnectionCacheImpl as the 
classname. I found I have to use the same class name in web.xml to get everything to 
work properly.
 
I'm using this on several applications without problems.
 
Ryan


>>> [EMAIL PROTECTED] 09/26/02 04:55PM >>>
Hello :)
I am using Tomcat 4.0.4 with JDK1.4
I am getting the followig exception while creating the DataSource:
"javax.naming.NamingException: Cannot create resource instance"

Following is  my code, server.xml and web.xml entries.
I will really appreciate if anyone can help me out here.

Thanx in advance

Zeeshan

Java Code

ctx = (Context) new InitialContext().lookup("java:comp/env");
if (ctx!=null) {
  dataSource = (javax.sql.DataSource) ctx.lookup("jdbc/datasource");
  connection = dataSource.getConnection();
}

Server.xml


  
   usernametest
   passwordtest
   
driverClassNameoracle.jdbc.driver.OracleDriver
   
   factory
   org.apache.commons.dbcp.BasicDataSourceFactory
   
   
   driverName
   jdbc:oracle:thin:@localhost:1521:ORACLE
   
   
 urljdbc:oracle:thin:@localhost:1521:ORACLE
   
   maxActive100
   maxIdle3
   maxWait100


Web.xml
===

 Resource reference to java.sql.Connection factory defined in 
server.xml 
 jdbc/datasource
 oracle.jdbc.pool.OracleDataSource
 Container

DBTags problem with Tomcat 4.1.12?

[Ryan Cornia]

I'm trying to use DBTags from jakarta.apache.org with Tomcat 4.1.12. The tags worked 
correctly in Tomcat 4.0.4, but in 4.1.12, if the sql query does not return a result 
set, the actual sql query is printed to the JSP!!! Yikes! The query should not be 
printed to the JSP page under any circumstances.
 
Anyone else experience this, know of a fix?
 
Thanks,
Ryan

 

Pager-taglib with Tomcat 4.1.12? Anyone got it working?

[Ryan Cornia]

I'm using the pager-taglib from http://jsptags.com/tags/navigation/pager/. The code 
worked fine in SilverStream and tomcat 4.0.4. When I try tomcat 4.1.12 however, the 
page displays correctly with the page tags the first time the page is loaded after 
compile. If I hit refresh, or try and navigate to a different pager offset, the page 
comes back with all the items blank.
 
Anyone have the pager-taglib working with tomcat 4.1.12? Did you have to make some 
changes to the taglib somewhere to get it to work?
 
Thanks,
Ryan
 

Is Tomcat 4.1.10 RPM available?

[Ryan Cornia]

As the subject states, is there an RPM available for 4.1.10? If not, will one be 
coming, or should I just install the .tar.gz binary? (I like the RPM file layout 
better than just using the .tar.gz.)
 
Thanks,
Ryan
 

Versisign Global Certificate and Tomcat 4.0.3?

[Ryan Cornia]

My company requires we use Verisign Global Certificates and I'm currently running 
Tomcat 4.0.3 in standalone mode. 
 
Is it possible to install a global certificate into Tomcat stand alone? Anyone out 
there doing it?
 
Thanks,
Ryan
 

Oracle Connection Pool example server.xml

[Ryan Cornia]

I'm searching for an example server.xml that uses the Oracle connection pool mechanism 
from oracle. (As opposed to poolman, etc...)
 
Any help would be greatly appreciated, I cannot seem to get the server.xml correctly 
configured with the Oracle connection pool classes. 
 
What I've tried -
 

 

 
   usermy_username
  passwordmy_password

  factory
  oracle.jdbc.pool.OracleDataSourceFactory
 
 
  driverClassName
  oracle.jdbc.pool.OracleDataSource
 
 
  driverName
  jdbc:oracle:thin:@MYHOST:1521:ORCL
 
 

When I try and get a connection from the pool, it returns null. If I configure it to 
not use a connection pool, the code works, so I know the problem is with the oracle 
pool definition.
 
Thanks,
Ryan