Re: [Phpwiki-talk] Using oracle as backend

[Matthew P. <mp...@he...>]

On Tue, Jun 22, 2004 at 02:44:58PM +0200, giancarlo.bazzi wrote:
> Hi, I'm trying to use an oracle backend on a Macosx 10.2 database 
> machine from a linux suse 7.3 wiki 'server' machine,

[...]

> On accessing wiki from a browser the following 2 rows are displayed.
> 
> lib/WikiDB/backend/PearDB.php:718: Fatal[256]: virtual
> lib/WikiDB/backend/PearDB.php:718: Fatal[256]: virtual
> 
> It seems to be related to an attempt to lock a table.
> 
> Any help will be appreciated.

PHPWiki's database access stuff is a little weird.  Having your database
backend supported by PEAR or ADODB isn't enough -- there's a couple of extra
methods that need to be written.  Primarily, those are the locking methods
you alude to, and are provided (in default form) by virtual methods which
bomb when called (as you've seen).

You need to create a file in lib/WikiDB/backend called <dbtype>.php (where
dbtype, for you, would be oci8).  It should contain a class named
WikiDB_backend_<dbtype>, extended from WikiDB_backend_PearDB.  My
recommendation would be to copy pgsql.php and modify it as required (I don't
think there'd be much you'd need to fix).  That'll get your database firing
on all cylinders.

If you want to contribute your Oracle port back to the PHPWiki project,
you should send your oci8.php and oci8.sql files either here, to Reini, or
(perhaps) stick it in the patch manager.

- Matt