Re: Using Pg JDBC driver with perl DBD::JDBC

Line 1195 and this comment…

 

// If given user provided column names, quote and escape them.

 

// This isn't likely to be popular as it enforces case sensitivity,

// but it does match up with our handling of things like

// DatabaseMetaData.getColumns and is necessary for the same

 

// reasons.

 

 

 

From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Wednesday, July 06, 2016 1:38 PM

To: VANOLE, MICHAEL J <mv5492@att.com>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Using Pg JDBC driver with perl DBD::JDBC

 

https://github.com/pgjdbc/pgjdbc/blob/7311b4ef160231780323573911c1543d0515340b/pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java#L1195

Dave Cramer

davec@postgresintl.com

www.postgresintl.com

 

On 6 July 2016 at 14:28, VANOLE, MICHAEL J <mv5492@att.com> wrote:

I have confirmed that the statements I execute are not working. It does look like what you suggest based on the warning. I just can’t find it in the source which is why I’m asking about the postgres jdbc source.

 

Thanks

Mike

 

 

From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Wednesday, July 06, 2016 1:01 PM
To: VANOLE, MICHAEL J <mv5492@att.com>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Using Pg JDBC driver with perl DBD::JDBC

 

looks like perl DBD is putting a returning statement in. So does JDBC

Dave Cramer

davec@postgresintl.com

www.postgresintl.com

 

On 6 July 2016 at 11:39, VANOLE, MICHAEL J <mv5492@att.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