Oracle connections failure under 4.0.2
I tried to move from 4.0.1sp1 to 4.0.2, and my oracle-ds.xml, which worked just fine under 4.0.1sp1, is giving me troubles. I get lots of SQLExceptions like the one attached below.
My web apps work normally during a while, they do get a database connection, , then I get some Exceptions, the errors appear on the log files, and then all works again. It goes that way all day.
I put the Oracle JDBC driver under server/default/lib and the problem persists (It was within my app. WAR file before that). I downgraded to 4.0.1sp1 again and it works without any problem.
Any ideas?
2005-05-09 00:00:03,290 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jdbc:datasource=jdbc/myo
racle,service=metadata dependent components: []
2005-05-09 00:00:03,307 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: oracle-ds.xml
2005-05-09 00:00:03,307 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/usr/local/jboss-4.0.2/server/default/deplo
y/oracle-ds.xml
2005-05-09 00:01:53,784 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interva
l 600000 old interval: 9223372036854775807
2005-05-09 00:01:53,784 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=myoraclepass, pas
sword=--hidden--}
2005-05-09 00:01:53,785 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Checking driver for URL: jdbc:oracle:thin:@oracle:1521:orasid
2005-05-09 00:01:53,785 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for url: jdbc:oracle:thin:@jdbc:oracle:thin:@oracle:1521:orasid
2005-05-09 00:01:53,786 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for ur
l: jdbc:oracle:thin:@oracle:1521:orasid
2005-05-09 00:01:53,787 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for ur
l: jdbc:oracle:thin:@oracle:1521:orasid
2005-05-09 00:01:53,787 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a
new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceExcepti
on: Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:thin:@oracle:1521:orasid)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory
.java:161)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectio
nPool.java:508)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:53
4)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:395)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:297)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:447)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManag
er2.java:874)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
at com.metropolis.dbAccess.sqlinterface.conecta(sqlinterface.java:117)
at com.metropolis.dbAccess.sqlinterface.(sqlinterface.java:23)
at com.metropolis.dbAccess.avisoDB.(avisoDB.java:21)
at org.apache.jsp.helpdesk.muestra_002davisos_jsp._jspService(org.apache.jsp.helpdesk.muestra_002davisos_jsp:54)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.Ora
cleDriver, url: jdbc:oracle:thin:@oracle:1521:orasid
