Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsNo Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989443/#msg_989443
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]]>Erik Gilbert2012-12-06T09:18:42-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989452/#msg_989452
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]]>Achim Loerke2012-12-06T09:51:25-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989467/#msg_989467
thanks for your post, but what do I look for in the Eclipse Marketplace or in the "Additional Software" section?]]>Erik Gilbert2012-12-06T10:38:53-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989471/#msg_989471
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?]]>Erik Gilbert2012-12-06T11:00:18-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989695/#msg_989695
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]]>Alexandra Schladebeck2012-12-07T10:38:26-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/989716/#msg_989716
And if I already have drivers, why can't I connect to Oracle?
]]>Erik Gilbert2012-12-07T12:06:23-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/990187/#msg_990187
I was not able to reproduce this behavior using Juno SR1 and Kepler 20121114-2344.]]>Oliver Goetz2012-12-11T10:28:04-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/990228/#msg_990228
Under Installed Software, it only lists Jubula.]]>Erik Gilbert2012-12-11T13:57:47-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/990818/#msg_990818
This is all very confusing and I'd like to check it out with the team. Thanks for your patience...
Alex]]>Alexandra Schladebeck2012-12-14T10:52:18-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/990825/#msg_990825
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
]]>Alexandra Schladebeck2012-12-14T11:04:58-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/991067/#msg_991067
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! ]]>Erik Gilbert2012-12-17T09:31:59-00:00Re: No Suitable driver found for jdbc:oracle:thin
https://www.eclipse.org/forums/index.php/mv/msg/441179/991206/#msg_991206
Glad it's working now, thanks for your patience!
Alex]]>Alexandra Schladebeck2012-12-17T18:12:17-00:00