Ajax Event Calendar Support Product Page
Under investigation
Does not work with Oracle
Reported 17 Jan 2012 17:12:21
1
has this problem
17 Jan 2012 17:12:21 Francesco Zenere posted:
Since it's possible to use it, I've tried to establish a connection to a calendar made with Oracle 9.2i, but it doesn't work at all.I tried the SQL code generated by the Ajax Event Calendar, and it seems that the renaming a field as "start" it is not accepted by the dB.
Replies
Replied 23 Jan 2012 14:43:10
23 Jan 2012 14:43:10 George Petrov replied:
Hi Francesco,
How is your database structure for the events table defined in Oracle?
-George
How is your database structure for the events table defined in Oracle?
-George
Replied 23 Jan 2012 15:11:02
23 Jan 2012 15:11:02 Francesco Zenere replied:
Hallo George!
I've simply replicated a table, that I named "calendar" with ID, description start and stop etc. as you need in the ajax event calendar, but it doesn't work.
see dump attached
I've simply replicated a table, that I named "calendar" with ID, description start and stop etc. as you need in the ajax event calendar, but it doesn't work.
see dump attached
/* Navicat Oracle Data Transfer Source Server : DIAP60T Source Server Version : 92050 Source Host : 192.168.0.102 Source Schema : OPS$DIAP60 Target Server Version : 92050 File Encoding : utf-8 Date: 01/23/2012 16:00:05 PM */ -- ---------------------------- -- Table structure for "IMRDCALENDAR" -- ---------------------------- DROP TABLE "IMRDCALENDAR"; CREATE TABLE "IMRDCALENDAR" ( "event_id" NUMBER NOT NULL, "event_title" VARCHAR2(250CHAR) NOT NULL, "start" DATE NOT NULL, "stop" DATE NOT NULL, "description" VARCHAR2(500BYTE), "link" VARCHAR2(500BYTE), "type" NUMBER); -- ---------------------------- -- Records of "IMRDCALENDAR" -- ---------------------------- INSERT INTO "IMRDCALENDAR" VALUES ('1', 'TEst', TO_DATE('2012-01-23 00:11:44','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2012-01-23 00:11:48','YYYY-MM-DD HH24:MI:SS'), 'test event', 'www.imeas.it', '1'); INSERT INTO "IMRDCALENDAR" VALUES ('2', 'TEst2', TO_DATE('2012-01-24 00:16:50','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2012-01-25 00:16:52','YYYY-MM-DD HH24:MI:SS'), 'test 2', 'www.imeas.it', '2'); INSERT INTO "IMRDCALENDAR" VALUES ('3', 'TEST3', TO_DATE('2011-12-30 15:13:53','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2011-12-31 15:13:59','YYYY-MM-DD HH24:MI:SS'), 'TEST NO.3', null, '1'); COMMIT; -- ---------------------------- -- Primary key structure for table "IMRDCALENDAR" -- ---------------------------- ALTER TABLE "IMRDCALENDAR" ADD CONSTRAINT "SYS_C00218046" PRIMARY KEY("event_id");