Revision #5 has been created by Trejder on Dec 15, 2010, 9:37:22 AM with the memo:
Subtitles shorthen and fifth part (Active Record and Oracle) added
« previous (#4) next (#6) »
Using Yii with Oracle through PDO
oracle, pdo oci php
When you are developing an webapp with Yii that will be using Oracle RDBMS you should take a look at these issues in which you may run into it.
1. Setting (f
for returned results
Oracle database **does not support setting charset in configuration file with charset parameter**, i.e. like this:
[...]There was a bug in Yii 1.1.4 which caused that an attempt to pass charset as in first example would cause an error, because Yii tried to set charset with SET NAMES statement, which is not supported by PL/SQL on board Oracle. This bug has been corrected, but even so, if you use second approach, you'll be able to force Oracle to return result in any charset encoding you want (if it is supported by Oracle, of course).
2. Setting login information
Some (all?) versions of Oracle don't support passing login and password as a part of DSN string. You'll have to pass it like this:
[...]In case of these version, if you pass login and password via DSN but leave login and password parameters empty, you'll receive error that login attempt failed.
3. Errors in DSN
Oracle has a very bad feature which causes that, if you have an error in your DSN, it will first **try to connect with provided login and password on localhost** and only if this attempt fail, it will issue an error.
[...]I spend hours trying to find why exactly the same code is not working on machine C, while it works with no problems on machine A? Only to find out that app on neither of these machines is connecting to machine B (due to errors in DSN), but tries to connect to localhost.
4. Oracle column names case-sensitivity
Column names in Oracle are **case-sensitive**. This means that if you use all uppercase characters when creating a table (common behaviour among Oracle developers) and then try to access it with model and ActiveRecord for example like this:
[...]You will get data only for first iteration and for first field in it. When evaluating second field, you app will throw exception saying that _Property Users.pass is undefined_.
Tip: The cause is seems to be only partially Oracle-related. Oracle does not relies on case-sensitivity of column names as long as they are not specified within quotation marks. If so, it takes exact column name spelling as provided. Therefore, it seems that somewhere in Yii code underlying below ActiveRecord there have to be a part which escapes table name with quotation mark, making above mentioned problems.