Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

database metadata  RSS feed

 
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!