login | register
Mon 06 of Oct, 2008 (14:27 UTC)

bitweaver - Web Application Framework and CMS

Web Application Framework and CMS

Refresh cache

Oracle Reservations for Two

spiderr • Sun 19 of Feb, 2006 (17:35 UTC)
No thumbnail for
Image


We went to talk to the Oracle, and here is what she said:
  1. Your installer needs fixing
  2. Database objects can only be 30 characters
  3. Quoting every column is a pain in the @#$!

We obeyed her comands, and the voila! HEAD now installs cleanly on oracle. See the sandbox for living proof.

Oracle defaults to the SQL standard of UPPER CASING everything that is not specifically double quoted. This caused a catch-22 in the installer by not being able to choose the oci8 or oci8po ADODB drivers for complete functionality. So we made some tweaks in the ADODB DataDict classes to enable Oracle installation, however we still had to have every query and object be case sensitive. Being a lazy guy, I can understand how typing quotes in sqlplus/toad/tora is enough to drive anyone mad. In order to remove the quotes, we have to change all the sql reserved words to enable quoteless queries. /lester and I have been digging through the schema_inc's and renaming all column and objects and we have made really good progress, as can be seen by the SchemaChangelog.

Currently, a fresh build or checkout from cvs HEAD should work great.
0 reads  •  1 Comment

Comments

Reply to this comment

Firebird gain

by Lester Caine, Sunday 26 of February, 2006 (21:31:55 UTC)
The same changes have allowed Firebird to also install with quoting of tables and filed names switched off!

Related Items

Documentation » Technical Documentation

Documentation geared towards developers and people who want to learn about the core processes of bitweaver

HEAD ON! Support has been added for Pear::DB!  •  Oracle Reservations for Two  •  ReleaseTwo: Shedding that last bits of our roots, finding the core of our being  •  getContentList  •  How to add a pagination to an object list  •  Moving bw in another directory  •  pma and mysql  •  safe mode on / open_base_dir  •  sequence and auto  •  The package I am currently developping is suddenly desactivated  •  APIDocumentation  •  Archived Picture Upload with Fisheye under Windows  •  Bitweaver and Browser Cookies  •  bitweaverCVS  •  bitweaverFeatures  •  bitweaverPerformance  •  CodingGuidelines  •  CreatingServices  •  CssSchema  •  InstallbitweaverDoc  •  IntegrationTutorial  •  LibertyFormats  •  LibertyMime  •  LibertyServices  •  phpdoc content status  •  PortingTikiWikiPackages  •  PrototypeAjaxObject  •  PrototypeReference  •  SamplePackage  •  SearchPackageDevNotes  •  TUTORIAL - Displaying Icons ONLY to AUTHORS of the page  •  Tutorial - Liberty Plugins  •  Tutorial - Liberty Plugins II  •  UsersDoc