1 Reply Latest reply on May 10, 2005 10:28 AM by Scott Stark

    Oracle connections failure under 4.0.2

    erobles Newbie

      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