⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Grocerycrud with oracle?



samsun
  • profile picture
  • Member

Posted 11 February 2013 - 01:43 AM

Dear All,

 

I try use grocerycrud with Oracle, but i have difficult. Connection is no problem, but when display the data is blank.

 

Would you like to inform me ho use Grocerycrud and Oracle?

 

Regards,

Samsun


davidoster
  • profile picture
  • Member

Posted 11 February 2013 - 17:38 PM

I suspect that this might be your problem.

/topic/1127-error-in-flexigrid-search-when-using-relations-between-2-tables-that-contain-same-field-name/


Bertrand Kintanar
  • profile picture
  • Member

Posted 11 February 2013 - 22:45 PM

I believe your problem is a known issue. I suggest not to use unsupported databases. Please see below for more information.

 

source: http://www.grocerycrud.com/documentation/known-issues

 

Below you will find some common issues and bugs that of course we try to fix them ASAP. Its good to check this list if you have any problem with the library.
  • ...
  • Only works with MYSQL and MYSQLi database

 


davidoster
  • profile picture
  • Member

Posted 12 February 2013 - 00:04 AM

Thanks Bertrand for bringing this up!!!

I knew some of the issues but I had never noticed, till now, that only MySQL & MySQLi dbs are valid for working with GC library!

 

I always thought that all the dbs that are supported from CodeIgniter are also supported by GC!!!

Thanks for this info!!!

 

 

I believe your problem is a known issue. I suggest not to use unsupported databases. Please see below for more information.

 

source: http://www.grocerycrud.com/documentation/known-issues


davidoster
  • profile picture
  • Member

Posted 12 February 2013 - 00:27 AM

Well Bertrand, I was having a good look on the grocery_crud model and I was trying to find a point where other dbs (other than MySQL/MySQLi) shouldn't work.

Nearly all of the functions are using CI's $this->db->somefunction except 

  1. 1. https://github.com/scoumbourdis/grocery-crud/blob/master/application/models/grocery_crud_model.php#L130 and maybe here
  2.  
  3. 2. https://github.com/scoumbourdis/grocery-crud/blob/master/application/models/grocery_crud_model.php#L432 but this still goes via $this->db->query
  4.  

Hence if all of the functions go via the Database class of CodeIgniter and CodeIgniter supports these:

http://ellislab.com/codeigniter/user-guide/general/requirements.html

 

then

(I ask also [member=web-johnny]) why only MySQL/MySQLi are supported with GroceryCrud library?

 

[UPDATE: I have just posted a question about this here

 

Thanks Bertrand for bringing this up!!!

I knew some of the issues but I had never noticed, till now, that only MySQL & MySQLi dbs are valid for working with GC library!

 

I always thought that all the dbs that are supported from CodeIgniter are also supported by GC!!!

Thanks for this info!!!


Bertrand Kintanar
  • profile picture
  • Member

Posted 13 February 2013 - 20:32 PM

No problem! Glad to be of help!