Hello Tomcat users and developers.
I am using Tomcat 6.0.26 on a few machines - Win XP Pro on two of them, and
Windows Server 2003 on the production machine.
Also using jdk1.6.0_18 and was on Ora10g, now 111g.
Today, Tomcat stopped logging on two of the machines, and my servlet that
submits to the Oracle DB now fails.
Our IT group upgrade Oracle from 10g to 11g this weekend.
What is odd to me is that I use a Context object for connection on this
servlet, as well as a few other JSPs.
The JSPs connect with no issue. The servlet fails. But either way, would this
upgrade inhibit Tomcat from logging? That seems strange to me.
My Context object is as follows.
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up our data source
DataSource ds = (DataSource) envCtx.lookup("jdbc/myoracle");
// Allocate and use a connection from the pool
connection = ds.getConnection();
I'm inporting the following:
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
FYI, this has worked for years prior to this upgrade.
But if anyone sees anyhing amiss out of this, please enlighten me.
