On Wed, Nov 09, 2005 at 04:50:56PM +1100, Frank Carnovale wrote: > > > >>> Jim Mintha <[EMAIL PROTECTED]> 05/11/05 1:39 PM >>> > > >Having worked backwards to the beerdb example, I'm now trying to get > >it to work with my real database which is using Oracle. This is not > >working and it seems to be a problem that the C:D:Oracle module > >doesn't do enough to keep formbuilder happy. Anyone else running > >formbuilder with Oracle? Or even just standard Maypole with Oracle > >(which does work, but took a bit of hacking) > > Jim, yeah to get Maypole/Oracle working we had to extend Class::DBI::Oracle > and Class::DBI::AsForm with a whole bunch of locally dreamed up "features" > which wouldn't sit very well on CPAN. In Class::DBI::Oracle you have to read > USER_TAB_COLUMNS to get column type info. To do it properly, it requires > someone to extend the CPAN Class::DBI::Oracle by implementing the > column-type-discovery functionality that can be seen in the source of > Class::DBI::MySql. I'm sure that FormBuilder would then meet your > expectations. If only I had another life I would push some of this > development myself..
I noticed that :) I was able to get it all working with formbuilder, I had to change a few different things (returned columns where uppercase, but FB wanted lowercase) and I haven't yet sorted out which things were specific to my situation. The biggest problem I had was speed. It seems that FB calls its own _load_meta (which calls column_info a lot) about 20 times for each database. I did a test with a single table with no relationships, and it still called it 20 times. I implemented a crude caching mechanism that helped, but it still was sluggish. Any FormBuilder experts are to comment? Since I had to get things working, I've moved the database to mysql for now. But I would still like to get the oracle stuff all working. Jim -- Jim Mintha Email: [EMAIL PROTECTED] System Administrator Work: +31 20 525-4919 Informatiseringscentrum Home: +31 20 662-3892 University of Amsterdam Debian GNU/Linux: [EMAIL PROTECTED] _There are always Possibilities_ http://www.mintha.com ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Maypole-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/maypole-users
