Created attachment 404887 [details] screenshot Description of problem: oracle database: No suitable driver found for jdbc:oracle:thin: Version-Release number of selected component (if applicable): master (build #154) GIT Revision: dbb5bc7867d54c54b1037f43e9f69eac1b34c2b9 How reproducible: Always Steps to Reproduce: Install RHQ server using Oracle 10g and gets the No suitable driver found for jdbc:oracle:thin: error. Actual results: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin: Expected results: RHQ Server should install on Oracle 10g without any 'No suitable driver found for jdbc:oracle:thin:' error. Additional info: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@suniltest.usersys.redhat.com:1521:orcl 2010-04-07 14:53:41,503 WARN [org.rhq.core.db.DatabaseTypeFactory] {DatabaseTypeFactory.cannot-load-jdbc-driver}Cannot load the JDBC driver [oracle.jdbc.driver.OracleDriver] for JDBC URL [jdbc:oracle:thin:@suniltest.usersys.redhat.com:1521:orcl] - connecting to your database will probably fail. 2010-04-07 14:53:41,504 WARN [org.rhq.enterprise.installer.ConfigurationBean] Installer failed to test connection java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@suniltest.usersys.redhat.com:1521:orcl at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.rhq.core.db.DbUtil.getConnection(DbUtil.java:60) at org.rhq.enterprise.installer.ServerInformation.getDatabaseConnection(ServerInformation.java:664) at org.rhq.enterprise.installer.ServerInformation.ensureDatabaseIsSupported(ServerInformation.java:143) at org.rhq.enterprise.installer.ConfigurationBean.testConnection(ConfigurationBean.java:357) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.el.parser.AstValue.invoke(AstValue.java:131) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.rhq.helpers.rtfilter.filter.RtFilter.doFilter(RtFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) 2010-04-07 14:53:41,732 WARN [org.rhq.core.db.DatabaseTypeFactory] {DatabaseTypeFactory.cannot-load-jdbc-driver}Cannot load the JDBC driver [oracle.jdbc.driver.OracleDriver] for JDBC URL [jdbc:oracle:thin:@suniltest.usersys.redhat.com:1521:orcl] - connecting to your database will probably fail.
I have applied workaround, that is: copy classes12.jar to /rhq-server-3.0.0-SNAPSHOT/jbossas/server/default/lib and restart RHQ Server.
This is working as designed, we don't ship the Oracle drivers as part of RHQ due to license restrictions, you need to grab a jon build to test with (http://hudson-qe.rhq.rdu.redhat.com:8080/job/jon/)