I have downloaded Connector Java Edition v1.5 and run the scheduler samples on my local, for example: localhost/scheduler/04_recurring_events.html. I can load events from databases and modify those events loaded, but I can’t create any new events. Would you please enlighten me how to do it. Thanks in advance.
Best regards,
Taylor
P.S. The database is MySQL and the schema of event table is as following:
CREATE TABLE events_rec ( event_id INT(11) NOT NULL AUTO_INCREMENT, start_date DATETIME DEFAULT NULL, end_date DATETIME DEFAULT NULL, text VARCHAR(255) DEFAULT NULL, details TEXT, rec_type VARCHAR(64) DEFAULT NULL, event_pid INT(11) DEFAULT NULL, event_length INT(11) DEFAULT NULL,
PRIMARY KEY (event_id)
) ENGINE=MYISAM DEFAULT CHARSET=latin1
As you suggested, I enabled the log by adding code {{{c.enable_log(“temp.log”,true);}}} to class scheduler_04_recurring_events_connector. But I got the following exception.
[[[
java.io.IOException: Stream closed
at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:26)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:121)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212)
at com.dhtmlx.connector.LogManager.close(LogManager.java:114)
at com.dhtmlx.connector.ConnectorServlet.doGet(ConnectorServlet.java:31)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
]]]
Many many thanks for your help. But, after I update the connector library, I got following exception.
[[[
SEVERE: Servlet.service() for servlet [scheduler_04_recurring_events] in context with path [] threw exception [Servlet execution threw an exception] with root cause
java.lang.NoSuchMethodError: com.dhtmlx.connector.SchedulerConnector.render_table(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
at scheduler_04_recurring_events_connector.configure(scheduler_04_recurring_events_connector.java:21)
at com.dhtmlx.connector.ConnectorServlet.doGet(ConnectorServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
…
]]]
The code at line 21 of scheduler_04_recurring_events_connector.java is as following:
{{{c.render_table(“events_rec”,“event_id”,“start_date,end_date,text,rec_type,event_pid,event_length”,"","");}}}