Welcome Guest, Not a member yet? Register   Sign In
is Oracle good enough with Codeigniter ?
#11

[eluser]kgill[/eluser]
[quote author="tau-lepton" date="1215318576"]
I was able to work around the problem by making a small edit to the CI oracle driver; I'm not really happy with this solution, I'm probably missing some functionality in CI to clear the previous query. I'll post the edit that I made if someone wants it, I'm not posting it now because it probably does more harm than good.
[/quote]

Search the forums for oracle and you'll probably find your edit has already been posted and it does more good than harm. I also wouldn't worry too much about missing out the caching functionality. From what I remember the DB cache system serializes the result set and writes it out to the file system, then uses that for each subsequent query until you clear it manually. For the most part you're going to want to pull the latest info in your selects so you don't miss much - at least oracle will automatically cache the execution plan so you do get some speed boost.

As for the original poster's question about CI and Oracle, I'd say it's fine for production - we've used it on one of our production sites (10.2) for over a year now without problems.

- K
#12

[eluser]411161[/eluser]
This post says that Oracle/CI/AR is production ready but another post showed where I needed to edit the DB_driver.php file. I am using 1.6.3.

And this is what I get:

A PHP Error was encountered

Severity: Warning

Message: ociparse() expects parameter 1 to be resource, boolean given

Filename: oci8/oci8_driver.php

Line Number: 160

A PHP Error was encountered

Severity: Warning

Message: ocisetprefetch() expects parameter 1 to be resource, null given

Filename: oci8/oci8_driver.php

Line Number: 145

A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 159
#13

[eluser]Pesse[/eluser]
I have exactly the same problem. Couldn't find any solution in the forum.
What can I do?

Greetings,
Pesse
#14

[eluser]dpgtfc[/eluser]
I've had similar problems with oracle and posted them on this forum with no response. Not sure if enough people are using oracle to have a good base for troubleshooting problems. Until I get a response I just connect and run queries from my models in the old fashion way. Too bad though, about the lack of support for oracle here.
#15

[eluser]Pesse[/eluser]
Ok, I discovered that I had a connection problem. I deleted the @ from the ocilogon-functions in oci8_driver.php and - hey - I got error messages Smile
Have some problems with fetchinto at the moment, I'll report here when I were able to solve them.

Pesse
#16

[eluser]Unknown[/eluser]
I got the same problem too. This morning I got these errors when I ran my application for the first time (actually it ran well yesterday).
Anyone has the solution?? :-S

Quote:A PHP Error was encountered

Severity: Warning

Message: ociparse() expects parameter 1 to be resource, boolean given

Filename: oci8/oci8_driver.php

Line Number: 166
Quote:A PHP Error was encountered

Severity: Warning

Message: ocisetprefetch() expects parameter 1 to be resource, null given

Filename: oci8/oci8_driver.php

Line Number: 151
Quote:A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 155
Quote:A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 155
Quote:A PHP Error was encountered

Severity: Warning

Message: ociparse() expects parameter 1 to be resource, boolean given

Filename: oci8/oci8_driver.php

Line Number: 166
Quote:A PHP Error was encountered

Severity: Warning

Message: ocisetprefetch() expects parameter 1 to be resource, null given

Filename: oci8/oci8_driver.php

Line Number: 151
Quote:A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 155
Quote:A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 155
#17

[eluser]Unknown[/eluser]
I had the same problem. Restart the web server!

[quote author="411161" date="1221269704"]This post says that Oracle/CI/AR is production ready but another post showed where I needed to edit the DB_driver.php file. I am using 1.6.3.

And this is what I get:

A PHP Error was encountered

Severity: Warning

Message: ociparse() expects parameter 1 to be resource, boolean given

Filename: oci8/oci8_driver.php

Line Number: 160

A PHP Error was encountered

Severity: Warning

Message: ocisetprefetch() expects parameter 1 to be resource, null given

Filename: oci8/oci8_driver.php

Line Number: 145

A PHP Error was encountered

Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 159[/quote]
#18

[eluser]grover[/eluser]
The problem is the version "OCI 8 driver". Here the solution

http://isyskernel.blogspot.com/2013/11/s...linux.html





Theme © iAndrew 2016 - Forum software by © MyBB