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
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


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


Reply to this topic