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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | arkin | 2001-03-12 22:19:39 | Re: connection pooling in JDBC driver |
Previous Message | Gregory Bittar | 2001-03-12 20:30:47 | Re: callable statements, latest snapshot |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-03-13 09:08:09 | Re: ODBC Driver regedit file. |
Previous Message | Peter Mount | 2001-03-12 20:19:03 | Re: JDBC build patches |