ZeosDB

Thomas-Acia · 2015-04-29 07:29:06

Hi,

I'm working right now on an Android Project, Client Server. And I have to use a data base. I wanted to know if the Zeos library is working with FPC 3.1.1/mORMot on Linux ? Because I have some compilation errors with ZCompatiblity for example : ZCompatibility.pas Error: Some fields coming before " " were not initialized

PS: I also checked the Zeos version, I have the trunk version.

Edit 2 : Compilation with Delphi : OK but codetyphon not working !

Edit 3 : My problem is coming when I include SynDBZeos. It loads different units and the compilation returns errors. My objective is to use only PostgreSQL
Normally, if you create a sample application and include SynDBZeos, it's not working... (with FPC of course)

Thank's

Last edited by Thomas-Acia (2015-04-29 08:56:23)

ab · 2015-04-29 09:26:49

We did not fully tested SynDBZeos with FPC yet.

Did you ask for support in the Zeos forums?

Thomas-Acia · 2015-04-29 09:31:43

ab wrote:

We did not fully tested SynDBZeos with FPC yet.
Did you ask for support in the Zeos forums?

I'll ask them and I'll share the answer here.

ab · 2015-04-29 09:32:44

Zeos forums are usually very reactive.

miab3 · 2015-04-29 11:21:48

@Thomas-Acia,

Use the version:
Zeos7.2-beta branches_ testing_Revision 3619(3627):
http://svn.code.sf.net/p/zeoslib/code-0 … sting-7.2/

I have not encountered significant problems in all my tests:
http://zeoslib.sourceforge.net/viewtopi … 664#p38406

Michal

Thomas-Acia · 2015-04-29 11:25:00

miab3 wrote:

@Thomas-Acia,
Use the version:
Zeos7.2-beta branches_ testing_Revision 3619(3627):
http://svn.code.sf.net/p/zeoslib/code-0 … sting-7.2/
I have not encountered significant problems in all my tests:
http://zeoslib.sourceforge.net/viewtopi … 664#p38406
Michal

Ok. Answer in 2h max !

Thomas-Acia · 2015-04-29 15:26:09

So, I finished all my tests.

To conclude :

Now it's working ! BUT even if I use your revision, I have the problem. So I decided to use the ZEOS library given with CodeTyphon and now it's working. So I don't know what the problem is, but now it's working.

If I can give a council to all users who have the same problem: Use the Zeos lib given with codetyphon (C:\codetyphon\typhon\components\pl_ZeosDBOx\source\*).

miab3 · 2015-04-29 16:22:15

Update ZEOS in CodeTyphon involves replacing the contents from the "C:\codetyphon\typhon\components\pl_ZeosDBO\source\*"
on contents of the current Revision from directory "src\*" and rebuild of the entire CodeTyphon.

Michal

Last edited by miab3 (2015-04-29 16:23:07)

Thomas-Acia · 2015-04-30 13:52:28

Syntaxe mode : Delphi was not activated...

miab3 · 2015-05-02 10:28:48

From what I see CodeTyphon current version(5.30), release date 29-Apr-2015:
http://www.pilotlogic.com/sitejoom/inde … codetyphon
includes the latest version of ZEOS 7.2 beta r3619(r3627).

Michal

Last edited by miab3 (2015-05-02 10:29:54)

Thomas-Acia · 2015-05-04 10:01:00

miab3 wrote:

From what I see CodeTyphon current version(5.30), release date 29-Apr-2015:
http://www.pilotlogic.com/sitejoom/inde … codetyphon
includes the latest version of ZEOS 7.2 beta r3619(r3627).
Michal

Yes. I rebuilt all with CodeTyphon this morning. I just tested the connection with a postgres server, it's working well with linux debian 7. (Windows too of course !)

Thomas-Acia · 2015-05-21 10:04:52

Hi,

I'm working on a new part of my projet. I just added RTTI to my server and now I'm trying to connect my server to PostgeSQL.

I used this

PropsPostgreSQL := TSQLDBZEOSConnectionProperties.Create(
   TSQLDBZEOSConnectionProperties.URI(dPostgreSQL,'localhost:5432'),
   'dbname','username','password');

