Michael, I use my Oracle Proxy class daily without any trouble. I would be happy to take a look at a complete example of you modules to see if I can spot anything amiss. Of course, if it is a large proprietary system, I would suggest reducing it to simpler set of classes that demonstrate the problem. Half the time when I do that I discover the problem myself :)
- philip Michael Lackhoff wrote: > Hello, > > Shame on me, I had forgotten to add a mapping of the driver to the > Oracle::Proxy class, now it is working. > > After I got the connection I first tried to use the loader to create all > the classes for me but that didn't work. I don't know if the reason is > the proxy or RDBO because I couldn't test yet with a direct connection. > Is this a known issue with Oracle? (Then I wouldn't do further tests) > > So I created one class from a simple table (just four fields, two of > them build the primary key). > Here the next problem struck. I wanted to get a record from the two > primary key columns: > > my $m = DOD2::Customer_mapping->new( > client_identifier => '[EMAIL PROTECTED]', > requester_id => 'ZBMED', > )->load; > > Error message: No such DOD2::Customer_mapping where client_identifier, > requester_id = [EMAIL PROTECTED], ZBMED at test02.pl line 10 > > The record is there. The same query with the manager method > get_customer_mapping worked perfectly. > > I switched on debugging, got the SQL statement and did a search with > plain DBI using this statement and it worked, too. > > I hope it is not again a stupid mistake like before but it looks like > something is still going wrong here. > > Any ideas? > > -Michael > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object