Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSetMetaData Problem

 
Srinivasa Vallabha
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
I'm using Oracle thin driver,
I want to get the table name from any query's resultset
using ResultSetMetaData's getTableName(int) method. But it gives
only a blank as result. But when I used ODBC driver and MS-Access
it is giving me the required table name. So how to solve this problem ?
Thanks in advance
Srinivasa.V
 
Kripal Singh
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
probably you need to install latest oracle thin driver(classes12.zip)
check out this post
http://www.javaranch.com/ubb/Forum3/HTML/000253.html
 
Kripal Singh
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
looked into oracle Discussion Groups of SQLJ/JDBC check the following links
http://technet.oracle.com:89/ubb/Forum8/HTML/000029.html http://technet.oracle.com:89/ubb/Forum8/HTML/002948.html
 
Srinivasa Vallabha
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I'm using classes12.zip only but still i'm getting "" when I use ResultSetMetaData.getTableName() and when I use Ms-Access it is ging me the proper table name.
Please help me
Srini
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic