No suitable driver found for jdbc:oracle:thin: ...

[georgy]

I have a bit of a problem running utPLSQL-maven-plugin. If I simply add the plugin

                  <plugin>
                    <groupId>org.utplsql</groupId>
                    <artifactId>utplsql-maven-plugin</artifactId>
                    <version>3.1.0-SNAPSHOT</version>
                    <configuration>
                         ...
                    </configuration>
                   </plugin>

Then I get following error:

Caused by: java.lang.ClassNotFoundException: oracle.sql.ORAData

This makes me think I need to add oracle jdbc driver onto classpath of the plugin. So I added the dependencies:

                <plugin>
                    <groupId>org.utplsql</groupId>
                    <artifactId>utplsql-maven-plugin</artifactId>
                    <version>3.1.0-SNAPSHOT</version>

                      <dependencies>
                        <dependency>
                          <groupId>com.oracle.jdbc</groupId>
                          <artifactId>ojdbc8</artifactId>
                          <version>12.2.0.1</version>
                        </dependency>
                        <dependency>
                          <groupId>com.oracle.jdbc</groupId>
                          <artifactId>orai18n</artifactId>
                          <version>12.2.0.1</version>
                        </dependency>
                      </dependencies>

That helps a bit, but the test run still fails with

Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin: ...

I can't find where in the code (plugin or java-api) do you register the oracle driver class. I can see that in cli project there is Class.forName(), but nothing like it in plugin nor java-api.

What is the right way to register the driver then?

[jgarec]

Hi,

Exactly the same as #11.

I think it's related to the jdk.
JDBC Spec says that the driver should be registred automatically...

[georgy]

Which part of JDBC spec?

…

On Fri, 20 Jul 2018 at 15:52, jgarec ***@***.***> wrote: Hi, Exactly the same as #11 <#11>. I think it's related to the jdk. JDBC Spec says that the driver should be registred automatically... — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#23 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAGA6eWSMiyyS5McnOfJ8ySG4DMwJcgaks5uIeCUgaJpZM4VYDpo> .

[georgy]

I am guessing you mean the service provider mentioned in: https://docs.oracle.com/javase/6/docs/api/java/sql/DriverManager.html

[jgarec]

Yes.

[jgarec]

I don't remember how i solved this problem on my windows computer at work.
I was not able to reproduce on my mac.

Which OS ?
How do you get ojdbc ? from Oracle maven repository ? you install it locally ?
Which JRE ?

You're running maven through eclipse or with command line ?

[alberto-hernandez]

Hi @georgy,

All Oracle components are NOT published in the public repositories (maven central, etc) so you need to downloaded and imported to your local maven repository.

Could you check if you have it? If not, please try to download them and installed in your repository.

[georgy]

@alberto-hernandez the dependency comes from company's internal maven repo. I add the jar to the plugins classpath by adding dependency to the plugin configuration (described in my original message).

@jgarec Win 7, JDK 8, dependency comes from company's internal maven repo. I am running maven from the command line.

I will try to debug this a bit, from looking at the source code and environment is should work.

[jgebal]

@georgy Is this issue still valid or can it be closed?

[jgebal]

Closing as no response from @georgy

[hinjo89]

Hi,
I'm trying to get this maven plugin to work, but I'm encountering the same problem 'no suitable driver found for jdbc:oracle:thin:[...]'.

Since this problem was discussed in this Issue, but not resolved as far as I can see it, I'm posting here. If I should rather open a new ticket I can also do that.

Maven is executed with a jdk 8 (1.8.0_192) and the maven dependencies come from a company internal maven repository. Since the utplsql java api is listing all the oracle dependencies in its POM and maven is not complaining about not finding dependencies I figure that the dependencies should be satisfied...

Did you guys find some way to get this work in the meantime? In other tools running with the same maven repository and the same DB connection string the database access is working fine.

Thanks,
Johannes

[jgarec]

I reopen this issue as it's the third time someone talk about this...
But it's really hard to reproduce ...

Could you provide your pom file ? try to remove all unnecessary parts