CodeIgniter Forums

Full Version: Oracle Capitalization Problem and the Session Library
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Frank Liu[/eluser]
Hi All,

I have ton of problems using CI with Oracle (10g) this weekend. All of these seem to somehow go back to the capitalization issue with the oracle driver. I put in the following fixes and they seem to go away:

in oci8_driver.php line 550 (function _escape_identifiers), add the following line:

> $item = strtoupper($item);

Then add the several fixes in the following thread by inari:

http://ellislab.com/forums/viewthread/74570/#389090

How come everything's so complicated with Oracle (I come from Django and it is exactly the same there).

Btw, CI is really clean, definitely the best framework I've seen for php (although I think php itself needs a lot of work. I am a python guy. But CI definitely is making things easierSmile)

El Forum

[eluser]Unknown[/eluser]
Try this table:
CREATE TABLE "ci_sessions"
(
"session_id" VARCHAR2(40 BYTE) DEFAULT 0 NOT NULL,
"ip_address" VARCHAR2(16 BYTE) DEFAULT 0 NOT NULL,
"user_agent" VARCHAR2(50 BYTE) NOT NULL,
"last_activity" NUMBER ,
"user_data" VARCHAR2(3000 BYTE)
);

CREATE UNIQUE INDEX PK_SESSION_ID ON "ci_sessions" ("session_id");
ALTER TABLE "ci_sessions" ADD (CONSTRAINT PK_SESSION_ID PRIMARY KEY ("session_id"));

El Forum

[eluser]Unknown[/eluser]
[quote author="jenci" date="1253110427"]Try this table:
CREATE TABLE "ci_sessions"
(
"session_id" VARCHAR2(40 BYTE) DEFAULT 0 NOT NULL,
"ip_address" VARCHAR2(16 BYTE) DEFAULT 0 NOT NULL,
"user_agent" VARCHAR2(50 BYTE) NOT NULL,
"last_activity" NUMBER ,
"user_data" VARCHAR2(3000 BYTE)
);

CREATE UNIQUE INDEX PK_SESSION_ID ON "ci_sessions" ("session_id");
ALTER TABLE "ci_sessions" ADD (CONSTRAINT PK_SESSION_ID PRIMARY KEY ("session_id"));[/quote]

Thank you!now i can proceed to finish my project...appreciate that.