at first page :
=
Your database configuration file is present.
Cake is NOT able to connect to the database.
i've ever developed application with cake rc2 and oracle. Select,
insert, update, delete is work normally. Now, I want to try cake rc3.
But, at first page,
What error are you seeing ?
On Dec 11, 4:23 am, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> i try oracle driver in cake rc3..., but don't success. here is
> database.php :
>
> var $default = array(
> 'driver' =>
i try oracle driver in cake rc3..., but don't success. here is
database.php :
var $default = array(
'driver' => 'oracle',
'persistent' => false,
'host' => 'localhost',
I had similar problem with database connection.
Ty to use
this https://trac.cakephp.org/ticket/5583 bugfix
and
change your configuration to:
var $default = array(
'driver' => 'oracle',
'connect' => 'oci_connec
Hi dudes,
I'm running into problems when trying to establish a hasMany relation
between two models using an orcale DB.
My models:
---
class MenuStructure extends AppModel
{
var $primaryKey = 'file_name';
var $useTable = 'menu_structure';
var $hasMany =
ried below, using oci8 instead of oci_connect and many other
changes. Not sure what to do next.
var $default = array(
'driver' => 'oracle',
'connect' => 'oci_connect',
'persistent' =>
another version? I know that cake supports oracle,
> but are there other people that use oracle and cake?
> >
>
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this gr
I am using cake_1.2.0.7296-rc2
Should I be using another version? I know that cake supports oracle,
but are there other people that use oracle and cake?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP&q
/
dbo_source.php on line 345
I saw this:
https://trac.cakephp.org/ticket/5038
But I am not sure how best to proceed. Should I be using cake 1.1? is
there a stable version present where this would work?
It seems as if many people were using Cake and oracle, but is that not
true
with the latest official release it is fixed... was a temporary bug
somehow...
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubsc
Today I updated my cake from version 1.2.0.5875 to 1.2.0.6311.
I am using it with an Oracle DB.
Now I am getting a strange behaviour with update and delete
operations...
An update now looks like:
UPDATE SAMPLETABLE Sampletable LEFT JOIN SOMEJOINTABLE Somejointable
ON (Sampletable.fkid
Ah you submitted a ticket. I guess I forgot to mention that I spoke to
Chris Jones from Oracle and he said that functionality is not
available at the C level, so it's not a PHP issue.
On Fri, May 23, 2008 at 4:07 PM, Bensoft <[EMAIL PROTECTED]> wrote:
>
>> Yeah, this topic ha
> Yeah, this topic has to be revisited at some point.
http://pecl.php.net/bugs/bug.php?id=13970
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegro
Dave,
Yeah, this topic has to be revisited at some point. I have also been
busy developing an application using CakePHP & Oracle. I now wish I
had never been strong-armed to use Oracle, but that besides the point.
;-) Nate had some ideas about trying to fix this issue, but at this
point I
On May 23, 7:02 am, "Jeff Loiselle" <[EMAIL PROTECTED]> wrote:
> Welcome to being me.
Hi Jeff,
Great job by the way (considering) and thank you for dbo_oracle.php
I was shocked to find there was no way to get Oracle to return the
full table.column specifier in OCI_ASSOC. I
This issue has been solved in the branches version of dbo_oracle.php
On Thu, May 15, 2008 at 7:29 AM, Nameroc <[EMAIL PROTECTED]> wrote:
>
> I'm trying to use the command "cake acl initdb" to set up ACL tables
> in an oracle system, but my queries are returning er
nyone else having trouble with Oracle and the AppModel query()
> method.
>
> Basically, PHP's OCI interface is very limited when it comes to
> MetaData. There is no staight forward way to get table names of
> columns in a result set. As a work-around the dbo_oracle.php driver
>
Spent some time getting this work so I thought I'd document it for
anyone else having trouble with Oracle and the AppModel query()
method.
Basically, PHP's OCI interface is very limited when it comes to
MetaData. There is no staight forward way to get table names of
columns in a
does it say about being able to
> connect to your database?
>
> On May 20, 3:15 pm, Valerio <[EMAIL PROTECTED]> wrote:
>
> > Hi, I'm a new cakephp developer... I'm trying to connect to an Oracle
> > db but it doesn't work. I use a native oracle driver and
Do you mean it says "your database configuration file is NOT
present"? If it's present, then what does it say about being able to
connect to your database?
On May 20, 3:15 pm, Valerio <[EMAIL PROTECTED]> wrote:
> Hi, I'm a new cakephp developer... I'm trying t
Hi, I'm a new cakephp developer... I'm trying to connect to an Oracle
db but it doesn't work. I use a native oracle driver and my connection
parameters into the database.php file are:
var $default = array('driver' => 'oracle',
There's an open ticket about this, the guy you want to talk to is
phishy (Jeff Loiselle) http://jeff.loiselles.com/wordpress/ :
https://trac.cakephp.org/ticket/2024
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"C
I'm trying to use the command "cake acl initdb" to set up ACL tables
in an oracle system, but my queries are returning errors because
apparently acos and alias are keywords in oracle. Is there any way I
can use acl short of renaming every bad field to something accep
Hi,
I'm trying to get CakePHP to communicate with oracle but I'm having a
bit of trouble. When I configure my database.php file it gives me a
"Fatal error: Call to undefined function ocilogon() in C:\wamp\www\cake
\libs\model\datasources\dbo\dbo_oracle.php on line 165"
> Fatal error: Call to undefined function oci_connect() in XAMPPLite
> \htdocs\cake\cake\libs\model\datasources\dbo\dbo_oracle.php on line
> 144
>
> What am I doing wrong here ?
This means that you don't have the Oracle client libraries installed.
http://www.oracle.com
First, I download version 1.2.0.6311 beta from the CakePHP website.
I tried to connect to Oracle and it does not work. Here is my
database.php content :
var $default = array(
'driver' => 'oracle',
'persistent' => false,
I'm fairly new to the Oracle world, but I've been using oracle with
Cake pretty good until now. The oracle administrator has something
set up called "view", which in my understanding is a query against the
system table that acts as its own table. While you can log in via
is so incredible simple, it should just work. But for some
reason Cake is constructing SQL statements that Oracle just doesn't
like.
Does anyone have any ideas as to what I need to do to fix this? I've
had a ton of success with Cake and MySQL and unfortunately I'm being
force
o incredible simple, it should just work. But for some reason
Cake is constructing SQL statements that Oracle just doesn't like.
Does anyone have any ideas as to what I need to do to fix this? I've had
a ton of success with Cake and MySQL and unfortunately I'm being forced
into Orac
;
> I am using CakePHP 1.2 beta and am able to establish a connection to
> an Oracle 10g database on the cake homepage. This database however
> does not follow Cake's table naming conventions. All table names are
> singular, upper case and primary keys do not have "id&q
Hello,
I am using CakePHP 1.2 beta and am able to establish a connection to
an Oracle 10g database on the cake homepage. This database however
does not follow Cake's table naming conventions. All table names are
singular, upper case and primary keys do not have "id" in them.
with his
> > 'belgonsTo' models.
> > Generating a query like:UPDATEposts Post LEFT JOIN blogs Blog on
> > (Post.blog_id = Blog.id) SET ... WHERE Post.id IN(id);
>
> > Oracle is complaining that there is no SET keyword ?
> > Warning (2): ociexecute() [fu
the pre-beta) today!
>
> Is there a change in the Save method, or just in the dbo source, when
> I try toupdatea model now, the query uses a join with his
> 'belgonsTo' models.
> Generating a query like:UPDATEposts Post LEFT JOIN blogs Blog on
> (Post.blog_id = Blog.
og.id) SET ... WHERE Post.id IN(id);
Oracle is complaining that there is no SET keyword ?
Warning (2): ociexecute() [function.ociexecute]: ORA-00971: missing
SET keyword [CORE/cake/libs/model/datasources/dbo/dbo_oracle.php, line
290]
so is this an error on my or cakephp's with oracle behalve
sanderken, just publish a behaciour which will help you with Clob
Behaviour.
here is the url for the article:
http://nik.chankov.net/2008/01/03/cakephp-and-oracle-handling-clob-fields/
Hopefully it will help you
Regards ;)
On 9 Дек 2007, 17:09, sanderken <[EMAIL PROTECTED]> wrote:
>
I got an assigment in school to create a blogsystem. The requirements
were: use a MVC framework and an Oracle backend.
So I found cakephp, a god's gift or a nightmare? Developping with the
1.1 (stable) didnt work: associations, the power of cakephp didn't
work.
Then there was 1.2 wic
I think I have it working using the dbo_oracle from the new version of
Cake. I scrapped trying to use pear.
On Dec 3, 1:16 pm, Greg Baker <[EMAIL PROTECTED]> wrote:
> I seem to be having a little trouble getting cake to connect to Oracle
> using Pear. The config file says to
I seem to be having a little trouble getting cake to connect to Oracle
using Pear. The config file says to use 'driver' => 'pear-
drivername' (which I assume would be pear-oci8), but this does not
work. So I tried using 'driver' => 'pear' which got
s his lack of time there are some
technical difficulties as well.
Your best bet is to use table/model names that do not conflict with
Oracle reserved words.
Regards,
Martin
--
Martin Schapendonk, [EMAIL PROTECTED]
--~--~-~--~~~---~--~~
You received this
Found a ticket submitted here:
http://groups.google.com/group/tickets-cakephp/msg/25b70f403ce47e23
This is for the reserved words table names.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To p
I wanted to add something else to this.
If you have a table Users and you try to select against it, CakePHP
uses the table alias of User, however this is a reserved word in
Oracle.
Any ideas how to get around this?
--~--~-~--~~~---~--~~
You received this
I am working on getting CakePHP 1.2 to work nicely with our Oracle
db. After getting it all configured, the index.php page was throwing:
Undefined index: connect [CORE/cake/libs/model/datasources/dbo/
dbo_oracle.php, line 141]
and
Fatal error: Function name must be a string in /usr/ns-home
2007/10/15, Kristopher <[EMAIL PROTECTED]>:
> I have been struggling to get CakePHP to communicate with an Oracle 9i
> database. I have installed the 10g Instant Client and have created a
> batch file to run my Apache 2.2 server. In this batch file I have set
> the foll
the database configuration file..
or there is a better way.. I said I didn't had much time, so please
don't flame me :)
Btw my class configuration file:
class DATABASE_CONFIG {
var $default = array(
'driver' => 'oracle',
'
I was wondering if it might be smart to actually define the variables
in some PHP file using:
PutEnv("ORACLE_SID= ... ");
PutEnv("ORACLE_HOME= ... ");
PutEnv("TNS_ADMIN= ... ");
...
The problem is being a newbie to CakePHP, I'm not sure is this is a
good idea (to actually try to solve my
in that directory (as per some web comments...)
Basically I have to have my 9i environment working and would simply
like to have PHP 5.2.4 be able to
connect via OCI to my Oracle 9i database.
--~--~-~--~~~---~--~~
You received this message because you are subscribe
Some other background information:
Using the following PHP code:
';
}
?>
I get:
PATH not set
NLS_LANG not set
NLS_NCHAR not set
ORACLE_HOME not set
Which is somewhat strange since I have set the NLS_LANG in my startup
bat
Hi All,
I have been struggling to get CakePHP to communicate with an Oracle 9i
database. I have installed the 10g Instant Client and have created a
batch file to run my Apache 2.2 server. In this batch file I have set
the following environnment variables:
set ORACLE_BASE="D:\oracle
Hmm .. Ithink i am able to connect the db using odbc already.
I found a bug in db_odbc.php line 178, it should have query without
Limit 1 .. because "Limit 1 " is not recognized by oracle db.
But i still have the problem because it always display the warning and
displaying all my tab
Hi
I am asking again :(
I am going to connect to my oracle database using odbc and here is my
configuration:
var $default = array('driver' => 'odbc',
Hi,
Does any one know any thing about how I can use prepare and execute in
"cake_1.2.0.5427alpha" for oracle, and does it at all support using
prepare and execute functionality?
Regards,
Maryam
--~--~-~--~~~---~--~~
You received this message becau
Same here - no answer yet.
Although i have overwritten the connection $config variables with a
string in dbo_oracle.php
Still searching...
On Jul 24, 5:09 am, starkey <[EMAIL PROTECTED]> wrote:
> I've traced the code, trying to figure out the cause of this issue.
> If anyone can help clarify thi
On Jul 30, 2007, at 11:58 AM, starkey wrote:
>
> Just a note for future generations... ACL in cake_1.1 uses table
> column names starting with an underscore. Oracle does not allow
> columns starting with '_' so you will need to modify the classes.
> When I'm do
Just a note for future generations... ACL in cake_1.1 uses table
column names starting with an underscore. Oracle does not allow
columns starting with '_' so you will need to modify the classes.
When I'm done testing I'll append them to this post (or somewhere more
app
On 7/23/07, starkey <[EMAIL PROTECTED]> wrote:
>
> I've traced the code, trying to figure out the cause of this issue.
I suggest you file a ticket over at http://trac.cakephp.org as that is
the fastest way to get a bug fixed.
--
Chris Hartjes
Senior Developer
Cake Development Corporation
My mo
fect sense to me,
given that DboOracle is the child, however the parameters do not match
so I'd expect the call to stay in DboSource.
Is anyone else experiencing this?
Thanks!
On Jul 20, 4:51 pm, starkey <[EMAIL PROTECTED]> wrote:
> Hello! I am a developer at the University of Ric
Hello! I am a developer at the University of Richmond; we are an
Oracle shop. I am testing Cake for some projects we have planned and
am using the Oracle driver (the version in 1.2alpha). To learn Cake's
functionality I'm walking through the 15 minute Blog tutorial from the
man
Answering my own question here, but this problem is due to a bug in
cake\libs\model\datasources\dbo\dbo_oracle.php for
cake_1.2.0.5146alpha
The problem lies in the value function
I had to change
default:
$data2 = str_replace("'", "''", $data);
return "'".$data2."'";
break;
to
defa
Hi,
Just ported my app to work on IIS, Oracle and cake_1.2.0.5146alpha.
After some teething problems everything is pretty much working except
one small problem.
In my controller I have the following
function index()
{
$data = $this->Sitepage->read();
$this->set('data'
Oracle Developers:
The newest revision of the Oracle driver has just been committed to:
https://svn.cakephp.org/repo/branches/1.2.x.x/
Please test it and submit your bug reports to Trac. We would like to
have this driver absolutely solid for the 1.2 release
I don't have any experience with ADODb, so I can't help with that part. :(
On 8/29/06, fperini <[EMAIL PROTECTED]> wrote:
>
> I am with this problem has some suggestion?
>
> Fatal error: Call to a member function MetaType() on a non-object in
> c:\program files\apache
> group\Apache\htdocs\cake\c
I am with this problem has some suggestion?
Fatal error: Call to a member function MetaType() on a non-object in
c:\program files\apache
group\Apache\htdocs\cake\cake\libs\model\dbo\dbo_ADODB.php on line 296
I have ADOdb installed in /vendors.
My archive of configuration of database is this:
ADOdb has support for Oracle, so you'll have to configure Cake's
database stuff to use ADOdb.
http://phplens.com/adodb/supported.databases.html
On 8/29/06, fperini <[EMAIL PROTECTED]> wrote:
>
> I am working to one week with the CakePHP. I am not obtaining to
> c
I am working to one week with the CakePHP. I am not obtaining to
connect with oracle 9i and cakephp. If it will have some example.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To po
MySQL is just about the only database that implements this anyway, so
we've made do with workarounds in the other drivers. We should have an
Oracle driver implemented in the near future.
--~--~-~--~~~---~--~~
You received this message because you are subsc
Clayton Smith wrote:
> I have been looking into the possibility of using CakePHP with an
> Oracle database.
>
> Some important issues that have been already pointed out are in this
> thread by Dave Rogers:
> http://groups.google.com/group/cake-php/browse_thread/thre
I have been looking into the possibility of using CakePHP with an
Oracle database.
Some important issues that have been already pointed out are in this
thread by Dave Rogers:
http://groups.google.com/group/cake-php/browse_thread/thread/f338fe4aa0c9d98/ba4bfb2be5ff16e1?lnk=gst&q=oracle&am
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 ema
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
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
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 abo
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.
--~--~-~--~~~---~-
I have been working on writing a CakePHP native Oracle db driver. I'm
used to working with MySQL, so I used that as a baseline for the Oracle
driver. This is the first time I've had to use Oracle.
Where should I submit the code for others to look at it so we can work
out the bug
These are the errors I am recieving:
Warning: Invalid argument supplied for foreach() in
C:\HTTP\cake.localhost\cake\libs\controller\controller.php on line 655
Notice: Object of class Account to string conversion in
C:\HTTP
I've been looking into Cake for a new project at work. It works ok
with MySQL, but I'm having trouble getting Oracle to work. Below is
the db connection information:
var $default = array('driver' => 'adodb',
'connect' => 'oci8'
Hi guys,
I'm having a problem getting cake to wotk with oracle.
I've managed the Blog Tutorial with MySQL, no problem. An Oracle
connection woth PHP+Adodb without cake is no problem. But I really want
to get cake to work with oracle.
So far I changed the database.php to
va
101 - 176 of 176 matches
Mail list logo