Dear Jorge, Thanks a lot for you help. I really appreciate it.
The command and the information you have mentioned below is very useful. I'll try it definitely. Meanwhile, I tried creating a class manually for a table and model using the command ( omitting create=static) and this has *worked* for me. Now I could connect to Oracle database. It appears that the reason was the In-proper SID or SID=servicename values. Thanks Jorge ! Rohan. On Fri, Mar 11, 2011 at 4:57 PM, Jorge Gonzalez <[email protected]>wrote: > Sure. From here: > > > http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader-0.07000/lib/DBIx/Class/Schema/Loader/Base.pm#constraint > > > constraint<http://search.cpan.org/%7Erkitover/DBIx-Class-Schema-Loader-0.07000/lib/DBIx/Class/Schema/Loader/Base.pm#___top> > > Only load tables matching regex. Best specified as a qr// regex > DBIx::Class::SAchema::Loader is the class Catalyst uses to create the > schema, and you can send parameters to it from the Catalyst helper script. > > So your helper script invocation would something similar to this: > > perl script/testapp_create.pl model DB DBIC::Schema > DB::Schema create=static 'constraint=qr/^YOUR_TABLE$/' 'dbi:Oracle:* > SERVICE_NAME=test.abcd.com*;host=192.168.100.107; port=1521' 'user' 'pass' > > (quotes around the "constraint" parameter to prevent shell escaping and > such). > > There are a few other parameters whic I've found pretty useful, like > "qualify_objects" (prepending the schema name to all table names in the > class files). I recomend to check them all just in case you are interested. > > Regards > J. > > > *Jorge González Villalonga* > Director Técnico > > *DAIKON Integración y Desarrollo S.L.* > Telf: (+34) 91 188 08 28 > Fax: (+34) 91 632 65 42 > *www.daikon.es* > > El 11/03/11 11:34, Rohan M escribió: > > Dear All, > > I believe the oracle server version is 8.1.7 and I don't have access to > that server. > > I guess the reason was, I was putting SID=test.abcd.com which was wrong. > > I think Catalyst model provides "SID INSTANCE_NAME SERVER SERVICE_NAME " > as options that can be mentioned as parameters. These are all name=value > pairs that *Can* (?) be put for model creation. > > Today , I tried with > > perl script/testapp_create.pl model DB DBIC::Schema > DB::Schema create=static > 'dbi:Oracle:*SERVICE_NAME=test.abcd.com*;host=192.168.100.107; > port=1521' 'user' 'pass' > > And I think this connects (?) but since the database has many many tables > so the script kind of stays still. > > Can we just create one table dynamically in order to test everything > works fine? I mean, provide single table name to the above command and test. > > Thanks for the help.. > > Regards, > ROhan > > On Fri, Mar 11, 2011 at 1:29 PM, Jorge Gonzalez > <[email protected]>wrote: > >> Have you tried to troubleshoot the connection at the "other" side, i.e. >> the Oracle server? What does the listener log say about the failed >> connection, and about the successful ones from the same machine (your >> Catalyst host)? How do they differ? >> >> j. >> > > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > > -- रोहन मल्लेल्रवार
<<image/png>>
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
