Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 09:18 Go to next message
Erik Gilbert is currently offline Erik GilbertFriend
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
Re: No Suitable driver found for jdbc:oracle:thin [message #989452 is a reply to message #989443] Thu, 06 December 2012 09:51 Go to previous messageGo to next message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 357
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
Re: No Suitable driver found for jdbc:oracle:thin [message #989467 is a reply to message #989452] Thu, 06 December 2012 10:38 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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?
Re: No Suitable driver found for jdbc:oracle:thin [message #989471 is a reply to message #989467] Thu, 06 December 2012 11:00 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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?
Re: No Suitable driver found for jdbc:oracle:thin [message #989695 is a reply to message #989471] Fri, 07 December 2012 10:38 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1193
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
Re: No Suitable driver found for jdbc:oracle:thin [message #989716 is a reply to message #989695] Fri, 07 December 2012 12:06 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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 Go to previous messageGo to next message
Oliver Goetz is currently offline Oliver GoetzFriend
Messages: 112
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.
Re: No Suitable driver found for jdbc:oracle:thin [message #990228 is a reply to message #990187] Tue, 11 December 2012 13:57 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1193
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
Re: No Suitable driver found for jdbc:oracle:thin [message #990825 is a reply to message #990818] Fri, 14 December 2012 11:04 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1193
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

Re: No Suitable driver found for jdbc:oracle:thin [message #991067 is a reply to message #990825] Mon, 17 December 2012 09:31 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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!
Re: No Suitable driver found for jdbc:oracle:thin [message #991206 is a reply to message #991067] Mon, 17 December 2012 18:12 Go to previous message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1193
Registered: July 2009
Senior Member
Phew! Wink 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:
  


Current Time: Thu Dec 18 10:42:03 GMT 2014

Powered by FUDForum. Page generated in 0.03016 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software