PDO_4D problem with joins

[marco]

I use PDO_4D Driver Version 0.3 for MAC OSX 10.6, I've noticed that
join in a SELECT with the function fetchAll () breaks down when more
than 100 records must be issued, for example:

SELECT table1.field1 FROM table1, table2 WHERE table1.field1 =
table2.field1 table2.field2 AND LIMIT = 5500

with LIMIT 100, it is perfect, unfortunately, not with >= 101, without
join seems to be no problem.

$ stmt = $ db-> prepare ($ sql);
$ stmt-> execute ();
$ rows = $ stmt-> fetchAll () / / break the browser


marco

[Alexandre Morgaut]

Hi marco,

could you please try the tests I described in my new post:

http://groups.google.com/group/pdo_4d/browse_thread/thread/71f6dfe89337c8b6

so we will then be able to figure where this bug comes from


Regards

Alexandre

[Marco Hertli]

Hi Alexandre

I tested now the following:

SQL in 4D -> works
SQL from a remote 4D -> works
SQL with pdo_4d -> dont't work if the results are more than 100

I have also tested PDO with the pdo_mysql driver and everything works
perfect.


Regards
Marco

[Rikard Sagnér]

Hi,

We have the same problem. When using joins the result can never be
more than 100 rows.

Best,

Rikard

[Alexandre Morgaut]

This bug definitely looks to be coming from PDO_4D itself

Please then fill it into the PECL PDO_4D bug repository:

http://pecl.php.net/bugs/report.php?package=PDO_4D

I hope I'll find a C developer with enough knowledge and availability
to fix it

If you feel or know anyone capable of, please contact me to have it
fix ASAP

If anyone already made a fix for himself, please propose it to us so
the community can test it before putting it in the package repository
(and maintain it)

Alexandre

[Alexandre Morgaut]

We may have find someone who could be able to try to do some fixes on
PDO_4D
It will have to be confirmed, and we still be happy to find other
proposals

I'm a bit sad to see that no one feel enough concerned by this bug to
fill it on the PECL bug base
( http://pecl.php.net/bugs/report.php?package=PDO_4D )
It make it looks like it is not a major problem which need to be fixed
ASAP

This bugbase is very important to show the criticality of bugs and
give a better priority to find a way to solve them

[sco...@artic.edu]

See https://bugs.php.net/bug.php?id=63896. Hope somebody can help. 

[cristi...@gmail.com]

Hello my friend,

I have problems installing the driver, can you teach me how to turn it on?

I have ubuntu with apache, php5.4 and the main "pdo.so" driver installed.

Right now, when I try to enable this "pdo_4d.so" in my php.ini I get this message in the console:

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20100525+lfs/pdo_4d.so' - /usr/lib/php5/20100525+lfs/pdo_4d.so undefined symbol: php_pdo_declare_long_constant in Unknown on line 0

Please help me,

Thanks

[gm]

My team and I have tried for a while to get the PDO_4D and 4D's SQL interface to work. 

My opinion is that: 

1) The 4D SQL engine is not very stable and lacks many basic features. It is not reliable or efficient as of v12, which is what I have been working on. If you can find a use for it for very simple and small tasks, you might be OK with it - but at that point, why not use the more robust SOAP API and native 4D queries?

2) the PDO_4D module has not seen a new release since 2009. Even if some improvements have been made in the 4D SQL engine since then, it wouldn't be up to date to leverage those improvements. 

3) You can use the 4D ODBC driver. I know that it is proprietary and only works on Windows and 32-bit OSX (which would force you to compile your whole PHP toolchain in 32 bit - even less efficient). 

The reason why I was considering the 4D SQL API was because our 4D application has a lot of abstraction and we needed to get large amounts of data. But, even considering the overhead caused by the application layer, I think the SOAP API is much more reliable and fast. 

Hope this helps. 

s

[cristian peralta]

So you recomend me to use maybe the 4d native engine throught web services? Vía json or XML.
I have tried this pdo_4d solution because I dont like 4d programming and also as You said there is 4d drivers only for OSX and windows.

Thank you in advance

--
--
****
This message was sent to members of the PDO_4D Google Group: http://groups.google.com/group/pdo_4d
To post to this group, send email to: pdo...@googlegroups.com
To unsubscribe from this group, send email to: pdo_4d+un...@googlegroups.com
 
---
You received this message because you are subscribed to the Google Groups "PDO_4D" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pdo_4d+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Rikard Sagnér]

Any progress on this issue?

Best

Rikard / Metodika

[Balinder Walia]

Guys,

Any news on the fix yet?

Balinder

--

--
****
This message was sent to members of the PDO_4D Google Group: http://groups.google.com/group/pdo_4d
To post to this group, send email to: pdo...@googlegroups.com
To unsubscribe from this group, send email to: pdo_4d+un...@googlegroups.com
 

[Roger Stegeby]

I would also want a fix to this. When could it be expected?

Kind regards / Roger