Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
linenumberstrue
CREATE USER midpoint IDENTIFIED BY apassword;
GRANT connect,resource TO midpoint;
ALTER USER midpoint quota 10G on users;

 


TODO

Configuration sample

Code Block
languagehtml/xml
linenumberstrue
<configuration>
  <midpoint>
    <repository>
      <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
      <database>oracle</database>
      <jdbcUsername>midpoint</jdbcUsername>
      <jdbcPassword>password</jdbcPassword>
      <jdbcUrl>jdbc:oracle:thin:@localhost:1521/xe</jdbcUrl>
    </repository>
  </midpoint>
</configuration>

...

If you operate Oracle DB on different server than midPoint without SSL tunnel or dedicated network, you should think of securing your JDBC connection will SSL/TLS. Oracle manual may help you with that.

Driver

Download Oracle JDBC Driver (ojdbc6.jar)Download Oracle JDBC Driver 12c (ojdbc7.jar) for midPoint 3.8 and lateras JAR for JDK 10+ (or for JDK 8, if you insist) from Maven repository or directly from Oracle pages e.g. for Oracle 19c here. Drivers are generally broadly compatible, but newer is probably better.