Bug 580020
| Summary: | oracle database: No suitable driver found for jdbc:oracle:thin: | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Rajan Timaniya <rtimaniy> | ||||
| Component: | Database | Assignee: | RHQ Project Maintainer <rhq-maint> | ||||
| Status: | CLOSED NOTABUG | QA Contact: | Corey Welton <cwelton> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | low | ||||||
| Version: | 3.0.0 | ||||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2010-04-07 13:52:36 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | |||||||
| Bug Blocks: | 565628, 580042 | ||||||
| Attachments: |
|
||||||
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/) |
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.