Persistent session PHP<->Oracle

[DeepOne]

Hi,

 

is there any way of creating a kind of persistent user session to Oracle?

I mean, pconnect/plogon has obviously nothing to do with real sessions: when my script finishes, all not commited changes are lost immediately (while that persistent connection using my username/password still stays open) - why?! Can one switch this auto-rollback off? I guess not.

Unlike most other databases, Oracle is best-suited for making lots of changes/executing lots of statements and commiting them all at the end - and if I understand it right, it's impossible with PHP. And I just don't understand why: If it's possible to reuse an existing connection, why is there still no way to create a real dedicated persistent connection that could be reused by every call of a script using the same username/password? (I'd like to e.g. issue an INSERT in the first call and COMMIT in the second...)

 

I tried to google for it, but everyone seems to be interested in commiting every single statement as soon as possible - like I said, it's just fine for most other DBs (MySQL, Postgre), but not for Oracle - so I didn't find anything useful.

 

Sorry for my poor english.

 

 

[gluck]

I don't understand you issue but if you have auto commit on you would not need to commit any transactions.

Normally that is the case and at time the Database abstraction layer takes care of that.

[Feenix566]

Run oci_commit() at the end of your PHP script.

 

Keeping a persistent connection alive from within a web server is not an ideal solution, given the request/response nature of HTTP.