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");

