Can't create model Oracle with developer tools

Question

Can't create model Oracle with developer tools

ahmed-samir-data Apr '16

Created Apr '16	Last Reply May '16	Replies 7	Views 629	Votes 0

ahmed-samir-data 931

Apr '16

Hi,

I have oracle database mydb with 2 schemas test1 and test2. I connected to test1 but when I used the command line to create model of table customers on schema test1 phalcon model customers it says ERROR: Could not find driver. When I used https://127.0.0.1/webtools.php it lists all tables in the two schemas test1 and test 2 in field table name. And when I choose table customers to create model it says table customers not exists.

Note: When I created manually table customers model and fetched it's data the model returns data correctly. So I want to ask is there a problem between oracle and phalcon developer tools

'database' => array(
    'adapter' => 'oracle',
    "dbname" => "//192.168.1.20:1521/mydb",
    "username" => "test1",
    "password" => "xxxxxxx",
    'charset' => 'AL32UTF8',
    'schema'  => 'TEST1'
),

I am using phalcon version 2 Thanks

jeiel
81.1k

Accepted
answer

edited Apr '16
Apr '16

Because you must specify the schema for Oracle.

phalcon model tablename --force --schema=schemaname

Oracle takes 10 to 20 minutes. I do not know why but it works. You just have to let it work

jeiel · Answer 1 · 2016-04-23T13:51:04-07:00

This is the configuration that uses my project

'database' => array(
    'adapter'     => 'Oracle', 
    'username'    => 'SPOLS',
    'password'    => 'SPOLS',        
    'dbname'      => 'localhost/xe',
    'schema'      => 'SPOLS'
    ),

jeiel · Answer 2 · 2016-04-23T13:54:56-07:00

In ubuntu you must not load PDO_OCI and Phalcon directly in php.ini, load 2 files in

/etc/php5/cli/conf.d/30-phalcon.ini
/etc/php5/cli/conf.d/40-pdo_cli.ini

And in each file respectively phalcon.so and add extension = extension = pdo_oci.so

Also for web, in php.ini should not be references to these extensions

ahmed-samir-data · Answer 3 · 2016-04-25T06:11:28-07:00

ahmed-samir-data
931

edited Apr '16
Apr '16

Thanks for your prompt reply. But is there any tips for windows installation

jeiel · Answer 4 · 2016-04-25T06:59:48-07:00

jeiel
81.1k

Apr '16

If you have activated PDO_OCI in PHPinfo

ahmed-samir-data · Answer 5 · 2016-04-25T08:16:42-07:00

yes it is enabled

PDO Driver for OCI 8 and later | enabled
ODBC Connection Pooling | Enabled, strict matching

And when I created the model manually without dev tools. I created search action and it retreives data correctly.

ahmed-samir-data · Answer 6 · 2016-04-25T10:07:21-07:00

Hi, I tried to enable extension=php_pdo_oci.dll and extension=php_pdo_odbc.dll in both ~\apache2.4.9\bin\php.iniand ~\php5.5.12\php.ini. It was enabled in the php.ini of apache folder only. But now I enabled it in the both files.

The result is that the command phalcon model customers doesn't says ERROR: Could not find driver but it take along time without response and if I entered wrong table name e.g. phalcon model customerssssssssssssssssssss it says Error: Table "customerssssssssssssssssssss" does not exist which means it can connect to the database. But it takes along time without doing any thing and I click ctrl+c to break the script.

The interface of https://127.0.0.1/webtools.php still saying table doesn't exists for anything.

Thanks in advance

ahmed-samir-data · Answer 7 · 2016-04-29T08:12:12-07:00

Thanks for your reply

I tried the command phalcon model tablename --force --schema=schemaname and it works but between 1.5 and 2 hours :)). Which is a very big time to run.

I tried also to convert oracle schema structure to mysql and set the comnnection to the mysql connection and run the commands I want. Then convert the database connection to use oracle. After using dev-tools.

jeiel · Answer 8 · 2016-04-29T13:54:21-07:00

Well, I prefer to wait 2 hours compared to codify all code from the ground and try q takes work more

ahmed-samir-data · Answer 9 · 2016-04-29T15:12:33-07:00

The big question now is why using dev-tools with oracle taking all this time. And is there any near fix for that issue.

Jonathan Aaron Steel · Answer 10 · 2016-04-30T17:21:49-07:00

Have you checked what is the bottleneck? Phalcon stand-alone tools CLI app, or the database (RDBMS) itself? I would guess that if you have large database with many tables, it will take time to build all the fileds, tables, relations from RDBMS -> Phalcon ORM.

ahmed-samir-data · Answer 11 · 2016-05-03T17:11:09-07:00

Thanks for your reply stamster. I think you are right the reason is because of number of tables. There is an issue e..g if we have database with 2 schemas s1(5 tables),s2(20 tables)+ system(x tables)and I run the command phalcon model tablename --force --schema=schemaname using schema s1. I found using session browser of toad that this query runs on all tables in the database not the tables of s1 only.

SELECT AC.TABLE_NAME, CC.COLUMN_NAME, AC.CONSTRAINT_NAME, AC.R_OWNER, RCC.TABLE_NAME R_TABLE_NAME, RCC.COLUMN_NAME R_COLUMN_NAME

FROM ALL_CONSTRAINTS AC

JOIN ALL_CONS_COLUMNS CC ON AC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME JOIN ALL_CONS_COLUMNS RCC ON AC.R_OWNER = RCC.OWNER AND AC.R_CONSTRAINT_NAME = RCC.CONSTRAINT_NAME

WHERE AC.CONSTRAINT_TYPE = 'R' AND AC.OWNER = 'S1' AND AC.TABLE_NAME = 'WWV_FLOW_INSTALL_SCRIPTS' -- table name changing ...

So it waste alot of time in other schemas tables. and in the webtools.php if I gonna to create a model. It shows a list of all tables in the database not the tables of connected schema only.

jeiel · Answer 12 · 2016-05-06T10:18:38-07:00

Yes, I have already discussed this little feature to the developer but as the system allows different database were making the correct settings. Currently, I use to solve the problem only commands in the terminal, hopefully for the next update is resolved