-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Barry,
On 3/28/14, 11:58 AM, Propes, Barry L wrote: > Hi folks, > > I'm using Tomcat 6.0.29 for an app I've had in place for years. I > run the Java app I have on a Windows 2003 server for my production > region, but have local builds on both my desktop and laptop, both > of which are Windows XP Pro. Yes, I do realize that the Tomcat > version is old, but we'll be retiring the app in a few months so > there's no need (at this time) to upgrade it. > > I use connection pooling, specifically Tomcat's DBCP class. > > This app has worked for years, but is suddenly encountering a > strange connection error and issue to the PROD region only of > Oracle 11. This just started in the last week. I'll include the > contents of my context XML file and the errors that it's > generating. > > Even stranger, my development build to the Oracle UAT region works > just fine! These content.xml files are virtually the same, except > one references the Oracle PROD region, and the other references the > Oracle UAT region. The Resource name attributes vary really only > slightly, one called myoracle, the other called myoracledev. > > <Context> <Resource auth="Container" description="changectrlapp" > name="jdbc/myoracle" type="javax.sql.DataSource" > driverClassName="oracle.jdbc.driver.OracleDriver" > username="username" password="password" > url="jdbc:oracle:thin:@servername.dom.net:1648:SVCNAME" > maxIdle="30" maxWait="10000" maxActive="20" testOnBorrow="true" > timeBetweenEvictionRunsMillis="-1" > minEvictableIdleTimeMillis="28800" poolPreparedStatements="true" > removeAbandoned="true" removeAbandonedTimeout="300" > logAbandoned="false"/> > > The errors I am getting are: > > javax.servlet.ServletException: > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (ORA-01033: ORACLE initialization or > shutdown in progress > > > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (ORA-01033: ORACLE initialization or > shutdown in progress > > > java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization > or shutdown in progress > > > > This may not be much to go on. > > But like I said, with attributes only slightly different, the > connection to UAT works. By the way, I am connecting successfully > to the Oracle PROD DB through other avenues: TOAD,SQL Plus, MS > Access, etc. > > > > So the DB itself is working. > > > Both my DEV/UAT and PROD regions use the same DBCP classes. Could > something have gotten corrupted for one and not the other? > > Any feedback is welcomed. Let me know, please, if I neglected to > add anything pertinent to this. Have you been able to connect with any type of Java-based client? Perhaps the driver is convinced something is wrong when everything is fine? I suspect that this is not Tomcat or DBCP-related. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJTNZ9vAAoJEBzwKT+lPKRYRkwP/0FAVLj0gNJf/BvJ2jv3lwwd rdTssFpqIQWGTrvcZnHele+ALk+7UeUo4NwI79EWZOgJVbT7TlsfJMgOaQUQ4tzQ WwMRvMP2H/zYx0U5PrcAD/eJF//gAw0oNtOYCQJ502spw0tC6rbLem8l91AaMwsF gEtTyUfgdQvpITyhWfb3fh+Dt5M2FR8AijBkY5pwTao3IGBpjT/4cTjk6ZMj6kD3 TEOVa2TTOxt4EZ18lVGTSmJVBwBs6403swGSTPtZCpj5jUcweNxNQYQF6YwUj+Vf BM7pXD11lgDh9wqMylt9/uwjq24CDSasPnnZOkxGhA1rDaUgSQXZF2aW5fX1czK2 DlzBQAdkz5PM2+Ft2yMSKGbZIXe+CCbI3x+lTOqy+7QtsPye+zMc+4CV67v+49PG wMyCCng5fAtixhvb4kQvnGOfAZ+9IPWLiRH+V5HUc4FotfKT1kaR0m/y0VdfvpIK TZJgzaAeuDvo6eM4I7AYctbXwfDL1Sdppq76WiJvof49awomEGcLPurCxGftbLPy VwYTQcfLud659Tdf2sbvwrmYorVO/VarokzFutoW3UMPRY60b1dr0Tkc6+p4ysu/ cgWjduyZ5Ml63A+UCn8N4U7XUTzRUuaFeQF/E3wA+2E8FLFALe8Xk8jeAO845WWq FZSmueBHQ/XPN8cU7J0G =G31J -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
