X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FODBC%2FMicrosoft_SQL_Server.pm;h=210a65095ff86f41d6e8203241f76fee90be2389;hb=8384a713d9046e08314e06bf17c2a878cd215819;hp=5279502cef6779993cabfcffda4175cc954417e1;hpb=9ae966b90f1220796b4fef69a97e7c4fb360d6bc;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm b/lib/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm index 5279502..210a650 100644 --- a/lib/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm +++ b/lib/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm @@ -5,7 +5,6 @@ use warnings; use base qw/DBIx::Class::Storage::DBI::MSSQL/; use mro 'c3'; -use Carp::Clan qw/^DBIx::Class/; use List::Util(); use Scalar::Util (); @@ -38,7 +37,7 @@ Use as: on_connect_call => 'use_dynamic_cursors' -in your L as one way to enable multiple +in your L as one way to enable multiple concurrent statements. Will add C<< odbc_cursortype => 2 >> to your DBI connection attributes. See @@ -62,7 +61,7 @@ sub connect_call_use_dynamic_cursors { my $self = shift; if (ref($self->_dbi_connect_info->[0]) eq 'CODE') { - croak 'cannot set DBI attributes on a CODE ref connect_info'; + $self->throw_exception ('Cannot set DBI attributes on a CODE ref connect_info'); } my $dbi_attrs = $self->_dbi_connect_info->[-1]; @@ -75,16 +74,15 @@ sub connect_call_use_dynamic_cursors { if (not exists $dbi_attrs->{odbc_cursortype}) { # turn on support for multiple concurrent statements, unless overridden $dbi_attrs->{odbc_cursortype} = 2; - my $connected = defined $self->_dbh; - $self->disconnect; - $self->ensure_connected if $connected; + $self->disconnect; # resetting dbi attrs, so have to reconnect + $self->ensure_connected; $self->_set_dynamic_cursors; } } sub _set_dynamic_cursors { my $self = shift; - my $dbh = $self->_dbh; + my $dbh = $self->_get_dbh; eval { local $dbh->{RaiseError} = 1; @@ -92,7 +90,7 @@ sub _set_dynamic_cursors { $dbh->do('SELECT @@IDENTITY'); }; if ($@) { - croak <<'EOF'; + $self->throw_exception (<<'EOF'); Your drivers do not seem to support dynamic cursors (odbc_cursortype => 2), if you're using FreeTDS, make sure to set tds_version to 8.0 or greater. @@ -103,12 +101,18 @@ EOF $self->_identity_method('@@identity'); } -sub _rebless { - no warnings 'uninitialized'; +sub _init { my $self = shift; - if (ref($self->_dbi_connect_info->[0]) ne 'CODE' && - eval { $self->_dbi_connect_info->[-1]{odbc_cursortype} } == 2) { + no warnings qw/uninitialized/; + + if ( + ref($self->_dbi_connect_info->[0]) ne 'CODE' + && + ref ($self->_dbi_connect_info->[-1]) eq 'HASH' + && + $self->_dbi_connect_info->[-1]{odbc_cursortype} == 2 + ) { $self->_set_dynamic_cursors; return; } @@ -160,7 +164,7 @@ sub connect_call_use_MARS { my $dsn = $self->_dbi_connect_info->[0]; if (ref($dsn) eq 'CODE') { - croak 'cannot change the DBI DSN on a CODE ref connect_info'; + $self->throw_exception('cannot change the DBI DSN on a CODE ref connect_info'); } if ($dsn !~ /MARS_Connection=/) { @@ -171,6 +175,14 @@ sub connect_call_use_MARS { } } +sub _get_mssql_version { + my $self = shift; + + my ($version) = $self->_get_dbh->get_info(18) =~ /^(\d+)/; + + return $version; +} + 1; =head1 AUTHOR