From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | "VANOLE, MICHAEL J" <mv5492(at)att(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Using Pg JDBC driver with perl DBD::JDBC |
Date: | 2016-07-06 18:01:12 |
Message-ID: | CADK3HHKKmOF=DhPWoPPX=o0aWeonm5eH_CeRbxYvN25WJSdHNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
looks like perl DBD is putting a returning statement in. So does JDBC
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
On 6 July 2016 at 11:39, VANOLE, MICHAEL J <mv5492(at)att(dot)com> wrote:
> Hi,
>
>
>
> I currently use DBD:Pg for interfacing perl and Postgres, but I want to
> try using the Postgres jdbc driver with DBD::JDBC. I use DBD::JDBC v 1.49
> for several other databases. They all work without an issue except for the
> Pg driver
>
>
>
> I installed postgresql-9.4.1208.jar to use against my postgres database at
> version 9.4.2.
>
>
>
> DBD:JDBC server runs the driver fine
>
>
>
> 9605 29:19 java -DVTIER=127.0.0.1
> -Djdbc.drivers=org.postgresql.Driver -Ddbd.port=9005
> com.vizdom.dbd.jdbc.Server
>
>
>
> I can also make a connection.
>
>
>
> my $url = qq{jdbc:postgresql://localhost:5432/www};
>
> my $dsn = qq{dbi:JDBC:hostname=127.0.0.1;port=9005;url=$url};
>
>
>
> my $dbh = DBI->connect($dsn,'user',
> 'password',{PrintError=>0,RaiseError=>0,AutoCommit=>1});
>
> my $application_logging = qq/SET application_name = ‘Sales Reporting'/;
>
>
>
> But when any statement is executed I get the message below but with a
> different Position number
>
> $dbh->do($application_logging);
>
>
>
> DBD::JDBC::db do warning: ERROR: syntax error at or near "RETURNING"
>
> Position: 40
>
>
>
> The statements seem to be working.
>
>
>
> I’ve searched through the JDBC.pm and DBI.pm source for a clue. I don’t
> find the “RETURNING” string.
>
>
>
> My question for the group is whether or not this message is coming from
> the JDBC driver? This message is a warning and an error so I’m not sure it
> can be ingored. It is returned with or without PrintError=>1
>
>
>
> Thank you, Mike
>
From | Date | Subject | |
---|---|---|---|
Next Message | VANOLE, MICHAEL J | 2016-07-06 18:28:21 | Re: Using Pg JDBC driver with perl DBD::JDBC |
Previous Message | VANOLE, MICHAEL J | 2016-07-06 15:39:49 | Using Pg JDBC driver with perl DBD::JDBC |