Generic Jdbc oracle driver for H2

[Jeanne Louize]

Good afternoon,

Could someone tell me where can I find a generic jdbc oracle driver for H2?

Thanks a lot!

[Evgenij Ryazanov]

Hello.

You can use Oracle's driver only when you work with Oracle Database and you can use H2's driver only when you work with H2 Database. You can't use driver for one database with another.

Both drivers are available on Maven Central and in other places:

https://search.maven.org/artifact/com.h2database/h2

https://search.maven.org/search?q=g:com.oracle.ojdbc%20a:ojdbc*

If you want to use some data from Oracle in H2 Database by using a linked table, you need to add Oracle's driver to the classpath of you application if you use the embedded H2 Database, or to the classpath of H2 Server if you use the remote H2 Database.

[Jeanne Louize]

Hello  Evgenij Ryazanov,

thank you for reply.

I´m using H2 DB with a JDBC Driver to Oracle, and It´s working now.

I do loggin into H2 with the following settings: Driver Class: oracle.jdbc.driver.OracleDriver  and JDBC URL: jdbc:h2:~/test;MODE=Oracle.

I´d like to know If it´s possible to import a dump file from Oracle as I do with a csv file? 

Regards.

[Evgenij Ryazanov]

I´m using H2 DB with a JDBC Driver to Oracle, and It´s working now.

No, you aren't. It only means that you use some entirely outdated version of H2, such as 1.4.197 or older. H2 Console in these versions doesn't throw any error about incorrect driver in that case, but silently uses the proper driver instead of it.

More recent versions really try to use the specified driver and throw the expected exception:

Driver oracle.jdbc.driver.OracleDriver is not suitable for jdbc:h2…

I´d like to know If it´s possible to import a dump file from Oracle as I do with a csv file?

No, it obliviously isn't possible. This binary dump is for Oracle only.