cakephp 3.0 and snelg/cakephp-3-oracle [ Error: [Cake\Database\Exception] Cannot describe s_i18_n. It has 0 columns.]

2016-01-29 Thread Mbhd90
When i try to perform bake command i receive this exception Exception: Cannot describe s_i18_n. It has 0 columns. in [/var/www/html/3.0/app-master/vendor/cakephp/cakephp/src/Database/Schema/Collection.php, line 98] 2016-01-21 15:07:24 Error: [Cake\Database\Exception] Cannot describe s_i18_n. I

Re: Postgresql for Oracle in CakePHP

2014-11-17 Thread mark_story
Hey Carlos, The last version of CakePHP that had support for Oracle was 1.3. We've not been able to get support for oracle into 2.x or 3.0 primarily because of licensing issues and lack of experience. Because of how oracle is licensed adding it to one of our existing continuous integr

Postgresql for Oracle in CakePHP

2014-11-12 Thread Carlos Henrique Amaral Santos
Hi, I'm working on a system, using CakePHP 1.1 and database PostgreSQL. There's a change of the database from PostgreSQL for Oracle. Someone had issue with something like it? Someone suggests some version of the Cake that works well with Oracle? -- Like Us on Face

Re: Cake 2.5 connecting to Oracle

2014-10-26 Thread ProFire
I used to use the attached datasource, heavily modified from Cake1.3 In the config file, these are the settings public $oracle = array( 'datasource' => 'Database/Oracle', 'driver' => 'oracle', 'connect' => &

Re: Cake 2.5 connecting to Oracle

2014-10-20 Thread Domingos Coelho
I have the same problem last week and I found this: http://www.hassanbakar.com/2012/01/09/using-oracle-in-cakephp-2-0/ it needs minor adjustments but it's functional as well. But, if someone has other examples/links will be good Em segunda-feira, 13 de outubro de 2014 02h39min17s

Cake 2.5 connecting to Oracle

2014-10-12 Thread Sebastian
Hello, In Cake 1.3 it was possible to connect to Oracle. In CakePHP 2.5 I don't find a Datasource. I would like to know if there roadmap for 2.6 or 3.0 to connect to Oracle? Did somebody know a datasource implementation for CakePHP 2.5 Looking forward to get your responce. Best Re

CakePHP and Oracle

2013-04-08 Thread GuiPedrosa
Hello to everyone, i am using CakePHP 1.3.14(15) with Oracle. But the newer versions of CakePHP officially doesnt support Oracle. Do you know if it will be developed? Is there any news about that? I am working in a company and we will be changing the Framework in the future if we dont find a

Re: Sequence in Oracle

2012-10-24 Thread Galdan
INTO :new.carl_id FROM dual; END IF; END; Best regards Tom Am Montag, 2. Juli 2012 19:53:19 UTC+2 schrieb Bruno Augusto: > > friends, > > I am using oracle database and when execute the save command the oracle > save and on the same time it run a currval sequence. The problem is

Sequence in Oracle

2012-07-02 Thread Bruno Augusto
friends, I am using oracle database and when execute the save command the oracle save and on the same time it run a currval sequence. The problem is I do not need to use sequence in this table. Is there anyway from cake does not execute the sequence? -- Our newest site for the community

Sequence in Oracle

2012-07-02 Thread Bruno Augusto
Friends, I am using oracle database and when execute the save command the oracle save and on the same time it run a currval sequence. The problem is I do not need to use sequence in this table. Is there anyway from cake does not execute the sequence? -- Our newest site for the community

Re: Oracle

2012-05-30 Thread oDiN
i can pass params on my find call .. refer this https://bitbucket.org/odin88/cakephp-2.0-oracle/changeset/535a4133a59e On Tuesday, 22 May 2012 21:38:41 UTC+8, rihad wrote: > > Have you been able to use any conditionals in your find() calls? > I can't use even the simplest ones. S

Re: Oracle

2012-05-22 Thread rihad
On May 22, 11:58 am, oDiN wrote: > I dont have problems with the prefix table .. :) > When you connect as the owner of the database, you don't need to use the prefix. But when you grant selective access to another user, he generally needs to say schema_name.table_name. -- Our newest site for t

