DB Abstraction

[zariok]

How close is this to happening as a road map completion for version 1.0?

I saw you were using adodb which, in theory, should allow Mantis to be ported to use all the databases listed http://phplens.com/adodb/supported.databases.html.

The only hangup I would see is that the SQL is mangled in with the code and thus could prevent abstraction due to slight variations of SQL implementations and/or binding. There are some ADOdb port tips located at http://phplens.com/lens/adodb/tips_portable_sql.htm including "SQL as a Localization Exercise".

My main issue is having to run MySQL just for Mantis as all my other databases are either PostgreSQL or Oracle9i. I wouldn't mind working on the PostgreSQL, SQLite and Oracle 9i (for work) SQL compliance.

It looks like this was attempted before as db_generate.sql for 0.9.12 is actually "mysql.sql" and mssql.sql / pgsql.sql haven't been touched since Mar 4 2004.

Finally, I evaluated several open BT systems and chose Mantis for our system of tracking bugs. We are using this for a major internal telecommunications J2EE project with developers both in the US and India. It is very important to get this working with one of the corporate Oracle servers. Thanks for all the hard work thus far and am waiting for the opportunity to help add this additional functionality.

John 'zariok' Draughn

[zariok]

For the sake completeness:

#4504 -Using ADODB XML Schema for DB Creation (Assigned)
#4871 - New SQL script for PostgreSQL port (Resolved)
#5243 - PostgreSQL script upgrade (New)
#5289 - Use ADODB DataDict for DB Creation / Upgrade (New)

[vboctor]

John, we would really appreciate your work in this area. So far, Paulr (grangeway) has been working on this. His approach at the moment is to implement an installation/upgrade script + data dictionary for the creation / upgrade of the database.

Paulr, uses MySQL / MS SQL. So it would be great if you can help him with the implementation work and to testing on SQLLite, Pgsql and Oracle.

You can get in touch with Paulr via IRC on #mantishelp (see website for details), or by adding comments to issue #5289 which I think he just created.

Regards,
Victor
http://www.futureware.biz

[zariok]

I left a note on the bug stating my interest in getting this working with various database backends.

[strathmeyer]

I'd also like to help testing and porting the db backend. I'm mainly interested in doing it for Oracle. Have any updates on your progress with this issue?

[zariok]

I'm working with paulr to confirm his new installer (for version 1.0, i think) will work with oracle.

Currently testing against 9.2.0.5

[strathmeyer]

Can you post to this thread when you have a working version in CVS? Or will we have to wait for the 1.0 release?

[WFX]

Hi all,

Also interested in running Mantis over an Oracle DB.
Any news for more than 1 month ?

Thx

WFX

[br8kwall]

Ping.

What's the status of mantis on oracle? We're willing to help if the effort has stalled.

[vboctor]

br8kwall, now that Mantis 1.0.1 is out and it has the installer implemented. It would be great if you can adapt this to work on Oracle. We can then include the required changes into Mantis 1.1.

Any other help in this area would be appreciated.

Regards,
Victor
MantisConnect
http://www.futureware.biz/mantisconnect/

[br8kwall]

Haven't been through the forums in a while... Since I first asked for this we've grown comfortable with MySQL backing mantis and I haven't been asked to continue looking into Oracle support. But, if the need arises again we might be able to put some resources into making it work.

Unless I've missed something and someone has done it already

[-LT-]

Does Mantis support Oracle now?
I'm using v1.0.6, and it has an install option for Oracle (oci8), but it does not seem to work. I'm using Oracle 9i, but 8 would be possible.

I set $g_db_type = 'oci8' (in config_inc.php) as suggested in config_defaults_inc.php, but that gives me an error message when trying to login to Mantis: 'Configuration option 'db_type' has invalid value 'oci8''

I also tried the hints here: http://www.mantisbt.org/bugs/view.php?id=6895 , but that entry is older than one year and refers to v1.0.1.

So is there support for Oracle in v1.0.6?
Thanks in advance,
LT

[runner80]

Any news about Mantis & Oracle? I'm interested in migrating from mySQL.

Regards,
Patrick

[roman]

Hi,

According to http://en.wikipedia.org/wiki/Mantis_Bug_Tracker, MantisBT supports SQLite. Does it? It's important to me.

Thanks in advance

[atrol]

ATM MantisBT does not support sqlite.
There is a feature request for this http://www.mantisbt.org/bugs/view.php?id=10573
The Wiki information just says that ADOdb library supports sqlite, of course confusing.