Pages: 1 2 3

#101 Re: mORMot 1 » Getting started with Oracle OCI » 2012-07-05 08:44:40

Bascy

Great, thanks for the quick respons! Perfect support.

[Edit]
Mmmmm was celebrating to early i'm afraid. I'm running into the fenv=nil problem again I made ticket for earlier. This does mean it really connects to Oracle now ;-)
Any idea on the ETA of the fEnv=nil problem?

#102 Re: mORMot 1 » Getting started with Oracle OCI » 2012-07-04 09:01:21

Bascy

.RAR archive sent!

#103 Re: mORMot 1 » Getting started with Oracle OCI » 2012-07-04 08:49:30

Bascy

Checked the sources of SynOleDB.pas and SynDBOracle.pas and both contain the latest additions as shown in http://synopse.info/fossil/info/7bf4073f38
Removed all .dcu files from the Mormot tree and recompiled my project: same result, the newly added messages can be found  in the db3 file.


Can I  mail the project as a .rar archive to you? Please provide a mail address or ftp server

#104 Re: mORMot 1 » Getting started with Oracle OCI » 2012-07-04 07:43:45

Bascy

Tried this, but the server is saving its data in the local .db3 database ...
To get rid of any confusion about the different Sample projects sharing units and stuff, i've copied unit1, unit2 and Sampledata from the 01 project to my own "project 03a"
But i can see in the .db3-file that the last messages i added with the running client, is actually stored there. There also is no SampleRecord table created on the Oracle server.

I'd be happy to supply you with the total test project, tell me where to place or mail it to.

greetings
Bas

#105 mORMot 1 » Wrong datatype CBLOB » 2012-06-22 14:00:18

Bascy
Replies: 1

When creating a table with Oracle, it tries to create fields with datatype  CBLOB .. this should be CLOB

#106 mORMot 1 » RowID is an invalid identifier for Oracle Tables » 2012-06-22 13:39:31

Bascy
Replies: 3

I've finally managed to get a very simple ORM application to connect to my Oracle database with the following code:

  Props := TSQLDBOracleConnectionProperties.Create('OPFTEST','OPF_MORMOT','xxxx',GetACP);
  Model := CreateSampleModel; // from SampleData unit
  VirtualTableExternalRegister(Model,TSQLSampleRecord,Props,'SampleRecord');
  Client := TSQLRestClientDB.Create(Model, nil, 'test.db3', TSQLRestServerDB);
  Client.Server.CreateMissingTables;

Then when the CreateMIssingTable is executed, an "Invalid Identifier" error returns from the Oracle 10g server.  have found out that this is caused by the field ROWID that mORMot adds to the table definition ... obviously ROWID is a reserved word in Oracle world.

It also struck me that this fieldname, which is used extensively throughout the whole framework, is not defined as a constant ...

#107 mORMot 1 » Getting started with Oracle OCI » 2012-06-22 11:03:44

Bascy
Replies: 20

We are evaluating a number of OPF frameworks, to determine which (if any) could be a candidate for our next redesign.
Mormot is on our longlist!

To have an idea of the performance of mORMot, we want to test it with a testable Oracle server we have. So i'm trying to adapt your Demo02 to connect to our oracle server in stead of the embedded SQLite, but i cant seem to get the hang of it.

Are there any small tret projects already setup. or easily adapted for connecting to an Oracle Server?

Greetings
Bas

Pages: 1 2 3

Board footer

Powered by FluxBB