Re: Oracle

2012-05-22 Thread rihad
Have you been able to use any conditionals in your find() calls? I can't use even the simplest ones. See this thread: http://groups.google.com/group/cake-php/browse_thread/thread/234f4a33b862d79a# On May 22, 4:31 pm, oDiN wrote: > I have update the blog post. Check the latest code at Bitbucket. A

Re: Oracle

2012-05-22 Thread oDiN
I have update the blog post. Check the latest code at Bitbucket. Also the stored procedure works fine too in CakePHP 2.1.2 On Monday, 21 May 2012 20:46:46 UTC+8, rahajiyev wrote: > > OMG, I just succeeded in getting paginator to work properly, with > sorting and all that! Apart from what was sai

Re: Oracle

2012-05-21 Thread oDiN
I dont have problems with the prefix table .. :) On May 21, 8:46 pm, rahajiyev wrote: > OMG, I just succeeded in getting paginator to work properly, with > sorting and all that! Apart from what was said in the tutorial above, > I also needed to tweak function describe() in Oracle.php. > > The lin

Re: Oracle

2012-05-21 Thread rahajiyev
OMG, I just succeeded in getting paginator to work properly, with sorting and all that! Apart from what was said in the tutorial above, I also needed to tweak function describe() in Oracle.php. The line where it says $sql = 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE ta

Oracle

2012-05-21 Thread rahajiyev
Has anyone had any luck using Oracle database in 2.1.2? I was able to migrate oracle.php from 1.3.15 using this howto: http://www.hassanbakar.com/2012/01/09/using-oracle-in-cakephp-2-0/ but am having trouble using find() even on simplest tables. -- Our newest site for the community: CakePHP

Re: Using Oracle

2012-05-12 Thread John Hardy
IMO with a cluttered schema i would rely on stored procedures for the abstraction and keep the code complexity at a minimum On May 11, 2012 11:54 PM, "rihad" wrote: > Most tables in our Oracle database are huge with tens of columns, have > no single-column primary keys, or have m

Re: Using Oracle

2012-05-11 Thread rihad
Most tables in our Oracle database are huge with tens of columns, have no single-column primary keys, or have multi-column keys. Can CakePHP 2.1 make sense of it all? -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site

Re: Using Oracle

2012-05-11 Thread rihad
Thanks, stork. I've followed this little guide: http://www.hassanbakar.com/2012/01/09/using-oracle-in-cakephp-2-0/comment-page-1/#comment-38958 and could successfully migrate dbo_oracle.php from 1.3.15 to 2.1, allowing Cake's index.php to pass all its preliminary tests. Is it a bit e

Re: Using Oracle

2012-05-11 Thread stork
Watch, comment, and/or help with this ticket: http://cakephp.lighthouseapp.com/projects/42648/tickets/2232-oracle-11g-datasource-for-cakephp-20 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org

Using Oracle

2012-05-10 Thread rihad
Hi, folks. Can I use CakePHP 2.1.2 with Oracle database? I looked in Model/Datasource/Database/ there only seems to be support for Mysql, Postgres, Sqlite, Sqlserver. But working with an existing Oracle database is my job's requirement. I would be thankful for any tips. Thank you. -- Our n

Problem with cakephp 1.3.8 + oracle with sequences

2011-07-10 Thread jbmere
Hello Sorry for this newbie question but inside a controller I've have three continuous calls a oracle sequence nextval. for example: $opd = $this->Usuario->query("select pn_object_sequence.nextval from dual"); pr($opd); $

Re: CakePHP and Oracle redirecting problem

2011-06-21 Thread Ahsan Khan
My debug level is already 2 but nothing shows. On Jun 21, 1:10 pm, Ryan Schmidt wrote: > On Jun 21, 2011, at 02:01, Ahsan Khan wrote: > > > I just start an application with cakephp and oracle, it displayed that > > it can find database.php but also get 2 errors, t

