1 package DBIx::Class::Storage::DBI::ODBC::ACCESS;
5 use base qw/DBIx::Class::Storage::DBI/;
10 my $ERR_MSG_START = __PACKAGE__ . ' failed: ';
14 my ( $source, $to_insert ) = @_;
16 my $bind_attributes = $self->source_bind_attributes( $source );
17 my ( undef, $sth ) = $self->_execute( 'insert' => [], $source, $bind_attributes, $to_insert );
19 #store the identity here since @@IDENTITY is connection global and this prevents
20 #possibility that another insert to a different table overwrites it for this resultsource
21 my $identity = 'SELECT @@IDENTITY';
22 my $max_sth = $self->{ _dbh }->prepare( $identity )
23 or $self->throw_exception( $ERR_MSG_START . $self->{ _dbh }->errstr() );
24 $max_sth->execute() or $self->throw_exception( $ERR_MSG_START . $max_sth->errstr );
26 my $row = $max_sth->fetchrow_arrayref()
27 or $self->throw_exception( $ERR_MSG_START . "$identity did not return any result." );
29 $self->{ last_pk }->{ $source->name() } = $row;
36 my ( $result_source ) = @_;
38 return @{ $self->{ last_pk }->{ $result_source->name() } };
41 sub bind_attribute_by_data_type {
44 my ( $data_type ) = @_;
46 return { TYPE => $data_type } if $data_type == DBI::SQL_LONGVARCHAR;
51 sub sqlt_type { 'ACCESS' }
57 DBIx::Class::Storage::DBI::ODBC::ACCESS - Support specific to MS Access over ODBC
61 I am not a DBI, DBIx::Class or MS Access guru. Use this module with that in
64 This module is currently considered alpha software and can change without notice.
68 This class implements support specific to Microsoft Access over ODBC.
70 It is loaded automatically by by DBIx::Class::Storage::DBI::ODBC when it
71 detects a MS Access back-end.
73 =head1 SUPPORTED VERSIONS
75 This module have currently only been tested on MS Access 2003 using the Jet 4.0 engine.
77 As far as my knowledge it should work on MS Access 2000 or later, but that have not been tested.
78 Information about support for different version of MS Access is welcome.
80 =head1 IMPLEMENTATION NOTES
82 MS Access supports the @@IDENTITY function for retrieving the id of the latest inserted row.
83 @@IDENTITY is global to the connection, so to support the possibility of getting the last inserted
84 id for different tables, the insert() function stores the inserted id on a per table basis.
85 last_insert_id() then just returns the stored value.
87 =head1 KNOWN ACCESS PROBLEMS
91 =item Invalid precision value
93 This error message is received when trying to store more than 255 characters in a MEMO field.
94 The problem is (to my knowledge) an error in the MS Access ODBC driver. The problem is fixed
95 by setting the C<data_type> of the column to C<SQL_LONGVARCHAR> in C<add_columns>.
96 C<SQL_LONGVARCHAR> is a constant in the C<DBI> module.
100 =head1 IMPLEMENTED FUNCTIONS
102 =head2 bind_attribute_by_data_type
104 This function currently supports the SQL_LONGVARCHAR column type.
108 =head2 last_insert_id
114 Most likely. Bug reports are welcome.
118 Øystein Torget C<< <oystein.torget@dnv.com> >>
122 You may distribute this code under the same terms as Perl itself.
124 Det Norske Veritas AS (DNV)