Bug 580020 - oracle database: No suitable driver found for jdbc:oracle:thin:
Summary: oracle database: No suitable driver found for jdbc:oracle:thin:
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: 3.0.0
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact: Corey Welton
URL:
Whiteboard:
Depends On:
Blocks: rhq_triage 580042
TreeView+ depends on / blocked
 
Reported: 2010-04-07 10:09 UTC by Rajan Timaniya
Modified: 2010-04-07 13:52 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2010-04-07 13:52:36 UTC
Embargoed:


Attachments (Terms of Use)
screenshot (117.43 KB, image/png)
2010-04-07 10:09 UTC, Rajan Timaniya
no flags Details

Description Rajan Timaniya 2010-04-07 10:09:18 UTC
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.

Comment 1 Rajan Timaniya 2010-04-07 11:45:16 UTC
I have applied workaround, that is: copy classes12.jar to
/rhq-server-3.0.0-SNAPSHOT/jbossas/server/default/lib and restart RHQ Server.

Comment 2 Charles Crouch 2010-04-07 13:52:36 UTC
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/)


Note You need to log in before you can comment on or make changes to this bug.