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

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