Dear ezComnuity,
I would like to use the Tree functionality for a database located in a
Oracle database. Unfortunatly I hava a couple of problems, that may be
caused by the fact that
* I'm new to ezComponents
* I'm new to Oracle
I defined the table as
CREATE TABLE taxonomy
(
id NUMBER PRIMARY KEY,
parent_id NUMBER ,
path VARCHAR2(255)
);
Since Oracle defaults to UPPER CASE, the name of the table is "TAXONOMY".
When I try to use ezcTreeMaterializedPath, I see that would like to run
a query like <INSERT INTO "taxonomy" ( path ) VALUES ( 0 )>. Since the
table name is quoted, Oracle does searches for a table called
"taxonomy", not "TAXONOMY". So my question is: what are the
convenctions when using ez Componets on Oracle? Should all table names
turned to lower case? Is there a database setting, which basically tells
Oracle to not care about case sensitivity? Or even better, a parameter
within ez, like the option "auto_quote" in PEAR::MDB2, so that names are
not quoted.
Out of curiosity, I tried to create a new table named "taxonomy". The
next stop arrived with a flashing message like "driver does not
support lastInsertId()". Is this fixable? Should I have a look at it?
Obviously, as a workaroud I may chose to create the id myself and turn
$tree->autoId = false; This works!
Regards,
Peter
--
Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: [email protected]
Tel. : +39 0473 494949
Fax : +39 0473 069902
www : http://www.r3-gis.com
--
Components mailing list
[email protected]
http://lists.ez.no/mailman/listinfo/components
