Hi Peter, I've had the issue with uppercase myself once and it is since then documented at:
http://ezcomponents.org/docs/tutorials/Database#restrictions The import code is at Database/handler.php, line 91: $this->setAttribute( PDO::ATTR_CASE, PDO::CASE_LOWER ); This means, that all identifiers needs to be lower case. This is enforced to keep code compatibility across all supported databases. I'm sorry, but I've no idea about the second issue. Wait a bit if the eZ guys will answer you. Cheers, Thomas Koch Am Friday 27 February 2009 19:02:31 schrieb Peter Hopfgartner: > 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 -- Thomas Koch, http://www.koch.ro YMC AG, http://www.ymc.ch -- Components mailing list [email protected] http://lists.ez.no/mailman/listinfo/components
