using scheduler with oracle

Scheduler Javascript
#1

i created the dump.sql in oracle for scheduler.
using netbeans i created BasicConnector.java and successfully built a dhx.jar from that
but i have no idea how to implement it.

im trying to use 09_connector_options.html

can anyone help me?

ok. i have tried hundreds of variations of your example.

the last set was to alter 09_connector_options.html to call my_connector.php
with the following entries:

//my_connector.php
require(“connector/grid_connector.php”);// connector file
require(“connector/db_oracle.php”);
$res = oci_connect(“dhx”, “dhx”, $db);
$gridConn = new GridConnector($res,“Oracle”);

//$res=mysql_connect(“jdbc:oracle:thin:@kami.attuneinc.com:1521:kami”,“dhx”,“dhx”);// db connection
//mysql_select_db(“kami”); // db connection

$gridConn->render_table(“mytable”,“item_id”,“item_nm,item_cd”);// data configuration

… none of which worked.

can anyone suggest anything please.

#2

Something like


require("connector/grid_connector.php");// connector file
require("connector/db_oracle.php");
$res = oci_connect("dhx", "dhx", $db);

$scheduler = new schedulerConnector($res,"Oracle");
$scheduler->render_table("events","event_id","start_date,end_date,event_name,details");

If above doesn’t work, try to change last line as

$scheduler->render_table("events","EVENT_ID(event_id)","START_DATE(start_date),END_DATE(end_date),EVENT_NAME(event_name),DETAILS(details)");
#3

i tried your suggustions with no results.

all i get is the oracle_events.php printed on the screen which tells me nothing.

im listing the relevent 3 files in hopes someone can spot something wrong…

im using 09_connector_options.html:

html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; }
 
 

the load calls oracle_events.php:

<?php include ('../../../codebase/connector/scheduler_connector.php'); include ('../../common/oracle_config.php'); require("connector/grid_connector.php");// connector file require("connector/db_oracle.php"); $res = oci_connect("dhx", "dhx", $db); $scheduler = new schedulerConnector($res,"Oracle"); $scheduler->render_table("events","EVENT_ID(event_id)","START_DATE(start_date),END_DATE(end_date),EVENT_NAME(event_name),DETAILS(details)"); ?>

which has the oracle_config.php:

<?php $server = "173.203.48.248"; $user = "dhx"; $pass = "dhx"; $db_name = "DEVQA"; ?>

what is the $server = statement looking for exactly?

#4

is it possible to get some kind of log instead of the calendar with no data and a window with
the contents of oracle_config.php popping up?

#5

Hello,

Please add folowing:

$scheduler->enable_log("log.txt",true);

After you’ve created $scheduler variable but before render_table call.

Kind regards,
Ilya

#6

THANKS, I DID FIND AND ACTIVATE THAT A WHILE BACK BUT IT NEVER GETS THERE.

#7

still getting nowhere. any suggestions???

#8

does anyone have a working example of loading an oracle database?

the 09_connection_options.html loads php/events.php
then runs common/config.php which addresses the cloud

and executes a calendar with data?

mine keeps showing a blank calendar with a popup displaying the contents of the event.php file

#9

in the config.php i am attempting to address our oracle db in the cloud as such:

<?php $server = "173.203.48.248"; $user = "dhx"; $pass = "dhx"; $db_name = "DEVQA"; ?>

what exactly is the $server looking for? does it require http:// , the port , the db name , etc???

#10

Hi,
first of all make sure that your web-server works correctly and you requests your page by URL, not a local file by calling D://www/sample/09_connector_options.html for example.
Then try to load file ./php/oracle_events.php directly in browser.
It should generate correctly xml with events.
Does it work?

By the way, it would be better for you to change database password, I think it’s a little confidential information :slight_smile: .