Cakephp,Auth with Oracle connectivity

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',
'login' => 'xxxx',
'password' => 'xxxx',
'database' => 'x.x.x.x:1521/JVD',
'prefix' => '',
'connect' => 'oci_connect'
);

Cakephp shows that it is "Cake is able to connect to the database."
able to connect with database.

Now while i am trying to login in my form via auth component, it shows
below mentioned error.

Query:

SELECT User.id, User.username, User.password, User.email,
User.first_name, User.last_name, User.created, User.modified FROM
users User WHERE User.username = 'tapan' AND User.password =
'f5f7714b74b0f0f851830145b10b2a041959e281'

Error:
ORA-00923: FROM keyword not found where expected

Can you please suggest what should i do to remove this issue?

Regards
Tapan Thapa

--
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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php