aspose file tools*
The moose likes JDBC and the fly likes database metadata Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "database metadata" Watch "database metadata" New topic
Author

database metadata

Sarada Bhasker
Ranch Hand

Joined: Sep 11, 2000
Posts: 94
The getTables method of Databasemetadata is not returing any rows
for the SQL server
George Toronto
Ranch Hand

Joined: Dec 30, 2000
Posts: 78
Hi, could you tell me the JDBC driver for SQL Server? It seems you know that, right?
thanx
George
George Toronto
Ranch Hand

Joined: Dec 30, 2000
Posts: 78
Hi, could you tell me the JDBC driver for [font size=15 color=red]SQL Server[/font]? It seems you know that, right?
thanx
George
Sarada Bhasker
Ranch Hand

Joined: Sep 11, 2000
Posts: 94
Thanks for the response. The driver I used is sun.jdbc.odbc.JdbcOdbcDriver and the the piece of code is
public ResultSet getTables() throws SQLException
{
dbMetaData = dbCon.getMetaData();
return dbMetaData.getTables(null,null,null,tableTypes);
}
I don't know whether I need to do something on the SQL server side to access the metadata. I am using the pubs database.

[This message has been edited by Sarada Bhasker (edited March 02, 2001).]
Sarada Bhasker
Ranch Hand

Joined: Sep 11, 2000
Posts: 94
can someone reply for this please?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: database metadata