mORMot Open Source

chronisvel

Member

Registered: 2016-01-01

Posts: 8

Connection to oracle

Based on the MVC demo, connection to SQLITE3 is achieved by this (simplified by me) code:
  aModel := CreateModel;
  aServer := TSQLRestServerDB.create(aModel,ChangeFileExt(ExeVersion.ProgramFileName,'.db'));
  aServer.DB.Synchronous := smNormal;
  aServer.DB.LockingMode := lmExclusive;
  aServer.CreateMissingTables;
  aApplication := TMyMVCApplication.Create;
  aApplication.Start(aServer);
...

How can I connect to an ORACLE server instead?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,231

Website

Re: Connection to oracle

Define the tables as external.
See http://synopse.info/files/html/Synopse% … l#TITL_146

See the other MVC examples
which connects to Firebird https://github.com/synopse/mORMot/blob/ … rebird.dpr
or to PostgreSQL https://github.com/synopse/mORMot/blob/ … greSQL.dpr

chronisvel

Member

Registered: 2016-01-01

Posts: 8

Re: Connection to oracle

Define the tables as external.
See http://synopse.info/files/html/Synopse% … l#TITL_146

See the other MVC examples
which connects to Firebird https://github.com/synopse/mORMot/blob/ … rebird.dpr
or to PostgreSQL https://github.com/synopse/mORMot/blob/ … greSQL.dpr

Thank you!