Re: Problem with java.sql.DatabaseMetaData

Holger,

This has come up before, and I think the resolution was that you are
right they should be converted to lower case. The challenge comes when
you do create a table with upper case using single quotes, how do you
find it?

Dave

On Thu, 2002-06-06 at 10:10, Mitterwald, Holger wrote:
> Hello, I still have some problems with
> the methods
> getIndexInfo()
> and
> getTables()
> 
> In my opinion it shouldn't matter if I define the tablenames
> in lowercase or in mixed/uppercase like in "normal" sql-statements.
> There the both statements are equal:
> select * from customer....
> and
> select * from Customer...
> 
> But in the jdbc driver you have to put all the table names in both methods
> as lowercase - otherwise no Tables are found.
> 
> So shouldn't the JDBC-driver automatically convert the tablenames to lowercase?????
> 
> Best regards,
>    Holger
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
>