Re: CakePHP and Oracle redirecting problem

2011-06-21 Thread Ryan Schmidt
On Jun 21, 2011, at 02:01, Ahsan Khan wrote: > I just start an application with cakephp and oracle, it displayed that > it can find database.php but also get 2 errors, they are related to > redirecting. And what are those errors, specifically? > If i paste any controller name direc

CakePHP and Oracle redirecting problem

2011-06-21 Thread Ahsan Khan
I just start an application with cakephp and oracle, it displayed that it can find database.php but also get 2 errors, they are related to redirecting. If i paste any controller name directly it shows me a blank page. Is there anyone can help me to find this solution? -- Our newest site for the

Re: Cakephp,Auth with Oracle connectivity

2011-04-12 Thread ojonam
Hi, because you changed you alias, the results from the database are stored in a "Mem" hash instead of a "User" hash. You need to modify your views to reflect the change as well. Also, click on the notice, you will get more information as to where the error might have occured. Cheers, ojonam

Re: Cakephp,Auth with Oracle connectivity

2011-04-11 Thread Tapan Kumar Thapa
Hello Manoj, I can confirm that after putting alias, i am able to login with oracle database. However in my login page after putting alias i am getting some notice and warning. *Notice* (8): Trying to get property of non-object [*CORE\cake\libs\view\helper.php*, line *458*] *Warning* (2

Re: Cakephp,Auth with Oracle connectivity

2011-04-11 Thread Tapan Kumar Thapa
Nice to know that after such a long time someone is there to help... I will try this and will get back in case it works.. Regards Tapan Thapa On Mon, Apr 11, 2011 at 8:11 PM, ojonam wrote: > Hi, > > this is because Oracle has a list of reserved keywords (like "User") whic

Re: Cakephp,Auth with Oracle connectivity

2011-04-11 Thread ojonam
Hi, this is because Oracle has a list of reserved keywords (like "User") which make your query impossible to deal with for Oracle. The full list is available here : http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm. This means that you cannot use the term '

Re: Cakephp,Auth with Oracle connectivity

2011-04-08 Thread Zaky Katalan-Ezra
http://procsharp.blogspot.com/2011/04/connect-oracle-with-cakephp.html -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe

Cakephp,Auth with Oracle connectivity

2011-04-08 Thread Tapan Thapa
Hello Community, I am trying to integrating cakephp, auth and oracle. I have defined my connection string like below: var $default = array( 'driver' => 'oracle', 'persistent' => true, 'host' => 'x.x.x.x&#x

Re: CakePHP + Oracle : query other schema

2011-03-08 Thread Guillaume Luszack
Actually it seems to be working with a view. No need for a synonym. As long as the user you're connected with has granted rights on the tables you're guerying of course:) Sorry for not trying with a view earlier ! G. Selon Zaky Katalan-Ezra: Did you try to create a view for the synoname?

Re: CakePHP + Oracle : query other schema

2011-03-07 Thread Zaky Katalan-Ezra
Did you try to create a view for the synoname? On Mon, Mar 7, 2011 at 9:53 PM, guix69 wrote: > Database is the same, only the schema is different. > > My database.php contains the settings to connect to SCHEMA1 but I > would like to make a model to query data from SCHEMA2 > > I tried using a syn

Re: CakePHP + Oracle : query other schema

2011-03-07 Thread guix69
Database is the same, only the schema is different. My database.php contains the settings to connect to SCHEMA1 but I would like to make a model to query data from SCHEMA2 I tried using a synonym (inside SCHEMA1, pointing to the desired table inside SCHEMA2) but it looks like the synonym is invis

Re: CakePHP + Oracle : query other schema

2011-03-07 Thread Zaky Katalan-Ezra
Use database link<http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_5005.htm> On Mon, Mar 7, 2011 at 5:39 PM, guix69 wrote: > Hello, > > My app is configured via database.php to query a specific oracle > schema. Is there a way to define a model

CakePHP + Oracle : query other schema

2011-03-07 Thread guix69
Hello, My app is configured via database.php to query a specific oracle schema. Is there a way to define a model for data stored in another schema? (or is there no other way than querying directly in SQL?) Thanks G. -- Our newest site for the community: CakePHP Video Tutorials http

Re: Conneect with Oracle

2011-02-24 Thread Nguyễn Trịnh Hồng Ngọc
thanks so much ^^ I have check it and I can connect to oracle database ^^ I use configuration like this: 'driver' => 'oracle', 'connect'=>'oci_connect', 'persistent' => false,

Re: Conneect with Oracle

2011-02-22 Thread Zaky Katalan-Ezra
Linux? windows? Do you see OCI in phpinfo()? -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to

Re: Conneect with Oracle

2011-02-22 Thread Nguyễn Trịnh Hồng Ngọc
'connect' field. > >         var $default = array( >                 'driver' => 'oracle', >                 'connect' => 'oci_connect', >                 'persistent' => false, >                 'host&

Re: Conneect with Oracle

2011-02-19 Thread Zaky Katalan-Ezra
This one should work: var $default = array('driver' => 'oracle', 'connect' => 'oci', 'persistent' => false, 'host' => 'localhost', 'port'=>1521,

Re: Conneect with Oracle

2011-02-18 Thread ojonam
Hi, I had a few issues with the configuration as well. Try removing the host name and adding it as a prefix to the database field. Also, specify the 'connect' field. var $default = array( 'driver' => 'oracle',

Conneect with Oracle

2011-02-18 Thread Nguyễn Trịnh Hồng Ngọc
Hello everybody, I'm trying to make a connection between CakePHP and Oracle with configuration database: class DATABASE_CONFIG { var $default = array( 'driver' => 'oracle', 'persistent' => fa

Re: oracle 10g connection with cakephp 1.3

2011-02-15 Thread majna
and remember to use 'charset' key for oracle instead of 'encoding' if needed :( On Feb 15, 11:05 am, Zaky Katalan-Ezra wrote: > I did it this way: > Install xammp > 1.enable "extension=php_oci8.dll" in php.ini > > 2.Set database.php

Re: oracle 10g connection with cakephp 1.3

2011-02-15 Thread Zaky Katalan-Ezra
I did it this way: Install xammp 1.enable "extension=php_oci8.dll" in php.ini 2.Set database.php var $default = array('driver' => 'oracle', 'connect' => 'oci', 'persistent' => false,

Re: oracle 10g connection with cakephp 1.3

2011-02-15 Thread Tosun or Shadin
Window XP. On 15 February 2011 12:24, Zaky Katalan-Ezra wrote: > Windows/Linux? distribution? > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related

Re: oracle 10g connection with cakephp 1.3

2011-02-14 Thread Zaky Katalan-Ezra
Windows/Linux? distribution? -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubs

oracle 10g connection with cakephp 1.3

2011-02-14 Thread shadheen
Hello, I new user of cakephp. I need help to connect oracle 10g release 2 with cakephp 1.3. can anyone please help me by describing the full procedure for establishing the connection. please, please do help, I am in great trouble. Thanks... -- Our newest site for the community: CakePHP Video

oracle connection with user prefix to tables

2010-12-21 Thread ojonam
Hello all, I am starting a cakephp project which runs atop oracle (imposed, not willingly chosen). There are two user accounts, an ADMIN one (with read access), and a READER one. For accessing to a given table using the READER account, I need to refer to a table as ADMIN.table. In cake, if I set

cake bake and oracle

2010-12-13 Thread ojonam
Hello all, I'm trying to generate models for my oracle db using cake bake, but this is what I get: Welcome to CakePHP v1.3.6 Console --- App : app Path: /home/manojo/workspace/myap

Re: Inserting Arabic data into Oracle DB

2010-12-09 Thread cricket
to be some issue with Oracle, UTF-8, and PHP. See this link, for example: http://forums.oracle.com/forums/thread.jspa?messageID=1930036 I don't recall ever seeing anything about AL32UTF8 before. Another search shows quite a lot of links. Check out the new CakePHP Questions site http://cake

Re: Inserting Arabic data into Oracle DB

2010-12-09 Thread osamo101
ine > > 'encoding' => 'UTF8' > > Are you sure that Oracle wants 'UTF8' and not something else (eg. > 'utf-8', 'UTF-8', etc.)? > > > and the insertion code is as follows > > $this->Activity->query("INSERT IN

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread cricket
2010/12/8 osamo101 : > In DATABASE_CONFIG I added the following line > 'encoding' => 'UTF8' Are you sure that Oracle wants 'UTF8' and not something else (eg. 'utf-8', 'UTF-8', etc.)? > and the insertion code is as follows > $t

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
Yes On Dec 9, 12:34 am, Ryan Schmidt wrote: > On Dec 8, 2010, at 16:30, osamo101 wrote: > > > In DATABASE_CONFIG I added the following line > > 'encoding' => 'UTF8' > > > and the insertion code is as follows > > $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) > > VALUES('some

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread Ryan Schmidt
On Dec 8, 2010, at 16:30, osamo101 wrote: > In DATABASE_CONFIG I added the following line > 'encoding' => 'UTF8' > > and the insertion code is as follows > $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) > VALUES('some_name', 'خخخ')"); Is this PHP file also saved with UTF-8

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
wrote: > On Dec 8, 2010, at 04:22, osamo101 wrote: > > > I am trying to insert Arabic characters into oracle db but i got > > question marks inserted instead, I mad sure that the db accepts Arabic > > characters, I created a sample ASP application and it inserted the > >

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread cricket
On Wed, Dec 8, 2010 at 5:22 AM, osamo101 wrote: > Hi > > I am trying to insert Arabic characters into oracle db but i got > question marks inserted instead, I mad sure that the db accepts Arabic > characters, I created a sample ASP application and it inserted the > Arabic ch

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread Ryan Schmidt
On Dec 8, 2010, at 04:22, osamo101 wrote: > I am trying to insert Arabic characters into oracle db but i got > question marks inserted instead, I mad sure that the db accepts Arabic > characters, I created a sample ASP application and it inserted the > Arabic characters correctly.

Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
Hi I am trying to insert Arabic characters into oracle db but i got question marks inserted instead, I mad sure that the db accepts Arabic characters, I created a sample ASP application and it inserted the Arabic characters correctly. Can you please help me, I spent more than two days in trying

bake and oracle issue

2010-12-05 Thread Harrykirsten
Your database does not have any tables. My database.php file under app/config/ looks like this: var $test = array( 'driver' => 'oracle', 'persistent' => false, 'host' => 'myho

Re: ORACLE - missing database table

2010-06-17 Thread cricket
is "missing expression" and it looks like it's missing something between SELECT and FROM (but I know little about Oracle so I'm guessing). Maybe the problem is with the DboOracle class. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP

ORACLE - missing database table

2010-06-17 Thread Florian
Hello everyone, i ran into some trouble when switching from mySQL to ORACLE. In mySQL i created the table names in lower case. Now after switching to ORACLE it's seems CAKE has some problems to find the tables inside ORACLE, table names also lower case. my dbconfig looks like: var $de

Re: Complex find() using Oracle

2010-02-18 Thread Tony Fugere
Sample.id,1), '1', 1, 0)) AS \"Sample.case_col\"" ); $this->assertEqual($result, $expected); } One could argue that I shouldn't be using DECODE anyways as it is Oracle SQL specific. If this app were to change databases, I would have to rewrite a l

Re: Complex find() using Oracle

2010-02-18 Thread Martin Radosta
I would only change: $this->find('all', array('fields' => $fields,...etc, etc.) Would be great if you post the test case (or even better, a patch) to avoid other people waste time with the same issue. Bye MARTIN On 02/18/2010 05:39 PM, Tony Fugere wrote: It does not fix the problem. Am I

Re: Complex find() using Oracle

2010-02-18 Thread Tony Fugere
It does not fix the problem. Am I doing it correctly? $dbo = $this->getDataSource(); $expression = $dbo->expression('SUM(DECODE(SUBSTR(ServiceData.stat_parameter,22), \'service1\', ServiceData.stat_value,0)) AS "ServiceData.service1"'); $fields = array('ServiceData.stat_date', $ex

Re: Complex find() using Oracle

2010-02-18 Thread Martin Radosta
Check the text case in this commit for an example: http://github.com/cakephp/cakephp1x/commit/02330b2d9c292110240c606e976e182c973897e9 let me know if that fix the problem, if not, you can prepare a test case and report the issue. On 02/18/2010 03:21 PM, TonyFugere wrote: I don't follow wha

Re: Complex find() using Oracle

2010-02-18 Thread TonyFugere
I don't follow what you mean by "Try using expression for fields." Can you clarify or give me an example? On Feb 18, 11:12 am, Martin Radosta wrote: > CakePhp is not correctly parsing the alias for the decode fields, thats > why you see decode... on array keys. > Try using expression for fields.

Re: Complex find() using Oracle

2010-02-18 Thread Martin Radosta
CakePhp is not correctly parsing the alias for the decode fields, thats why you see decode... on array keys. Try using expression for fields. If that works, should also fix the data missmatch. Regards MARTIN On 02/18/2010 02:38 PM, TonyFugere wrote: I've search this group and Google for a

Complex find() using Oracle

2010-02-18 Thread TonyFugere
I've search this group and Google for a solution without any luck. I can read (SELECT) data, but cannot change this database at all. To get the data I run the following find: $this->find('all', array( 'fields' => array( 'ServiceData.stat_date', 'SUBSTR(ServiceData.stat_parameter

Re: MySQL takeover by Oracle - petition

2010-01-05 Thread LunarDraco
Isn't it nice to have a descent data layer like we do in cake. Granted it might be a few days work to switch from MySQL to something like PostgreSQL for a decent sized project. But you probably have a few years before we ever get to that point where we are forced to do so. Don't sweat the small stu

Re: MySQL takeover by Oracle - petition

2010-01-05 Thread Dinh
extent. > Do you think Oracle will some day drop their prices up to the > point that a SMB will be able to pay a license for it ? > Oracle database is not a sole product owned by Oracle. As you may know, you can download and install Oracle database for free. Oracle 10g Express Edition was

Re: MySQL takeover by Oracle - petition

2010-01-05 Thread Juan Luis Baptiste
On Tue, Jan 5, 2010 at 9:15 AM, Dinh wrote: > Is it trustworthy? Oracle is not friendly to open source at all. They can > kill MySQL just by delaying to fix bugs. MySQL development is rather open. > It is quite opposite to Oracle style. > AFAIK it was one of the conditions imposed b

Re: MySQL takeover by Oracle - petition

2010-01-05 Thread Dinh
Is it trustworthy? Oracle is not friendly to open source at all. They can kill MySQL just by delaying to fix bugs. MySQL development is rather open. It is quite opposite to Oracle style. I think you are overreacting, have you read Oracle's public position > on this ? I think not: &g

Re: MySQL takeover by Oracle - petition

2010-01-05 Thread jacmoe
Isn't it open source? Not the first time someone made a fork of it - including the original author. :) On Jan 4, 10:31 pm, Juan Luis Baptiste wrote: > On Mon, Jan 4, 2010 at 10:05 AM, hashmich wrote: > > Oracle is going to take over Sun Microsystems - who are the owner of > >

Re: MySQL takeover by Oracle - petition

2010-01-04 Thread Juan Luis Baptiste
On Mon, Jan 4, 2010 at 10:05 AM, hashmich wrote: > Oracle is going to take over Sun Microsystems - who are the owner of > the copyrights for MySQL. > I think you can imagine, what's the meaning of MySQL being taken over > by its direct commercial competitor. > I think you ar

MySQL takeover by Oracle - petition

2010-01-04 Thread hashmich
Hi to all, even if this is not cake-relevant, I think this may be of interest for all of you, who build applications based on a opensource database - and want to do so in future: Oracle is going to take over Sun Microsystems - who are the owner of the copyrights for MySQL. I think you can

Re: CakePHP and Oracle (status of compatibility)

2009-11-20 Thread kemikTc
I have previously written a class to manupulate oracle using php's oci (in projects without cake). So are you saying you wrote your own class, and are somehow using it in Cake? Or did you manipulate the existing dbo_oracle.php? -- You received this message because you are subscribed t

Re: CakePHP and Oracle (status of compatibility)

2009-11-19 Thread majna
I was unable to call Oracle function/procedure and bind IN and OUT variables. So I turned to PHP's oci extension. record join is supported well. On Nov 17, 7:36 pm, kemikTc wrote: > After using CakePHP and MySQL for a few project.  I have a new project > where I am forced to use Or

CakePHP and Oracle (status of compatibility)

2009-11-17 Thread kemikTc
After using CakePHP and MySQL for a few project. I have a new project where I am forced to use Oracle. I am looking for feedback from anyone who has tried CakePHP and Oracle in the past. My main concerns would be - ability to use bind variable - record id insertion using sequences - reserved

Re: Oracle 10g

2009-09-29 Thread Bert Van den Brande
Maybe this example will help : http://liamgraham.wordpress.com/2007/04/19/using-oracle-with-cakephp-15-minute-blog-tutorial/ Google is such a nice tool :) On Mon, Sep 28, 2009 at 5:21 PM, osamo101 wrote: > > Hi > > I have a problem connecting to Oracle 10g database. > >

Oracle 10g

2009-09-28 Thread osamo101
Hi I have a problem connecting to Oracle 10g database. When I put 'driver' => 'oracle', I got an error in the homepage so I changed it to ODBC but also I am not able to connect. My configuration is as follows: var $default = array(

[SOLVED] CakePHP and Oracle 11g issues

2009-09-08 Thread Rafael Felix Correa
Hi everyone, I'm writing this post only as a resource for those that are trying to make CakePHP applications run over Oracle 11g. I noticed that dbo_oracle.php doesn't concatenate the host and port parameters to the third parameter on the ocilogon function (php.net/ ocilogon). The ph

Re: Oracle & autoincrement : PROBLEM

2009-09-05 Thread logislack
Hi Xanax Try this http://bakery.cakephp.org/articles/view/increment-behavior Saluos! On Sep 4, 8:30 am, Xanax wrote: > Hi, > > I have a BIG problem. > > There is no autoincrement option in Oracle like in MySQL. > > Apparently, with CakePHP and Oracle, people use sequen

Oracle & autoincrement : PROBLEM

2009-09-04 Thread Xanax
Hi, I have a BIG problem. There is no autoincrement option in Oracle like in MySQL. Apparently, with CakePHP and Oracle, people use sequences and triggers to bypass this. My problem : I can't use triggers on my database, it's forbidden by my company. And of course i don't want

Re: Weird SQL requests with CakePHP on an Oracle DataBase ?!!

2009-08-27 Thread Xanax
I found the reason : it's the alis GROUP. This is a keyword reserved by ORACLE database engine. How can i change the alias ? Perahps in the model of the table ? Another solution is to change the tablename so it will change the alias associated but i would have to change a lot of SQL re

Re: Weird SQL requests with CakePHP on an Oracle DataBase ?!!

2009-08-27 Thread brian
I'm not familiar with Oracle syntax. Does it normally leave out the "AS" when using an alias? If so, it looks ok to me. The table is groups and the alias is Group. On Thu, Aug 27, 2009 at 9:48 AM, Xanax wrote: > > Hi everyone, > > I've transfered all my data

Weird SQL requests with CakePHP on an Oracle DataBase ?!!

2009-08-27 Thread Xanax
Hi everyone, I've transfered all my data from MySQL to an Oracle Database. It used to work very well with MySQL. Now, when i try to launch my application, i've got weird request. I respected all tablename conventions from the CakePHP sites so i've set plural tablenames. For e

Re: Connecting to ORACLE Database !

2009-08-24 Thread DavidH
> > I've been developing my cakephp application with MySQL sor far and now > i must migrate the database to an oracle one. > > I've created an oracle database and import the tables, everything > wrked fine. > Here an extract of the tsnames.ora entry con

Connecting to ORACLE Database !

2009-08-24 Thread Xanax
Hello, I've been developing my cakephp application with MySQL sor far and now i must migrate the database to an oracle one. I've created an oracle database and import the tables, everything wrked fine. Here an extract of the tsnames.ora entry concerning this databse : O

Re: oracle "find()"

2009-07-28 Thread rchavik
ot;OCD" > $this->set('machines', $this->Machine->find('all')); > -- > View this message in > context:http://www.nabble.com/oracle-%22find%28%29%22-tp24711573p24711573.html > Sent from the CakePHP mailing list archive at Nabble.com. --~--~-~--~---

oracle "find()"

2009-07-28 Thread pete123456
se of the missing user "OCD" $this->set('machines', $this->Machine->find('all')); -- View this message in context: http://www.nabble.com/oracle-%22find%28%29%22-tp24711573p24711573.html Sent from the CakePHP mailing list archive at Nabble.com. --~--~-

Re: getting data from another oracle database

2009-05-20 Thread Dr. Loboto
e. Search this group for complete solutions. On May 21, 12:32 am, humbao wrote: > reuvers, > > Here is how I did it and it was for Oracle and this type of > functionality is ,imho, an edge case, so I had to hack up the dbo_oracle > file. > > I have an application DB and dozen

Re: getting data from another oracle database

2009-05-20 Thread humbao
reuvers, Here is how I did it and it was for Oracle and this type of functionality is ,imho, an edge case, so I had to hack up the dbo_oracle file. I have an application DB and dozens of target DBs(other physical servers). I have a table in the application DB that holds connection info to all

Re: getting data from another oracle database

2009-05-20 Thread Dr. Loboto
With cake ORM you can refer different databases by DB configs but not by table names as cake always properly escape it for sure. Why don't you like $useDbConfig way? On May 20, 6:25 pm, reuvers wrote: > How would one go about gathering information from an other oracle > da

getting data from another oracle database

2009-05-20 Thread reuvers
How would one go about gathering information from an other oracle database? My application contains all the relevant information required except for a few tables i need to read from from another oracle database The user i'm using has read rights on that database. I know it's possible

Oracle Stored Procedures

2009-04-27 Thread starkey
Hello all! Does Cake support Oracle stored procedures? I found Ticket #3163 (2 years old) in trac but did not see anything in dbo_oracle... Is calling Oracle stored procedures that return a result set supported? Thanks! Shawn Trac: https://trac.cakephp.org/ticket/3163 Oracle stored

Re: Oracle group by bug

2009-02-27 Thread mscdex
On Feb 27, 4:09 pm, Germano wrote: > Hi, i try use a group by sql with a find('all') method in a oracle > database configuration but didnt worked. I use the same $condition > array with mysql with success. You need to post relevant information including any and all errors y

Oracle group by bug

2009-02-27 Thread Germano
Hi, i try use a group by sql with a find('all') method in a oracle database configuration but didnt worked. I use the same $condition array with mysql with success. Does anyone knows anything about this? --~--~-~--~~~---~--~~ You received this message b

Re: can't connect to oracle

2008-12-16 Thread deden
There's no problem in my connection.. i have two directory in my htdocs for two version cakephp (rc1 & rc 3). there're cakerc1 and cakerc3 in cakerc1, i've developed CRUD for oracle XE, and I've not found problem yet. But, with cakephp rc3, I've got error connecti

Re: can't connect to oracle

2008-12-15 Thread Rob
quot;, "hr", "//127.0.0.1/XE"); On Dec 11, 6:54 pm, "baranangsi...@gmail.com" wrote: > at first page : > > = >  Your database configuration file is present. > Cake is NOT able to connect to the database. > ==== > > i've ever developed ap

  1   2   >