Unix Technical Forum

Can't Find Any Tables with DatabaseMetaData.getTables()

This is a discussion on Can't Find Any Tables with DatabaseMetaData.getTables() within the pgsql Novice forums, part of the PostgreSQL category; --> I've created a Postgres 8.1 database and when I log into Postgres, I can see that the tables and ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 09:35 PM
ccrupper
 
Posts: n/a
Default Can't Find Any Tables with DatabaseMetaData.getTables()

I've created a Postgres 8.1 database and when I log into Postgres, I
can see that the tables and columns I've created exist. Within my
application, I can create a java.sql.Connection and can fetch the
DatabaseMetaData. However, when I call DatabaseMetaData.getTables(),
no tables are returned.

I have been able to get the application code working with Oracle and
MySQL databases, so I'm confident that the problem lies with my
Postgres configuration, but I can't think of what it might be. I think
that perhaps I don't properly understand the relationship between roles
and users within Postgres and I've tried re-creating the database with
various users and trying to build my database connection with different
users, but I'm still stumped. I've created one user (A SuperUser) in
addition to the postgres SuperUser and assigned that user to a
SuperUser role of the same name. This user, in addition to the
postgres user, are the ones with which I've been trying to login.

Does anyone have any ideas?

Thanks in advance!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:31 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com