Eclipse Community Forums: Jubula » No Suitable driver found for jdbc:oracle:thin

Home » Archived » Jubula » No Suitable driver found for jdbc:oracle:thin(question about need for driver for use of Jubula with Oracle)

Show: Today's Messages :: Show Polls :: Message Navigator

No Suitable driver found for jdbc:oracle:thin [message #989443]

Thu, 06 December 2012 09:18

Erik Gilbert

Messages: 55
Registered: September 2010

Member

I'm trying to use an Oracle database with Jubula and get an error message. It seems I need an Oracle JDBC driver. Where do I get this driver and how do I install it so Jubula can use Oracle?

Error message follows:

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:jubula
Error Code: 0
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.jubula.client.core.persistence.Persistor.buildSessionFactoryWithLoginData(Persistor.java:283) [org.eclipse.jubula.client.core_1.2.1.201206131127.jar:na]
at org.eclipse.jubula.client.core.persistence.Persistor.<init>(Persistor.java:157) [org.eclipse.jubula.client.core_1.2.1.201206131127.jar:na]
at org.eclipse.jubula.client.core.persistence.Persistor.instance(Persistor.java:598) [org.eclipse.jubula.client.core_1.2.1.201206131127.jar:na]
at org.eclipse.jubula.client.core.persistence.Persistor.access$4(Persistor.java:593) [org.eclipse.jubula.client.core_1.2.1.201206131127.jar:na]
at org.eclipse.jubula.client.core.persistence.Persistor$2.run(Persistor.java:191) [org.eclipse.jubula.client.core_1.2.1.201206131127.jar:na]
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) [org.eclipse.core.jobs_3.5.101.v20120113-1953.jar:na]
Caused by: org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:jubula
Error Code: 0
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:319) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
... 10 common frames omitted
Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:jubula
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.6.0_18]
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.6.0_18]
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
... 14 common frames omitted

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #989452 is a reply to message #989443]

Thu, 06 December 2012 09:51

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

You may either

have a look at the Jubula download page in the "Additional Software" section

or

use the "Help/Eclipse Marketplace..." menu and either download the driver from the Eclipse MP or the Testing Solutions MP

- Achim

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #989467 is a reply to message #989452]

Thu, 06 December 2012 10:38

Erik Gilbert

Messages: 55
Registered: September 2010

Member

Hi,

thanks for your post, but what do I look for in the Eclipse Marketplace or in the "Additional Software" section?

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #989471 is a reply to message #989467]

Thu, 06 December 2012 11:00

Erik Gilbert

Messages: 55
Registered: September 2010

Member

I searched for drivers under Eclipse Marketplace and found "Eclipse Jubula Database Drivers http://update.bredex.de/jubula ". This looked like what I needed, but I tried to install it and get the following error:

Cannot complete the install because of a conflicting dependency.
Software being installed: Jubula Database Drivers 2.0.0.201211281635 (com.bredexsw.jubula.client.core.driver.feature.feature.group 2.0.0.201211281635)
Software currently installed: Jubula 1.2.1.201206290759 (com.bredexsw.jubula.product 1.2.1.201206290759)
Only one of the following can be installed at once:
Jubula Database Drivers 1.2.1.201206290759 (com.bredexsw.jubula.client.core.driver.feature.feature.jar 1.2.1.201206290759)
Jubula Database Drivers 2.0.0.201211281635 (com.bredexsw.jubula.client.core.driver.feature.feature.jar 2.0.0.201211281635)
Cannot satisfy dependency:
From: Jubula Database Drivers 1.2.1.201206290759 (com.bredexsw.jubula.client.core.driver.feature.feature.group 1.2.1.201206290759)
To: com.bredexsw.jubula.client.core.driver.feature.feature.jar [1.2.1.201206290759]
Cannot satisfy dependency:
From: Jubula Database Drivers 2.0.0.201211281635 (com.bredexsw.jubula.client.core.driver.feature.feature.group 2.0.0.201211281635)
To: com.bredexsw.jubula.client.core.driver.feature.feature.jar [2.0.0.201211281635]
Cannot satisfy dependency:
From: Jubula Feature 1.2.1.201206290759 (com.bredexsw.jubula.feature.feature.group 1.2.1.201206290759)
To: com.bredexsw.jubula.client.core.driver.feature.feature.group [1.2.1,2.0.0)
Cannot satisfy dependency:
From: Jubula 1.2.1.201206290759 (com.bredexsw.jubula.product 1.2.1.201206290759)
To: com.bredexsw.jubula.feature.feature.group [1.2.1.201206290759]

Any suggestions?

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #989695 is a reply to message #989471]

Fri, 07 December 2012 10:38

Alexandra Schladebeck

Messages: 1613
Registered: July 2009

Senior Member

Hi,

It looks like you already had the old database drivers installed (which is weird, because then they should have been found). Anyway, if you deinstall the older ones then you should be able to install the new ones (they've been recently updated to be compatible with Kepler).

HTH,
Alex

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #989716 is a reply to message #989695]

Fri, 07 December 2012 12:06

Erik Gilbert

Messages: 55
Registered: September 2010

Member

how do I remove the older drivers?

And if I already have drivers, why can't I connect to Oracle?

[Updated on: Fri, 07 December 2012 12:12]

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #990187 is a reply to message #989716]

Tue, 11 December 2012 10:28

Oliver Goetz

Messages: 219
Registered: May 2011

Senior Member

You can remove the DB drivers by opening Help / About Eclipse --> Installation Details, selecting the DB Drivers and the clicking Uninstall...
I was not able to reproduce this behavior using Juno SR1 and Kepler 20121114-2344.

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #990228 is a reply to message #990187]

Tue, 11 December 2012 13:57

Erik Gilbert

Messages: 55
Registered: September 2010

Member

Thanks for the comment, but there are no Database Drivers listed under Installed Software. There are Jubula Database Drivers listed in the Plug-ins list. Should I remove this Plug-in?

Under Installed Software, it only lists Jubula.

[Updated on: Tue, 11 December 2012 14:35]

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #990818 is a reply to message #990228]

Fri, 14 December 2012 10:52

Alexandra Schladebeck

Messages: 1613
Registered: July 2009

Senior Member

Hi Erik,

This is all very confusing and I'd like to check it out with the team. Thanks for your patience...

Alex

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #990825 is a reply to message #990818]

Fri, 14 December 2012 11:04

Alexandra Schladebeck

Messages: 1613
Registered: July 2009

Senior Member

Hi Erik,

I've spoken to another team member and we think we have an idea -

Are you using the standalone?

If so, then the standalone product already has the drivers installed and there is no need to update / add them. In that case, it would most likely be the case that the connection to the oracle DB is mis-configured or the username / password combination is wrong. I know that the error message is then rather misleading, but it comes directly from the persistance layer.

Hope that helps,
Alex

Report message to a moderator

Re: No Suitable driver found for jdbc:oracle:thin [message #991067 is a reply to message #990825]

Mon, 17 December 2012 09:31

Erik Gilbert

Messages: 55
Registered: September 2010

Member

I am using the standalone version.

Yes, you are right. The SID of the database connection was not correct. I corrected the SID and now am able to connect successfully.

The error message saying 'No suitable driver found' was what threw me. Thank you again for all the help!

Report message to a moderator