Skip site navigation (1) Skip section navigation (2)

BUG #1155: AbstractJdbc2ResultSet:parseQuery ; in tablename

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1155: AbstractJdbc2ResultSet:parseQuery ; in tablename
Date: 2004-05-22 16:58:16
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1155
Logged by:          David Brownlee

Email address:      abs(at)mono(dot)org

PostgreSQL version: 7.4

Operating system:   NetBSD

Description:        AbstractJdbc2ResultSet:parseQuery ; in tablename


In AbstractJdbc2ResultSet:parseQuery can end up leaving a ; on the end of a 
tablename, which when later used in isUpdateable() will choke. 
The following 'fixes' it:

--- org/postgresql/jdbc2/       2004-05-21 
:29.000000000 +0100
+++ org/postgresql/jdbc2/
@@ -1448,7 +1450,7 @@ public abstract class AbstractJdbc2Resul
                                if (name.toLowerCase().equals("from"))
-                                       tableName = st.nextToken();
+                                       tableName = 
", "");
                                        tableFound = true;

This was found while writing a small java tool to copy the contents of one 
database to another, which can be provided to demonstrate the problem on 
request. Would have attached it here if there had been an option :) 


pgsql-bugs by date

Next:From: Kris JurkaDate: 2004-05-24 19:05:02
Subject: Re: BUG #1155: AbstractJdbc2ResultSet:parseQuery ; in tablename
Previous:From: Michael MeskesDate: 2004-05-22 11:26:43
Subject: Re: Embedded SQL library bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group