And now my question is, how can I assign these properties ? Can I use a TZConnection or anything else ?

ab · 2015-05-21 10:48:28

No, using PropsPostgreSQL to define external tables is enough.
No need to maintain the connection by your own.
You may benefit of running the ORM process in a dedicated thread, to let resources be low.

See e.g. https://github.com/synopse/mORMot/blob/ … server.dpr

Thomas-Acia · 2015-05-21 15:04:14

My connection is working well. But there's a problem in the framework.
When a schema contains a . in the name, mORMot doesn't generate the " " around the name.

ab · 2015-05-21 15:06:15

A schema with . in it?

I just hate RDBMS specificities.

Thomas-Acia · 2015-05-21 15:18:36

ab wrote:

A schema with . in it?
I just hate RDBMS specificities.

Yes with . in it !

Thomas-Acia · 2015-05-21 15:25:52

And with uppercase too

Thomas-Acia · 2015-05-28 07:20:19

Hi,

How can I do a ILIKE pgsql with the ORM ? "Like" is working but not iLike

Thank's !

ab · 2015-05-28 08:03:12

ILIKE is not supported, since it is a PostgreSQL specific extension, not handled by Sqlite3 for instance.

Since ILIKE is not recognized by the framework, the statement is passed to the virtual SQLite3 table engine, which does not support ILIKE either...

IMHO the only possibility is to run the SQL query directly on PostgreSQL, using the SynDB connection properties.
ILIKE use falls into the category of optimization for a single SQL engine, so is not handled by the ORM.

Thomas-Acia · 2015-05-29 14:45:38

ab wrote:

ILIKE is not supported, since it is a PostgreSQL specific extension, not handled by Sqlite3 for instance.
Since ILIKE is not recognized by the framework, the statement is passed to the virtual SQLite3 table engine, which does not support ILIKE either...
IMHO the only possibility is to run the SQL query directly on PostgreSQL, using the SynDB connection properties.
ILIKE use falls into the category of optimization for a single SQL engine, so is not handled by the ORM.

Yes but the objective is to use the ORM anyway ..
So I use the Uppercase method.

And to return to the RDBMS "specificities", I think the caracters " . " or "UPPERCASE" are not just a specificitiy. It's a standard...

Thank you !

Thomas-Acia · 2015-05-29 14:48:21

By the way, my project is ended. I have a client and a server mORMot with a SQL query (ZEOS + PGSQL).

It's working on Linux AND Windows but not with an Android device yet. I'm working on it. If I have good news, I'll come back !

ab · 2015-05-29 20:07:05

Nice!

8)

mORMot Open Source

#1 2015-04-29 07:29:06

ZeosDB

#2 2015-04-29 09:26:49

Re: ZeosDB

#3 2015-04-29 09:31:43

Re: ZeosDB

#4 2015-04-29 09:32:44

Re: ZeosDB

#5 2015-04-29 11:21:48

Re: ZeosDB

#6 2015-04-29 11:25:00

Re: ZeosDB

#7 2015-04-29 15:26:09

Re: ZeosDB

#8 2015-04-29 16:22:15

Re: ZeosDB

#9 2015-04-30 13:52:28

Re: ZeosDB

#10 2015-05-02 10:28:48

Re: ZeosDB

#11 2015-05-04 10:01:00

Re: ZeosDB

#12 2015-05-21 10:04:52

Re: ZeosDB

#13 2015-05-21 10:48:28

Re: ZeosDB

#14 2015-05-21 15:04:14

Re: ZeosDB

#15 2015-05-21 15:06:15

Re: ZeosDB

#16 2015-05-21 15:18:36

Re: ZeosDB

#17 2015-05-21 15:25:52

Re: ZeosDB

#18 2015-05-28 07:20:19

Re: ZeosDB

#19 2015-05-28 08:03:12

Re: ZeosDB

#20 2015-05-29 14:45:38

Re: ZeosDB

#21 2015-05-29 14:48:21

Re: ZeosDB

#22 2015-05-29 20:07:05

Re: ZeosDB

Board footer