Session Database Driver and Oracle |
Hello everyone.
I'm confused, why Codeigniter 3 does not support Oracle in Session Database Driver. In the official user guide we can read that "Only MySQL and PostgreSQL databases are officially supported, due to lack of advisory locking mechanisms on other platforms." However in Oracle we can find SYS.DBMS_LOCK package, which provides necessary procedures to get and release locks. I have modified Session_database_driver.php file to support Oracle database. Anyone feel free to use it (and, maybe, to search for bugs?). The session table should be created like this: Code: CREATE TABLE CI_SESSION ( and you need to grant 'execute' privilege on sys.dbms_lock package to desired db user. Session_database_driver.php (Size: 14.42 KB / Downloads: 345)
I just tried it and so far it's working well.
Thanks you !
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/ |
Welcome Guest, Not a member yet? Register Sign In |