From: | Mansour Al Akeel <mansour(dot)alakeel(at)gmail(dot)com> |
---|---|
To: | dmp <danap(at)ttc-cmc(dot)net> |
Cc: | PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Reading schema information |
Date: | 2015-05-25 14:51:50 |
Message-ID: | CAFvvX=bq1Ug1-LUUej3Xn4c-SgJREuLZGUO1e7b4JWuOBjKACA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Please note, I am still using :
Connection conn = DriverManager.getConnection(info.getUrl(),
info.getUser(), info.getPassword());
DatabaseMetaData metaData = conn.getMetaData();
So I am getting the meta data of the whole data base, and I didn't try
your method yet. You method obtains the meta data for each table as
far as I understand.
On Mon, May 25, 2015 at 6:49 PM, Mansour Al Akeel
<mansour(dot)alakeel(at)gmail(dot)com> wrote:
> Hello,
>
> Yes I did a search and couldn't find anything. This line of code is
> generating the same exception:
>
> String SCOPE_CATALOG = fields.getString("SCOPE_CATALOG");
>
>
>
> On Mon, May 25, 2015 at 6:58 PM, dmp <danap(at)ttc-cmc(dot)net> wrote:
>> dmp wrote:
>>>
>>> Mansour Al Akeel wrote:
>>>>
>>>> Sorry for missing the email subject in my previous email !
>>>>
>>>> I am trying to get some information about a coloum using the method:
>>>>
>>>> DatabaseMetaData.getString("IS_GENERATEDCOLUMN")
>>>>
>>>> However it is throwing an exception:
>>>>
>>>> org.postgresql.util.PSQLException: The column name IS_GENERATEDCOLUMN
>>>> was not found in this ResultSet.
>>>>
>>>> Based on javadoc for getColumns method:
>>>>
>>>>
>>>> http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)
>>>>
>>>>
>>>>
>>>> We have:
>>>>
>>>> IS_GENERATEDCOLUMN String => Indicates whether this is a generated column
>>>>
>>>> YES --- if this a generated column
>>>> NO --- if this not a generated column
>>>> empty string --- if it cannot be determined whether this is a generated
>>>> column
>>>>
>>>>
>>>> My questions is, is this a bug ? if not, how can I obtain this
>>>> information about a column (if it's generated or not) ?
>>>>
>>>>
>>>> Thank you.
>>>>
>>
>> Hello,
>>
>> I'm sorry, after testing, currently the given name IS_GENERATEDCOLUMN is
>> given the error as you describe. The index of 23 can be used to obtain the
>> results desired.
>>
>> Did you search the mailing list for a report or issue on this?
>>
>> danap.
>>
From | Date | Subject | |
---|---|---|---|
Next Message | dmp | 2015-05-25 14:58:11 | Re: Reading schema information |
Previous Message | Mansour Al Akeel | 2015-05-25 14:49:53 | Re: Reading schema information |