Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Database create

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


TODO

Configuration sample

<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>

Security

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 as 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.

  • No labels