Check out the LimeSurvey source code on GitHub!

Oracle support

More
4 years 10 months ago #74822 by arothe
Hi,

In the last 2 month I have tried to develop a working Oracle port for Limesurvey. I have found a lot of problems:

1. the keyword AS between table and table-alias in FROM clauses is not allowed
2. the usage of the column-name uid is not allowed
3. there are some long table names, Oracle can only handle 31 characters
4. the usage of CLOB columns within ORDER-BY is not allowed
5. a statement like "SELECT *, colA, colB FROM table" is not allowed

All these points I have solved with minimal changes within the Limesurvey code (only within create-oracle.sql, common.php and common_function.php, no other code has been changed). I use a delegator class, which is instantiated instead of the ADODB connection. The class parses the incoming Limesurvey SQL statements and creates a new statement for the underlying ADODB layer.

At this point I thought, I was ready to upload the class, but a got a sixth problem during importing a survey:

6. the empty string '' is treated as NULL, some of such columns are part of primary keys and DEFAULT '' NOT NULL doesn't make sense with Oracle.

No idea, which I could handle that. Maybe someone else has a flash of genius...
~Andre :angry:

Please Log in to join the conversation.

More
4 years 10 months ago #74823 by Mazi
There are reasons why we don't support Oracle yet :-)

For Limesurvey 2.0 we will use the MVC framework "Yii". Maybe it's worth checking if it is easer or already possible to use Oracle with it.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 10 months ago #74829 by DenisChenu

Mazi wrote: There are reasons why we don't support Oracle yet :-)

For Limesurvey 2.0 we will use the MVC framework "Yii". Maybe it's worth checking if it is easer or already possible to use Oracle with it.

www.yiiframework.com/99/using-yii-with-oracle-through-pdo/

Some reworking to do i think ;)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form