Hello!
I believe I found the problem:
- In class.egw_db.inc.php in the function quote we call to the
function dbdate, for mysql and postgre the data returned is the same
’$value’, but for oracle this is convert to
TO_DATE(’$value’,‘YYYY-MM-DD’) and is not handled correctly by adodb
CreateTableSql function.
I changed the line 1113 of the function quote (class.egw_db.inc.php)
to return the value without call to the dbdate function and then the
table is created:
case 'date':
//return $this->Link_ID->DBDate($value);
return $value;
I tested with mysql 5.0.18, postgre 8.1 and oracle 9i.
Can you review the change for inclusion if this don’t break anything else?
Thanks
Hi Everybody!
I’m looking to get egroupware working in Oracle.
To acomplish the target I’m expect to do so in smaller steps:
- Schema Proc
- change the schema to generate index, etc… no more than 30 characters.
- Fix the default date TO_DATE in predetermined dates
- Change table names with more than 30 characters
- Change the reserved names fields of tables:
- access, resource, … and document this for new developments
Firsts the api, then all aps
I’m trying to fix the dafaul dates now (Ex. Table egw_vfs):
vfs_created D NOTNULL DEFAULT TO_DATE(‘1970-01-01’,‘YYYY-MM-DD’)
Table egw_vfs, with adodb function dbdata from 1970-01-01 we get
TO_DATE(‘1970-01-01’,‘YYYY-MM-DD’), it is OK for oracle!
Then we call to the function CreateTableSQL (adodb-datadict.inc.php)
with the correct format.
The function call to the _GenFields function that uses the
Lens_ParseArgs function to strip the table fields definition.
Lens_ParseArgs convert TO_DATE(‘1970-01-01’,‘YYYY-MM-DD’) in two items:
TO_DATE and ‘1970-01-01’,'YYYY-MM-DD’
Then _GenFields only treat TO_DATE and the table is not created.
vfs_created DATE DEFAULT ‘TO_DATE’ NOT NULL
I was spent many hours triing to understand the Lens_ParseArgs
function on adodb-datadict.inc.php to solve the problem, without
results. I’m not a php expert, I need a little help in this please!
Many Thanks in advance.
Oracle support needs some work in that area. The names used for indexes
are to long. The names get genearted in the schema_proc class. At the
moment we support 2 forms to generate it:
- a long form using table and all column names used by most dbms
- a short form used by MaxDB and Oracle
Unfortunally Oracle is even more limited in that aspect.
I dont have time to work on it 
The algorithm must generate a reproducable name (when you ask it the
next time for an index-name for table x and colums y,z it must give the
identical name).
If you can fix it, I’m happy to apply the patch.
Ralf
pcamposs schrieb:
Hello to all,
i whant to know, if egw(HEAD) has support for oracle 9i.
it tries it to install but it shows the following error to me
"
The following indexes are created. The problem is the name
is way too long, resulting in the following error:
ORA-00972: identifier is too long – while processing OCI
function OPARSE
"
I dont write english well, because i am a men from CHILE
PD: today I am going to install version RC3
Grcias
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
eGroupWare Training & Support ==> http://www.egroupware-support.de
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
