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)

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

Thu, 06 December 2012 04:18

Eclipse User

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

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

Thu, 06 December 2012 04:51

Eclipse User

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

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

Thu, 06 December 2012 05:38

Eclipse User

Hi,

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

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

Thu, 06 December 2012 06:00

Eclipse User

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?

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

Fri, 07 December 2012 05:38

Eclipse User

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

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

Fri, 07 December 2012 07:06

Eclipse User

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 07:12] by Moderator

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

Tue, 11 December 2012 05:28

Eclipse User

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.

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

Tue, 11 December 2012 08:57

Eclipse User

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 09:35] by Moderator

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

Fri, 14 December 2012 05:52

Eclipse User

Hi Erik,

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

Alex

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

Fri, 14 December 2012 06:04

Eclipse User

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

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

Mon, 17 December 2012 04:31

Eclipse User

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!

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

Mon, 17 December 2012 13:12

Eclipse User

Phew!

Glad it's working now, thanks for your patience!
Alex

Previous Topic:	Event handler does not refresh retry count
Next Topic:	Christmas holiday time

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 13 08:15:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter