Ticket #416 (closed wishlist: fixed)

Opened 2 years ago

Last modified 5 months ago

OCI8 Support

Reported by: pablo Assigned to: afz
Priority: normal Milestone: 0.8.0
Component: Database / Other DB Bugs Version: SVN
Severity: normal Keywords:
Cc:

Description (Last modified by afz)

OCI8 support.

SQLite seems to work fine, needs more testing tho, this mostly means, try Jaws on those databases and see what we have to change in our MDB2 interaction and even help fix up MDB2 to support them better.

Attachments

Change History

06/03/06 05:17:12 changed by Here

  • type set to defect.

06/07/06 17:49:09 changed by anonymous

  • severity changed from normal to blocker.

my vote for sqlite support .. jaws: tnx for this great tool

06/07/06 20:16:32 changed by dufuz

  • type changed from defect to enhancement.
  • severity changed from blocker to normal.

It's not a blocker, it's really a feature.

06/09/06 02:43:43 changed by kad

  • summary changed from SQLite and OCI8 Support to OCI8 Support.

SQLite is already being chased in another ticket (#319), let's keep this one for OCI8 only.

09/22/06 01:37:36 changed by pablo

  • summary changed from OCI8 Support to Wishlist: OCI8 Support.

11/10/06 21:30:23 changed by dufuz

  • summary changed from Wishlist: OCI8 Support to OCI8 Support.
  • type changed from enhancement to wishlist.
  • milestone changed from 0.7.0 to Wishlist.

01/26/07 18:30:35 changed by kad

  • owner changed from jawsbugs@jaws.com.mx to dufuz.

Ok, I tried to install with OCI8, but no luck yet... it keeps telling me there are incorrect user/password, I tried tracking it thru the MDB2/Drivers/oci8.php file and the dsn data is empty, any clues?

PS: I'm assigning this to Helgi...

08/30/07 04:22:47 changed by afz

  • owner changed from dufuz to afz.
  • status changed from new to assigned.
  • milestone changed from Wishlist to 0.8.0.

09/16/07 02:22:31 changed by afz

  • milestone changed from 0.8.0 to 0.9.0.

we can't support oci8 in 0.8.x, because:
1. MDB2 OCI8 has bug in connect via array dsn, anot compatible with other driver.
2. MDB2_Schema + MDB@ oci8 driver + create database
so i change Milestone to 0.9.0

02/09/08 03:05:13 changed by afz

  • description changed.
  • milestone changed from 0.9.0 to 0.8.0.

I'm now a MDB2 developer, and all bugs reported above fixed.
all field's name used in queries must be in a double qoutation,
for fixing this issue and also fixing uses reserved words for field's name MDB2
"quoteIdentifier" method in all RDBMs driver so if we change our query to thing like this: 

select [id], [title] from [[foo]]

and replace [field] with quoteIdentifier(field) this problems will be fixed.
I'm now working for fix this problem.

02/09/08 03:37:33 changed by ion

We need to discuss it, maybe (in fact I think) is not worth to do the [field] stuff since is needed in a few cases (the quotation).

02/09/08 07:11:59 changed by afz

- oracle: queries column name must put in the double quotation,
- mssql: queries column name is better put in the bracket and if the name is reserved it should put in the bracket.
- mysql/i: identifier quoting for mysql is nack quote "`", if name is reserved use this char is necessary
pgsql: identifier quoting for pgsql is double quotation, if name is reserved use this char is necessary
,....
in fact without this changes our MDB2 wrapper is weak.

02/18/08 14:54:32 changed by afz

  • status changed from assigned to closed.
  • resolution set to fixed.

we now support Oracle.

Add/Change #416 (OCI8 Support)




Change Properties
Action