I just finished upgrading a bunch of modules. I upgraded from DBI 1.13 to
1.18, DBD::Sybase 0.21 to 0.91, Net::Daemon 0.29 to 0.35, and Storable 0.6.7
to 1.0.11. I also had to upgrade File::Spec since my File::Spec didn't have
the tmpdir method which DBI::ProxyServer.pm now uses. (I'm still using Perl
5.005_03.)
Everything works the same as it did prior to these upgrades except for one
thing: When connecting to my Sybase server via DBD::Proxy and my dbiproxy
server, the table_info method (with no arguments) doesn't work. (It works
fine if I don't go through dbiproxy though.) Normal prepare/execute/fetchall
code sequences work fine through dbiproxy. Only table_info seemingly has
problems. (Yes, I restarted the dbiproxy server after finishing all of the
aforementioned upgrades.)
Here's the dbiproxy log entries with debug turned on:
Wed Jun 20 15:48:40 2001 debug, Connection from 128.xxx.xxx.xxx, port 3301
Wed Jun 20 15:48:40 2001 debug, Child clone: DBI::ProxyServer=HASH(0x1403971f0)
Wed Jun 20 15:48:40 2001 debug, New child starting
(DBI::ProxyServer=HASH(0x1403971f0)).
Wed Jun 20 15:48:40 2001 debug, Accepting client from 128.xxx.xxx.xxx, port 3301
Wed Jun 20 15:48:40 2001 debug, Client logs in: Application dbi:Sybase:SYBASE, version
0.2003, user xxxxx
Wed Jun 20 15:48:40 2001 debug, Connecting to dbi:Sybase:SYBASE as xxxxx
Wed Jun 20 15:48:40 2001 debug, Accepting client
Wed Jun 20 15:48:40 2001 debug, Client executes method CallMethod
Wed Jun 20 15:48:40 2001 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x1403a26c8),STORE,AutoCommit,1
Wed Jun 20 15:48:40 2001 debug, CallMethod: <= 1
Wed Jun 20 15:48:40 2001 debug, Client executes method CallMethod
Wed Jun 20 15:48:40 2001 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x1403a26c8),table_info
Wed Jun 20 15:48:40 2001 err, Can't call method "execute" without a package or object
reference at /usr/contrib/lib/perl5/site_perl/5.005/alpha-dec_osf/DBD/Sybase.pm line
151.
Looking at the DBI Changes file, under the Proxy section for the DBI 1.15
release, there is the following change listed: "Added fix for problem using
table_info thanks to Tom Lowery." There are a few other changes to Proxy
there as well, as well as one listed under DBI 1.16: "Fixed client sql
restrictions in ProxyServer.pm thanks to Jochen Wiedmann."
I don't see anything relevant looking at DBD::Sybase's CHANGES file. The
changes to Net::Daemon look pretty trivial to me and unrelated. Storable is a
black hole to me.
Any idea what the problem might be? Is there anyone using the DBD::Proxy and
dbiproxy from DBI 1.18 that has a working table_info method?
Thanks,
Ed
