1 package DBIx::Class::Storage::DBI::ODBC::Firebird;
6 DBIx::Class::Storage::DBI::ODBC
7 DBIx::Class::Storage::DBI::Firebird::Common
15 DBIx::Class::Storage::DBI::ODBC::Firebird - Driver for using the Firebird RDBMS
20 Most functionality is provided by
21 L<DBIx::Class::Storage::DBI::Firebird::Common>, see that driver for details.
23 To build the ODBC driver for Firebird on Linux for unixODBC, see:
25 L<http://www.firebirdnews.org/?p=1324>
27 This driver does not suffer from the nested statement handles across commits
28 issue that the L<DBD::InterBase|DBIx::Class::Storage::DBI::InterBase> or the
29 L<DBD::Firebird|DBIx::Class::Storage::DBI::Firebird> based driver does. This
30 makes it more suitable for long running processes such as under L<Catalyst>.
34 __PACKAGE__->datetime_parser_type ('DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format');
36 # batch operations in DBD::ODBC 1.35 do not work with the official ODBC driver
40 $self->next::method(@_);
42 if ($self->_dbh_get_info('SQL_DRIVER_NAME') eq 'OdbcFb') {
43 $self->_get_dbh->{odbc_disable_array_operations} = 1;
47 # releasing savepoints doesn't work for some reason, but that shouldn't matter
48 sub _exec_svp_release { 1 }
50 sub _exec_svp_rollback {
51 my ($self, $name) = @_;
54 $self->_dbh->do("ROLLBACK TO SAVEPOINT $name")
57 # Firebird ODBC driver bug, ignore
58 if (not /Unable to fetch information about the error/) {
59 $self->throw_exception($_);
64 package # hide from PAUSE
65 DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format;
67 # inherit parse/format date
68 our @ISA = 'DBIx::Class::Storage::DBI::InterBase::DateTime::Format';
70 my $timestamp_format = '%Y-%m-%d %H:%M:%S.%4N'; # %F %T
75 require DateTime::Format::Strptime;
76 $timestamp_parser ||= DateTime::Format::Strptime->new(
77 pattern => $timestamp_format,
80 return $timestamp_parser->parse_datetime(shift);
85 require DateTime::Format::Strptime;
86 $timestamp_parser ||= DateTime::Format::Strptime->new(
87 pattern => $timestamp_format,
90 return $timestamp_parser->format_datetime(shift);
97 See L<DBIx::Class/AUTHOR> and L<DBIx::Class/CONTRIBUTORS>.
101 You may distribute this code under the same terms as Perl itself.