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

Re: getTables is this right?

From: Eric Frazier <ef(at)kwinternet(dot)com>
To: Peter Mount <peter(at)retep(dot)org(dot)uk>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, <pgsql-jdbc(at)postgresql(dot)org>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: getTables is this right?
Date: 2001-03-12 21:43:55
Message-ID: 2.2.32.20010312214355.0105d204@kwinternet.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-patches
Hi,

Thanks greatly for all of your help. 

I found that my "unexplained error" with building 7.1 with ant was because I
already had a database
named test in postgress. I just renamed the db in the Build.xml to test2 and
everything went just fine. 

I still can not return a result set with non null values from 7.0-1.2 The
TABLE_TYPE is always null. 
I did make sure to have no nulls in my String [] ,but even when I used a
null in place of the String [] I didn't get the TABLE_TYPE

But it is ok now, I got the 7.1 beta driver working and it is not having any
such problems. :) 

Thanks for your time.

Eric 

At 03:57 PM 3/12/01 +0000, Peter Mount wrote:
>At 23:39 09/03/01 -0800, Eric Frazier wrote:
>
>>Hi,
>>
>>I am having problems getting info on tables with getTables. I get null
>>returned all of the time.
>
>Where is it returning null? It should always return a result set.
>
>>I was using this code
>>
>>snip:
>>
>>//String [] onlytables = new String[3];
>>             //onlytables[0] = "TABLE";
>>             //onlytables[1] = "INDEX";
>>             ResultSet tableRS =
>>m_inputCon.getMetaData().getTables(null,null,"%",null);
>>
>>/* I had used the String [] onlytables in place of null, but I got
>>
>>         java.sql.SQLException: ERROR:  parser: parse error at or near ")"
>


Frazier Consulting
http://www.kwinternet.com/eric
(250) 655 - 9513




pgsql-patches by date

Next:From: Hiroshi InoueDate: 2001-03-13 09:08:09
Subject: Re: ODBC Driver regedit file.
Previous:From: Peter MountDate: 2001-03-12 20:19:03
Subject: Re: JDBC build patches

pgsql-jdbc by date

Next:From: arkinDate: 2001-03-12 22:19:39
Subject: Re: connection pooling in JDBC driver
Previous:From: Gregory BittarDate: 2001-03-12 20:30:47
Subject: Re: callable statements, latest snapshot

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