Re: DatabaseMetaData.getTables() resultset empty?

[Ole Ersoy]

Hi,

I left the catalog as null:

ResultSet resultSet2 = metaData.getTables(null, "%", "%", types);

but the resultset is still empty.  I did manage to duplicate Dyre's test 
though.  I'll comment more in that thread.

Thanks,
- Ole



Suavi Ali Demir wrote:

Plz leave catalog as null.
Ali


--- On Sun, 11/9/08, Ole Ersoy <[EMAIL PROTECTED]> wrote:

From: Ole Ersoy <[EMAIL PROTECTED]>
Subject: Re: DatabaseMetaData.getTables() resultset empty?
To: "Derby Discussion" <derby-user@db.apache.org>
Date: Sunday, November 9, 2008, 8:29 PM
Ali,

I had percentage for the tableNamePattern argument, so I
assume you mean try it for the other arguments as well:

                String[] types = {"TABLE", "VIEW"};
//              ResultSet resultSet2 = metaData.getTables(null, null,
"%", types);
                ResultSet resultSet2 = metaData.getTables("%",
"%", "%", types);
Still no love.

Thanks though,
- Ole