Re: Simple queries with JDBC escaped scalar functions result in exceptions

From: danap <danap(at)itstriangle(dot)com>
To: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Simple queries with JDBC escaped scalar functions result in exceptions
Date: 2016-08-28 17:17:15
Message-ID: 57C31C9B.8080607@itstriangle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dave Cramer wrote:
> Looks like the JDBC mini parser is having troubles with that.

> Why do you have comments in your sql ?
>
> Dave Cramer
>

MyJSQLView SQL schema dump. All databases that my application supports
comments, and is documented.

--
-- MyJSQLView SQL Dump
-- Version: 7.07
-- WebSite: http://myjsqlview.com
--
-- Host: 127.0.0.1
-- Generated On: 2016.05.08 AD at 02:11:28 MDT
-- SQL version: PostgreSQL 9.4.1
-- Database: key_tables
--

-- ------------------------------------------

--
-- Table structure for table "public"."procedure_files"
--

DROP TABLE IF EXISTS "public"."procedure_files";
CREATE TABLE "public"."procedure_files" (
"id" serial NOT NULL,
"procedure_id" integer DEFAULT NULL,
"file_name" varchar(null) DEFAULT NULL,
"file_oid" oid DEFAULT NULL
);

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mithun Cy 2016-08-30 09:24:57 Re: Patch: Implement failover on libpq connect level.
Previous Message Adam Rauch 2016-08-28 17:02:55 Re: Simple queries with JDBC escaped scalar functions result in exceptions