perl DBD driver has not implemented the AutoCommit attribute

jasonyy77

Thread 10 terminated abnormally: DBD driver has not implemented the AutoCommit attribute at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 672.

1. my $dbh = DBI->connect("DBI:mysql:$db_name:$db_ip:$db_port",$db_user,$db_passwd)

复制代码

1. my $dbh = DBI->connect("DBI:mysql:$db_name:$db_ip:$db_port",$db_user,$db_passwd, {AutoCommit => 0})

复制代码

都不行.

请求高人指点.



补充下:
我这个脚本是用来测试mysql-proxy的.
起100线程跑.每个线程循环跑不同的sql语句.

Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at test_mysql_proxy.pl line 203.

我的脚本又报了这么个错误.
导致我的一些线程会退出.

而且有点随机性.我的语句里面也没有rollback()操作.
没有事物.

就是简单的 select  delete insert.

请知道的朋友解答下.谢谢

yybmsrs

             $dsn = "DBI:mysqldatabase";
             $dsn = "DBI:mysql:database=$database;host=$hostname";
             $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

jasonyy77

1. my $dbh = DBI->connect("DBI:mysql:database=$db_name;host=$db_ip;port=$db_port",$db_user,$db_passwd)

复制代码

还是报同样的错.

jasonyy77

http://search.cpan.org/~timb/DBI-1.607/DBI.pm#AutoCommit_(boolean)
我在这里找到了
改成old-style就不包标题上的错误.

1. my $dbh = DBI->connect("dbi:mysql:$db_name\@$db_ip:$db_port",$db_user,$db_passwd, {AutoCommit => 0})

复制代码

但是又报DBI connect('DBname@192.168.11.79:3307','user',...) failed: Can't connect to MySQL server on '3307' (22) at test_mysql_proxy.pl

这个错误我再看看.



另外想请教下各位高手.
$data_source  的几种写法有什么区别.?  查网上其他的资料好像是兼容性的问题.

1.   dbi:DriverName:database_name
   
2.   dbi:DriverName:database_name@hostname:port
   
3.   dbi:DriverName:database=database_name;host=hostname;port=port
   
4. 
   

复制代码