On 5/11/06, LU, ZHENYUAN [AG/1000] <[EMAIL PROTECTED]> wrote:
Yeah, the list_tables() works now.
Good! :)
But I still can't use the Loader.
Although Oracle support is starting to creep into Rose::DB, there is zero Oracle support in Rose::DB::Object right now. If anything works with Oracle in Rose::DB::Object, it's probably luck :)
Could not auto-generate columns for class Swbmm::ANIMAL - no column info found for catalog '' schema '' table 'ANIMAL' at /webapps/t_snp_d/local/perl/lib/site_perl/5.8.0/Rose/DB/Object/Loader.pm line 744 Where should I look at to find the trouble spot? Is this concerning ConventionManager? My schema convention is different from that in the perldoc.
If you'd like to help add Oracle support to Rose::DB::Object, I can tell you where to start. Look at the Rose::DB::Object::Metadata::Auto::* modules. There's one for each database type that overrides the methods from Rose::DB::Object::Metadata::Auto that need to be changed in a database-specific way. Adding Oracle support means creating an ::Auto::Oracle module and hooking it up properly so that it gets used at the right time. Then you'd need to add methods to it and/or modifying methods in the base class Auto module so that they work with Oracle--but continue to work with all the other databases that use them, of course. Obviously, overriding is safer and easier. I'm not sure how "non-standard" Oracle is. Maybe ::Auto::Oracle will be easy and maybe it'll be a mess. You can look at the existing ::Auto::Informix module for a worst case, and ::Auto::Pg for a best case. Finally, Rose::DB's Oracle support needs to be finished as well in order for everything to work. And we also have to think about how best to support sequence-based primary keys in Oracle. I'll probably have to be involved in that part, since the internals are not well-defined there. -John ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
