Re: Using Oracle with Cake
The latest CakePHP 1.x has a dbo_odbc.php. Have you tried setting up your Oracle as ODBC and using that?? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Using Oracle with Cake
I'm interested in an Oracle dbo driver for Cake. Can you post your code so I can test it and report any bug/info ? Otherwise, what about a Oracle support in Cake (either by OCI native or PEAR driver) ? nate, you told me once a PEAR driver may be available in May... Any info or delay about it ? thanks by advance tom (going to install 1.0, great !) nate wrote: Open an Enhancement ticket on Cake Trac (https://trac.cakephp.org). Also, you can hop on Cake's IRC at irc.freenode.net, or http://irc.cakephp.org. Or email me. I just implemented an SQL Server driver, so I might be able to lend you some insights. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Using Oracle with Cake
There were some things with my dbo_oracle that were causing problems: * PHP OCI functions do not return the table, so everything was being put into the [0] array, which caused problems if the column name from different tables were used. * The base dbo_source.php file was aliasing tables with the keyword AS, which Oracle doesn't seem to like. It works ok without the 'AS' keyword. * There is no 'insert_id' function for Oracle like there is for MySQL. We are using a sequence table. I think this is standard for Oracle, so I need to figure out a way to get the lastInsertID working properly. * I'm sure that there will be other things that crop up. I am trying to get this all working, but I am having to delve into the dbo_source.php and datasource.php files, so it's not going to be pretty. I can't seem to get adodb-oci8 to work and I'm not sure about a PEAR driver. Anyone have any more suggestions? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Using Oracle with Cake
I have a not so elegant first round attempt at getting oracle to work. I modified the dbo_source.php and datasource.php files. I also created a dbo_oracle.php file. The code for all three is at http://cakephp.org/pastes/show/081dbc0d1d0c131feec6be10e02d9285 Please give me suggestions on how to improve it. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---