[teiid-issues] [JBoss JIRA] (TEIID-2612) Teiid ODBC compatibility with perl-DBD-Pg for postgresql is broken

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-2612.
---------------------------------


    
> Teiid ODBC compatibility with perl-DBD-Pg for postgresql is broken
> ------------------------------------------------------------------
>
>                 Key: TEIID-2612
>                 URL: https://issues.jboss.org/browse/TEIID-2612
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 8.5
>            Reporter: Graeme Gillies
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> Hi,
> We are testing the git head of teiid 8.5 in JBoss EAP 6.1, running with java 7, and are attempting to connect to teiid using perl-DBD-Pg.
> We have a code snippet that looks like
> {noformat}
> #! /usr/bin/perl
> use strict;
> use warnings;
> use DBI;
> my $db_type = 'Pg';
> my $db_name = 'TestZipVDB';
> my $db_host = 'teiid.host';
> my $db_port = 5432;
> my $user = 'teiid';
> my $pass = 'teiid';
> my $attr = { AutoCommit => 0, RaiseError => 1 };
> my $dsn = sprintf( "dbi:%s:dbname=%s;host=%s;port=%s;sslmode=prefer",
>     $db_type, $db_name, $db_host, $db_port );
> my $dbh = DBI->connect( $dsn, $user, $pass, $attr );
> my $query = <<QUERY;
> select count(1) from bugzilla.bugs
> QUERY
> my $sth = $dbh->prepare($query);
> $sth->execute();
> while ( my @row = $sth->fetchrow_array() ) {
>     print join( ',', map {"\"$_\""} @row ) . "\n";
> }
> $sth->finish();
> $dbh->disconnect();
> {noformat}
> However when running this with ssl turned on or off we get the following error
> {noformat}
> DBD::Pg::st execute failed: unexpected response from server; first received character was "s" at ./a.pl line 25.
> DBD::Pg::st execute failed: unexpected response from server; first received character was "s" at ./a.pl line 25.
> Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=TestZipVDB;host=teiid.host;port=5432 at ./a.pl line 25.
> {noformat}
> It seems that ODBC/Pg Compatibility was broken with a recent commit?
> We git this error on a RHEL-6 box running postgresql 8.4 and on Fedora 19 running postgresql 9.2
> Regards,
> Graeme

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira