Elxis CMS Forum
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: IOS Reservations online hotel booking system for Elxis CMS.
 
Pages: [1]
« previous next »
  Print  
Author Topic: Connecting with Oracle 9 db issues  (Read 7900 times)
phpworker
Newbie
*
Offline Offline

Posts: 2


WWW
« on: November 23, 2007, 21:13:01 »
 Did enybody succeed in connecting Elxis with Oracle db? Can you provide any example of config tested with remote oracle db?

Greetings!
Logged
datahell
Elxis Team
Hero Member
*****
Offline Offline

Posts: 7601



WWW
« Reply #1 on: November 23, 2007, 23:57:48 »
We have tested Oracle with Elxis in the past. At this time Oracle is not functional with elxis and we have nt proceed in making it full usable with elxis as there are no user requests for this database. 99.5% of the users use mysql. Only a 0.5% use Postgres (full compatible with Elxis). In the other hand we have requests for FireBird. FireBird/InterBase is the most possible database that we will add next in Elxis (maybe in version 2008.1). The biggest problems with Oracle or FireBird is that they dont like the naming of some db columns. For example Oracle likes everything to be uppercase. This requires database modification meaning totally break of the compatibility with previous elxis versions. We may do something special for these databases in order not to break compatibility. FireBird also has some problems with complex queries, but this is something we can solve. Oracle is a powerful database and we do not have problem with complex queries. An other database we also like to make it comopatible with Elxis is microsoft SQL.
« Last Edit: November 23, 2007, 23:59:44 by datahell » Logged
Elxis Team | Is Open Source | IOS Reservations | IOS Eshop
phpworker
Newbie
*
Offline Offline

Posts: 2


WWW
« Reply #2 on: November 24, 2007, 07:32:01 »
If you decide to develop Elxis to Oracle I am ready to help in testing... I thought it is already done... Undecided

Oracle db is now freeware (Oracle 10 Express Edition) so I think it'll become more popular. I need CMS like Joomla to be wotrking with Oracle. Maybe some alternative solution is there for me?
« Last Edit: November 24, 2007, 07:36:10 by phpworker » Logged
jamessimpler
Newbie
*
Offline Offline

Posts: 5
« Reply #3 on: March 11, 2008, 06:31:18 »
Me too. We have several request for CMS with Oracle. Would be great if Elxis to be able to support Oracle.
Logged
datahell
Elxis Team
Hero Member
*****
Offline Offline

Posts: 7601



WWW
« Reply #4 on: March 11, 2008, 07:50:57 »
The good news are that the ADOdb database library that Elxis uses updated recently (30/1/2008) and the new version supports better Oracle! We will add this version to Elxis CMS and make it compatible with Elxis in version 2008.1 or 2008.2.
Logged
Elxis Team | Is Open Source | IOS Reservations | IOS Eshop
jamessimpler
Newbie
*
Offline Offline

Posts: 5
« Reply #5 on: March 13, 2008, 17:06:54 »
Wow. That's really good news! Can't wait for the next release!!!!
By the way, when is the next plan release?
« Last Edit: March 15, 2008, 13:54:00 by jamessimpler » Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Elxis CMS © 2006-2013 Elxis CMS Forum
Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC 		MySQL  PHP  XHTML  CSS