Peter Hopfgartner a écrit : > 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! > > This is a known issue: http://issues.ez.no/IssueView.php?Id=11304&activeItem=1 This one also might be somewhat related: http://issues.ez.no/IssueView.php?Id=10550&activeItem=1
I think there is no date set yet for fixing it... ciao Gaetano -- Components mailing list Components@lists.ez.no http://lists.ez.no/mailman/listinfo/components
