[warning: see updates below]
Between Class::DBI 0.94 and 0.95, something changed causing my classes that override db_Main() to set the db connection (instead of, e.g. using set_db) to stop working. Specifically, when their sequence functions were invoked, I got an error of:
Can't locate object method “select_val” via package “DBI::st” (perhaps you forgot to load “DBI::st”?) at /usr/lib/perl5/site_perl/5.6.1/Class/DBI.pm line …
I was able to replicate this on Mac OS X 10.2 with Perl 5.6.0 and Red Hat 9 with 5.6.1 (don't ask about the latter version magic…).
If you get select_val errors with Class::DBI 0.95, here are two workarounds:
- downgrade to 0.94, found here: http://search.cpan.org/CPAN/authors/id/T/TM/TMTM/Class-DBI-0.94.tar.gz
- make sure you use set_db instead of db_Main to set the db connection
I am not sure why this is (comments are welcome) and have submitted a bug to the developers as CPAN #5522.
Update: Thanks to Tony Bowden, maintainer of Class::DBI, for his reply:
Full context and any attached attachments can be found at:
<URL: http://rt.cpan.org/NoAuth/Bug.html?id=5522 >On Mon, Mar 01, 2004 at 06:42:38PM -0500, Guest via RT wrote:
> In Class::DBI 0.95, setting up the DB connection by overriding db_Main
> breaks Ima::DBI->select_val and the methods that rely on it (like sequence
> and count_all)You need to call Ima::DBI->connect rather than DBI->connect in your
overriden db_Main.Tony
Still not certain, though, why it is that it breaks in 0.95 and not 0.94.
Update: Thanks again to Tony, who writes:
The reason this broke in going from 0.94 to 0.95, btw, is that the
select_val stuff was only added to Ima::DBI recently, so Class::DBI .94
didn't use these, but instead rolled its own long winded versions.0.95 uses the new methods in Ima::DBI and is a lot better off for it! 🙂
Tony
Update 23 April 2004: Things are all wacky now. You should be careful and should probably NOT do any of the above. See the 06 April 2004 exchanges on the CDBI mailing list. If you do what is described above you stand to get reconnections that will mess up things like auto_increments in MySQL. At present the issue of how to deal with db_Main() seems unresolved.