Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database metadata

 
Sarada Bhasker
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The getTables method of Databasemetadata is not returing any rows
for the SQL server
 
George Toronto
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, could you tell me the JDBC driver for SQL Server? It seems you know that, right?
thanx
George
 
George Toronto
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can someone reply for this please?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic