Welcome, Guest
Username: Password: Remember me

TOPIC: Oracle support

Oracle support 2 years 7 months ago #74822

  • arothe
  • arothe's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
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:
The administrator has disabled public write access.

Re: Oracle support 2 years 7 months ago #74823

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Oracle support 2 years 7 months ago #74829

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6358
  • Thank you received: 824
  • Karma: 245
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 ;)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.108 seconds
Donation Image