[Dbix-class] ANNOUNCE: Test::DBIC

2007-11-12 Thread Nathan Gray
I wanted to use something like DBICTest or DBIC::Test for testing my models. I did not find them packaged anywhere, just in the t/ directories of other distributions. In case anyone else is interested, I have tried to sensibly merge the two and have packaged the result for CPAN. If there are

Re: [Dbix-class] lost connection during query

2007-11-12 Thread J . G . Konrad
for starters i was failing to set mysql_auto_reconnect=0. this value defaults to 1 when using mod_perl. By setting this to zero it has solved the issue of the failing statement not being retried using Apache, mod_perl, Catalyst and DBix. So now the failing statement is retried, successfully,

Re: [Dbix-class] lost connection during query

2007-11-12 Thread Matt S Trout
On Fri, Nov 09, 2007 at 03:19:27PM -0800, J.G.Konrad wrote: Using DBIx::Class 0.08007 and a simple script that will connect to a database, wait for greater than the timeout and execute a statement on a expired connection, everything works as described below. A new connection is made and the

Re: [Dbix-class] Pager bug - last page has more results then entries_on_this_page

2007-11-12 Thread Matt S Trout
On Sun, Nov 11, 2007 at 12:46:05AM +0300, [EMAIL PROTECTED] wrote: There is a bug of SQL::Abstract::Limit. In my case DB it is SQL Server. But I thibk it's common bug for all DBD. As I suggest SQL::Abstract::Limit don't consider Data::Page params generating SQL for DB. Simplest query it's

Re: [Dbix-class] Test::DBIC needs to be core, not a copy+paste from core

2007-11-12 Thread Matt S Trout
On Mon, Nov 12, 2007 at 01:52:39PM -0500, Nathan Gray wrote: On Mon, Nov 12, 2007 at 06:28:14PM +, Matt S Trout wrote: On Mon, Nov 12, 2007 at 09:37:03AM -0500, Nathan Gray wrote: I wanted to use something like DBICTest or DBIC::Test for testing my models. I did not find them

Re: [Dbix-class] lost connection during query

2007-11-12 Thread J . G . Konrad
I ended up rebuilding DBD::mysql with the same major version that the mysql server is running. The mysql server is 5.0.22 and I was using DBD::mysql built on 4.1.17 when things were not working. After I rebuilt DBD::mysql with 5.0.45 , everything apears to be working. On Nov 12, 2007 10:07 AM,